How to save selected columns of Grid in UI.

[AP_10343008]

On right clicking column heading in grid, we can deselect certain columns. We expecting the selected columns to be save until it is changing manually in UUser Interface. But Once I reloaded the page, the grid columns are resetting back and displaying all columns. 

How to save selected columns of Grid in UI.?

[Velkumar]

Hi @AP_10343008 

Could you please tell Thingworx version and which grid (New Grid - 9.4, Grid, Advance Grid) used mashup?

Also if possible post some screenshot

/VR

[AP_10343008]

Thingworx version is ThingWorx 9.1.0-b10877

Widget - gridadvanced

If I unchecked columns names in grid, on refreshing page the changes should remain same.

[Velkumar]

Hi @AP_10343008 

Unfortunately, this cannot be achieved because you won't get selected/unselected columns as output in runtime.

But you can make use of configuration JSON to unhide/hide columns based on user/user selection.

For example :

In this example based on the selected type, grid columns will vary

You can achieve something like this

More about Grid Configuration JSON - Configuring the Grid using JSON Data (ptc.com)

/VR

/VR

[slangley]

Hi @AP_10343008.

With 9.3, PTC added a new grid widget with cache runtime changes, column order, column sizing, and column visibility.  It would be a good idea for you to upgrade given the fact that the version you are running is no longer supported.

Regards.

--Sharon