Skip to main content
J
JO_993058514-Alexandrite
14-Alexandrite
October 2, 2025
Solved

Creating a Footer for the Grid widget using JSON configuration data

  • October 2, 2025
  • 1 reply
  • 783 views

I have a grid widget with dynamic columns. Because of this, I am using the JSON configuration to map instead of a standard datashape. With that said, I cannot get the footer to enable on the grid. The examples in the GridAdvancedExampleServices Thing use 

"enableFooter": true

 but this doesn't work. In the grid widget it is called "ShowFooter" so I tried changin "enableFooter" to this and "showFooter" with no luck.

 

How do I enable the footer via the JSON configuration?

Best answer by PEHOWE

Hello @JO_9930585 ,
I have taken a look at the issue of using Grid Widget with JSON defined table.
There appears to be a few items with getting the configuration correct. 
Here are the steps I believe you need to follow. Please review and let me know if you have questions.

  • Define a Mashup
  • Add a Grid Widget to the Mashup
  • Update the properties for the Grid Widget
    • Check the "ShowFooter", this will add
      • ShowHeaderRowInFooter
      • FooterData
    • Create a service which creates an InfoTable for the footer
    • Bind the InfoTable from the service output to the FooterData
  • Create a service to generate a JSON which describes the Grid you need.
    • The JSON need to have :  "enableFooter"
    •  "enableFooter": true,

Let me know if you have any questions

Regards,
Pehowe

1 reply

S
Surya_Tiwari16-Pearl
16-Pearl
October 3, 2025

Hi @JO_9930585   look at the link below, and let us know your ThingWorx version details.

 

https://support.ptc.com/help/thingworx/platform/r10.0/en/index.html#page/ThingWorx/Help/Mashup_Builder/Widgets/FooterSectionInBothAdvancedGrids.html#wwID0EZURLB

J
JO_993058514-AlexandriteAuthor
14-Alexandrite
October 3, 2025

This is version 9.6. 

 

This doesn't work in my version. enableFooter = true does nothing. The example services work, but not the footer portion does not. I think this is probably a bug.

 

I did a workaround by putting totals in the top row of the returned data. I was trying to avoid this since this grid is editable. With that said, if they try to edit the totals, it will simply error out and do nothing. Not ideal, but it is fine.

P
PEHOWE17-PeridotAnswer
17-Peridot
October 22, 2025

Hello @JO_9930585 ,
I have taken a look at the issue of using Grid Widget with JSON defined table.
There appears to be a few items with getting the configuration correct. 
Here are the steps I believe you need to follow. Please review and let me know if you have questions.

  • Define a Mashup
  • Add a Grid Widget to the Mashup
  • Update the properties for the Grid Widget
    • Check the "ShowFooter", this will add
      • ShowHeaderRowInFooter
      • FooterData
    • Create a service which creates an InfoTable for the footer
    • Bind the InfoTable from the service output to the FooterData
  • Create a service to generate a JSON which describes the Grid you need.
    • The JSON need to have :  "enableFooter"
    •  "enableFooter": true,

Let me know if you have any questions

Regards,
Pehowe

    Terms & ConditionsCookie settingsAccessibility statement