Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
11 replies
Subscribers
7 subscribers
Views
5288 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
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
OriginalPostID-260398
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
>