Fail to sort data

Hi All,

We're facing while using Sail Grid. Please find problem explained below.Any help is much appreciated.

We're fetching the data using query record and that data is displayed in a Grid component.

Now when we try to sort the grid data by clicking on a column header then it fails to sort the data for that column and it remains sorted on the default sort info that we provided at the time of fetching data from query record.


For your reference please find sample code below. Many Thanks in advance.


=load(
local!pagingInfo: topaginginfo(1, 10),
with(
local!data: =queryrecord(
recordType: cons!COMPANY_AUDIT_LOG,
query: 'type!{www.appian.com/.../2009}Query'(
'selection|aggregation': 'type!{www.appian.com/.../2009}Aggregation'(
columns: {
'type!{www.appian.com/.../2009}AggregationColumn'(
field: "full_name",
alias: "label",
visible: true,
...

OriginalPostID-91648

OriginalPostID-91648

  Discussion posts and replies are publicly visible

Parents
  • Hi anjannat,

    Many thanks for your suggestion.

    We tried the workaround suggested by you, but still we're facing the same problem i.e. "Expression evaluation error at function 'todatasubset' [line 35]: Error evaluating function 'todatasubset' : java.lang.IllegalArgumentException: The given data type is not a record type: Dictionary (id=94)". It seems that there is some problem with sortinfo that we are providing in our expression. Can you please provide some more suggestions.

    Many thanks in advance.
    Sandeep
Reply
  • Hi anjannat,

    Many thanks for your suggestion.

    We tried the workaround suggested by you, but still we're facing the same problem i.e. "Expression evaluation error at function 'todatasubset' [line 35]: Error evaluating function 'todatasubset' : java.lang.IllegalArgumentException: The given data type is not a record type: Dictionary (id=94)". It seems that there is some problem with sortinfo that we are providing in our expression. Can you please provide some more suggestions.

    Many thanks in advance.
    Sandeep
Children
No Data