Question on using a!query with grids

hussameldin seddik over 8 years ago

i have a grid that get all columns using a!query except one column is calculated by a rule using apply(rule , data)
when the user try to sort using the column that has calculated data the sorting fails and the error message display that the column doesn't exist
Any ideas whats causing this ?

Discussion posts and replies are publicly visible

Parents

0 marky over 8 years ago

Creating the dictionary will have to be done in the load (or else the paging won't work correctly). I think the better approach is to build and optimize a view with the additional calculated column, that way the data can be retrieved in a with as well. There are some ways to handle sorting paging for a calculated column where the data must be in a with, but those options are more advanced and can be messy.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 marky over 8 years ago

Creating the dictionary will have to be done in the load (or else the paging won't work correctly). I think the better approach is to build and optimize a view with the additional calculated column, that way the data can be retrieved in a with as well. There are some ways to handle sorting paging for a calculated column where the data must be in a with, but those options are more advanced and can be messy.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data