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

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...

OriginalPostID-155401

OriginalPostID-155401