Hi, I have created a view as below. select column1, column2 from

1. Does your CDT has a field marked as @Id? (even if it's a view you need to mark a field as the primary key)
2. Does that column contain only unique values?
3. Your paging info doesn't have any sorting. See how sorting can be done at Appian:
forum.appian.com/.../Grid_Tutorial.html

local!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: 20,
sort: a!sortInfo(
field: "expenseDate",
ascending: false
)
)

Use case is I need to sort based on the three columns, also provide the functionality to select and resort after clicking on the column header.

1. I cannot sort on three columns on query entity
2. If I use todatasubset to sort on three columns then as soon as I select any record in grid I loose my sorting.

Please suggest any alternate approach.

You have to declare field property of each a!gridTextColumn used to create Grid with data field and redefine your pagingInfo as
local!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: cons!FSLS_GRID_BATCH_SIZE,
sort: a!sortInfo(
field: "Id",
ascending: false
)
)

requirement is to sort on three columns and when they select the order in grid field it should not change the sorting but it should change when they click on the column name. Above piece of code will not work.