Grid Configuration

[DJ_9847497]

I'm currently binding a grid configuration from a service to the Advanced Grid. Everything works fine - except I can no longer see the binding to get the EditedTable. 

Please let me know how this can be done?

Using version 9.3.4

[Rocko]

Not sure what's in your "Configuration" field, maybe an error there. Have you clicked the "IsEditable" checkbox? This should be there as well. Maybe add a fresh Grid Advanced to test. Or even better, move ahead to "Grid" widget instead, as Grid Advanced is legacy.

[DJ_9847497]

The isEditable is all in the configuration of the grid. Once I bind the configuration, the other properties are no longer visible to be bound. The new grids have features that are missing from the old grid and at this time we're forced to use the legacy advanced grid.  

[Rocko]

You will have to decide if you want to configure the widget either via service and the Configuration field or using direct binds.

In the first case, your configuration JSON will have to include the isEditable property with a true/false value to set it, plus the column configurations to set which columns are editable.

A sample of a JSON is given here: https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Mashup_Builder/Widgets/AdvancedGridsSamplesFile.html#

[DJ_9847497]

Hi,

I am trying to fully use the configuration. I have set the isEditable to true but I don’t have the edited data. What’s the point of editing if I can’t get the data binding to use it?

[Rocko]

Just do it the other way around. First bind EditedTable, then assign the Configuration. The binding will persist.

[DJ_9847497]

I tried that. The configuration doesn’t work if I do that. 

[Rocko · Accepted solution]

It worked for me with the AdvancedGridSampleFiles with GetEmployeeConfiguration and GetEmployeeData after adding

"cellEditingEnabled": true,
"editButtons": { "enabled": true,"location": "top-right", "enableAddDeleteButtons":true},

and then

"cellEditor": {"enabled": true } for each editable column  (as documented here)

to the configuration.

Before binding the Configuration I bound EditCompleted and EditedTable to a service.

[DJ_9847497]

The styles are different - do you know how I can set it to be the same style as the default?

Thanks

[Rocko]

No, sorry, I can only point you to this entry https://community.ptc.com/t5/ThingWorx-Developers/Grid-widget-dynamic-config-styling-and-column-sorting/m-p/779048#M56894%3Fsource=search or PTC Support search https://www.ptc.com/en/support/search/#q=advanced%20grid%20style