Syntax for "Sort Expression" within a Business View / Business Entity
M
Michael BARTLEY
started a topic
over 2 years ago
Hi there, I'm trying to create a custom sort on a Business Entity, and cant seem to find syntax that the designer will accept. I'd like to sort something like
1) Column A ASC
2) Columb B DESC
I can do this in excel for example, by building the sort criteria one at a time. within xDM I just have a blank box to input SemQL.
Can anyone share some examples of functioning multi-column sort expressions?
thank you
Best Answer
B
Bharat Joshi
said
over 2 years ago
Yes it is possible to do multi column sort expressions by applying the below semql
You can do this through UI as well by going to the option wizard and in sort records
Michael BARTLEY
Hi there, I'm trying to create a custom sort on a Business Entity, and cant seem to find syntax that the designer will accept. I'd like to sort something like
1) Column A ASC
2) Columb B DESC
I can do this in excel for example, by building the sort criteria one at a time. within xDM I just have a blank box to input SemQL.
Can anyone share some examples of functioning multi-column sort expressions?
thank you
Yes it is possible to do multi column sort expressions by applying the below semql
You can do this through UI as well by going to the option wizard and in sort records
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstBharat Joshi
Yes it is possible to do multi column sort expressions by applying the below semql
You can do this through UI as well by going to the option wizard and in sort records
Michael BARTLEY
this was super helpful. Thank you!!!
-
LOV label in Named Query
-
How we can set Dynamically changing Form field Description?
-
Is it possible to have a conditional survivorship rule based on a SemQL filter (akin to the filter on privileges)?
-
Where Do I View 2 Merged Records?
-
Show/hide an attribute in a form
-
Restrict access of attributes
-
Is it possible to manage visible/invisible value in List depend on user role??
-
Why am I unable to merge duplicates?
-
How are child records selected when parent records are manually merged?
-
Can the response from the API Call Response can be formatted differently in the JSON output?
See all 178 topics