Skip to main content
New Participant
November 22, 2022
Question

Sorting Not Working in Web Service backed Record

  • November 22, 2022
  • 3 replies
  • 0 views

Hi All,

I am Unable to do Sorting on Columns in Records Data Source is Webservice (Using an Expression rule to fetch The Data).

Sort Column is already added in Grid Section of Record.

Also i have Tried initial and Secondary Sort option availble in Record Section .

Secondary Sort:

{

a!sortInfo(
field: OneDate
ascending: false()
),
a!sortInfo(
field: twoDate
ascending: false()
)
}

Initial Sort:

 a!sortInfo(
field: dateField
ascending: false()
)

Its Working only when record Loads for First time

For next time when we click on column it is not working.

 

Thanks in Advance!!

3 replies

stefanhelzle0001
Brainy
November 22, 2022

Is this a synced record? Did you follow the tutorial "Service-Backed Record Type"? Does your web service support sorting? 

docs.appian.com/.../Service-Backed_Record_Tutorial.html

New Participant
November 22, 2022

Hi Stefan,

We are not using any External System to fetch data.

Data is fetch from local Database but for applying rules we are using an expression rule as data source instead of data store entity.(So data Source is Selected as Webservice)

in the rule we are casting the data to data subset. only the sort applied in a!datasubset() is working that to at initial Record load.

is it possible to have sorting on all the columns by clicking on the columns in records?

Thank you.

stefanhelzle0001
Brainy
November 22, 2022

Are you sure this is a good approach?

So, your data source supports sorting and paging. Did you follow the documentation?

docs.appian.com/.../configure-record-data-source.html