Skip to main content
Oct 23, 2021 8:18 AM UTC
Solved

Configure Grid Columns in Advanced Grid

Hi,

The Service(has datashape to) is binded to the Advanced Gird and can see the data in the Advance Grid, but when pressed on the Configure Grid Columns, it Says "Must be bound to data", not able to configure the columns

Thingworx version is 9.2
DeepinScreenshot_select-area_20211023132540.png
@paic @slangley @c_lowy 

Thanks,
Shashi.

Nov 27, 2021 9:31 AM UTC

Hi,

This issue is due to the permission issues, proper permission should be given to the Mashup you are using, such that Gird Columns can be Configured. That's the reason, was not able to edit them after proper bindings and using Datashape because of the Permissions.

Thanks,
Shashi

7 replies

Oct 25, 2021 8:21 PM UTC

Hi,

Please double check that the data shape is defined in the output for the service returning the data.  If the data shape is not defined here you can not configure the advanced grid columns.

 

Thanks,

 

Travis

Oct 26, 2021 6:04 AM UTC

Hi @TravisPickett ,

Double Checked, the DataShape is present and the data can be seen in the Advance Grid, but not able to configure the Grid columns as shown in the picture !!

Thanks,
Shashi.

Oct 26, 2021 12:58 PM UTC

Hi @pshashipreetham,

 

One additional thing to check that I can think of without Tech Support getting involved is that if the binding of the result of the service to the advanced grid was done before the service had the data shape defined:

  • Refresh the data tab
  • Brake the binding to the advanced grid, Save, and then re-add the binding
  • Brake the binding to the advanced grid, removed the advanced grid, Save, then add the grid back
    • In rare cases I have had todo this before.

 

Another test you can do to validate the data shape is being returned is to add a dropdown widget.  Bind your result to this widget and if you look under properties for display and value you should see the data shape labels here.

 

Thanks,

 

Travis

Nov 2, 2021 6:42 PM UTC

Hi @pshashipreetham.

 

If you feel the previous responses were helpful, please mark the appropriate one as the Accepted Solution for the benefit of others with the same question.

 

Regards.

 

--Sharon

Nov 4, 2021 7:16 PM UTC

Hi @pshashipreetham.

 

Is it possible that you are populating the grid dynamically at runtime?  If you need to configure grid columns, you may have to change your design.  For example, you may have to create an infotable for loading your data before populating the grid.  This page from the Help Center may also provide another solution.

 

Regards.

 

--Sharon

pshashipreethamAuthorAnswer
Nov 27, 2021 9:31 AM UTC

Hi,

This issue is due to the permission issues, proper permission should be given to the Mashup you are using, such that Gird Columns can be Configured. That's the reason, was not able to edit them after proper bindings and using Datashape because of the Permissions.

Thanks,
Shashi