Sorting for user in Grid Field

I am using grid field. I have added "field" to the gridTextColumn() and the sorting arrow came but it is not working on clicking. Do I need to configure anything else? Can you show me an example?

Hi Sudiptab,

Please see the below link:
docs.appian.com/.../recipe_display_data_with_cdt_fields_in_a_grid.html

The idea is to use load() to define your pagingInfo along with the sortInfo.
Then use with() to define your data and grid. The with() should save the paging info.

Let us know if this works,

Thanks

Hi Sudiptab,

Please see the below link:
docs.appian.com/.../recipe_display_data_with_cdt_fields_in_a_grid.html

The idea is to use load() to define your pagingInfo along with the sortInfo.
Then use with() to define your data and grid. The with() should save the paging info.

Let us know if this works,

Thanks

Hello Sudiptab,

Please Take a look at the recipe provided hemn89.

When quering the information you need to pass the paging info with the sort as you need, even you can sort with multiple fields.

In the gridfield you need to define on each column( a!gridTextColumn for example) the “field” parameter so each column will sort using that field, just use the field name as is in the CDT.


When the user clicks the column the paging info of the gridField gets updated using the saveInto of the gridField. So, additionally you can query again in the same saveInto.
Or the easy way is using the with function (as mentioned above) which works ok if you don’t have a bunch of other fields or grids, because the win will refresh each user interaction.

I am not able to provide an example but hope this explanation helps you

Jose