The sort capability isn't working on my grid, and I think it's because o

nickh647 over 9 years ago

The sort capability isn't working on my grid, and I think it's because of how I'm getting the data. Any ideas on how to do this so the sort will work when a user clicks on the column header?

1. Use a!queryEntity to get a datasubset with a batchSize -1 for paging to get all the rows
2. Filter the data and put it into a datasubset with a batchSize of 10 for paging
3. Display the filtered datasubset into a grid.

Here's some sample code:

load(
local!allRowsPaging: a!pagingInfo(startIndex:1, batchSize: -1),
local!gridSelection: a!gridSelection(pagingInfo: a!pagingInfo(startIndex:1, batchSize: 10)),
with(
local!datasubset1: rule!queryEntityFunction(local!allRowsPaging),
local!filteredData: rule!filterData(local!datasubset1.data),
local!datasubset2: todatasubset(local!filteredData, local!gridSelection.pagingInfo),

a!gridField(
totalCount: local!datasubset2.totalCount,
columns:{
a!gridTextColumn(lab...

Discussion posts and replies are publicly visible

0 nickh647 over 9 years ago

...el:"Name", field: "Name", data: index(local!datasubset2.data, "name", {})
},
identifiers: index(local!datasubset2.data, "id", {}),
value: local!gridSelection,
saveInto: local!gridSelection,
selection:true
)
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 9 years ago

@nickh Afaik following two steps should probably resolve the issue:
1. Using the pagingInfo function with the sort parameter. This will help you load the grid with default sort configuration.
Ex: a!pagingInfo(startIndex: 1,batchSize: -1,sort: a!sortInfo(field: "name",ascending: true()))
2. Using the exact field name as in the datasubset in the gridTextColumn function. I guess you haven't provided a correct value here, because documentation at https://forum.appian.com/suite/help/7.9/SAIL_Components.html#TextColumn says that we should use the field name that populates the data in the 'field' attribute of a!gridTextColumn() component.
Example: a!gridTextColumn(label:"Name", field: "name", data: index(local!datasubset2.data, "name", {})
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 nickh647 over 9 years ago

Thanks! You were right about the field name matching the data 'field' attribute. That solved the problem.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 9 years ago

@nickh Geat!!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sauravk over 5 years ago

I am also facing similar issue. But nothing is working.

a!gridTextColumn(
label: "Lead By",
field: "leadBy",
data: if(
rule!APN_isBlank(
ri!dataset.data
),
{},
a!forEach(
items: index(
ri!dataset.data,
"leadBy",
null
),
expression: rule!TEST_getLeadershipDetails(
fv!item
)
)
)
),

Same way passing local!paginfo variable .

Sorting is not working . Randomly data is coming.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel