Syntax for "Sort Expression" within a Business View / Business Entity
M
Michael_bartley
started a topic
9 months 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
9 months 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!!!
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 274 topics