Sorting functionality

pavanik

Certified Associate Developer

over 7 years ago

Hi,
I have created a paging grid with some columns.

For Ex: Employee Id , Experience and Department.

Requirement is like sorting based on Employee Id and Experience. So In department the logic is

a!gridTextColumn(
label: "Department",
field: "noSort",
data: index(
local!dataForCurrentPage,
"department",
null
)
),

I faced following error when I click on department column.

Could not display interface. Please check definition and inputs.
Interface Definition: Expression evaluation error: An error occurred while executing a save: Expression evaluation error in rule 'kp_ial_fetchfiltereddata' at function a!queryEntity: The field [noSort] does not exist.

Any suggestions to get this to work?

Thanks in advance

Discussion posts and replies are publicly visible

0 Sathya Srinivasan
Appian Employee
over 7 years ago

The error indicates that your data set does not have a field called noSort. That's the first step. The second is that the sort needs to be defined in the pagingInfo()
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Rama Thummala
Certified Lead Developer
over 7 years ago

@Pavani

Seems the issue is not with the interface I.e., gridTextColumn (). The issue is with the query entity you are using to fetch the data.Please share the query entity rule code.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 martinm over 7 years ago

Hi Pavani - replace "noSort" with "department". If you are using a paging grid, you will need to provide a field for each gridTextColumn. If you absolutely do not want to sort by department, you can change it to a different field such as "employeeId" instead. With that change, you will not be able to sort by department, but instead will always defer to the employeeId sort field instead. However, users usually find this un-intuitive, and I would recommend leaving the field as "department".
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chandu
A Score Level 2
over 7 years ago

In the a!gridTextColumn(
label:/* this field will be displayed in the Sail Interface to the User*/
field:/* refers to the field that we will get the data from the DB, this field must be the CDT field */
)
a!pagingInfo(
          startIndex:1,
          batchSize:10,
          sort:a!sortInfo(
                    field:/* The feild name that sort to be applied. again this field must be the CDT field*/,
                    ascending:true()/* depends on the requirement we can give true() or false()*/
          )
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Vinay Kumar Rai over 7 years ago

Hi Pravani, Multiple sorting is available on the version 16.3, and all the other lower versions system could not allow multiple sort features
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chandu
A Score Level 2
over 7 years ago

Yes, as vinay said multiple sorting is available on 16.3+ if you are using 16.3 you can sort on Employee Id and Experience.
forum.appian.com/.../Appian_Release_Notes.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Nagashankar Nallavalli over 7 years ago

Hi @Pavani

Adding to the above comments replace "noSort" with "department". But in your scenario you don't want sorting feature on department, for that you can change it with different field such as primary key of refering table or employee id filed.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 pavanik
Certified Associate Developer
over 7 years ago

Thanks everyone.
Glad to know your solutions and thoughts!
@Ramanjaneyulu Thummala, please find the following query entity rule in the below attachment..
queryentity.txt
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 pavanik
Certified Associate Developer
over 7 years ago

@satya, AFIK we can sort columns either paging info or field itself..let me know if i am wrong..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 pavanik
Certified Associate Developer
over 7 years ago

@chandrasekharg,@vinayr..
My current version is 16.3.
I am able to sort on Employee Id and Experience(multiple sorting). But in my scenario I don't want sorting feature on department.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel