Fail to sort data

skumar over 10 years ago

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

Discussion posts and replies are publicly visible

Parents

0 skumar over 10 years ago

...
                                                                                                              instructions: "Test",
                                                                                                              columns: {
                                                                                                                        if(local!data.totalCount>0,
                                                                                                                                  {
                                                                                                                                            'type!{www.appian.com/.../2009}GridTextColumn'(
                                                                                                                                                      label: "Analyst",
                                                                                                                                                      data: if(local!data.totalCount>0,index(local!data.data, "label", {}),{}),
                                                                                                                                                      field: "label"
                                                                                                                                            ),
                                                                                                                                            'type!{www.appian.com/.../2009}GridTextColumn'(
                                                                                                                                                      label: "# of Companies Created",
                                                                                                                                                      data: if(local!data.totalCount>0,index(local!data.data, "data", {}),{}),
                                                                                                                                                      field: "data"
                                                                                                                                            )
                                                                                                                                  },
                                                                                                                                  {
                                                                                                                                            'type!{www.appian.com/.../2009}GridTextColumn'(
                                                                                                                                            label: "Analyst",
                                                                                                                                            data: 0,
                                                                                                                                            field: "label"
                                                                                                                                            ),
                                                                                                                                            'type!{www.appian.com/.../2009}GridTextColumn'(
                                                                                                                                            label: "# of Companies Created",
                                                                                                                                            data: 0,
                                                                                                                                            field: ...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 skumar over 10 years ago

...
                                                                                                              instructions: "Test",
                                                                                                              columns: {
                                                                                                                        if(local!data.totalCount>0,
                                                                                                                                  {
                                                                                                                                            'type!{www.appian.com/.../2009}GridTextColumn'(
                                                                                                                                                      label: "Analyst",
                                                                                                                                                      data: if(local!data.totalCount>0,index(local!data.data, "label", {}),{}),
                                                                                                                                                      field: "label"
                                                                                                                                            ),
                                                                                                                                            'type!{www.appian.com/.../2009}GridTextColumn'(
                                                                                                                                                      label: "# of Companies Created",
                                                                                                                                                      data: if(local!data.totalCount>0,index(local!data.data, "data", {}),{}),
                                                                                                                                                      field: "data"
                                                                                                                                            )
                                                                                                                                  },
                                                                                                                                  {
                                                                                                                                            'type!{www.appian.com/.../2009}GridTextColumn'(
                                                                                                                                            label: "Analyst",
                                                                                                                                            data: 0,
                                                                                                                                            field: "label"
                                                                                                                                            ),
                                                                                                                                            'type!{www.appian.com/.../2009}GridTextColumn'(
                                                                                                                                            label: "# of Companies Created",
                                                                                                                                            data: 0,
                                                                                                                                            field: ...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data