I have 2 CDTs : "Employee" and "SecurityAccessCard". They ha

mayankk718 over 9 years ago

I have 2 CDTs : "Employee" and "SecurityAccessCard". They have one to one relationship between them. I have mapped "Employee" into a data store entity and querying it using a query rule. As I am using @OneToOne annotation in the XSD, my query rule will return the data of an "Employee" and the related data of the associated "SecurityAccessCard" as well. I want to sort the resultant data set (returned by my query rule) 2 be sorted based on 2 columns. The first column should be of "Employee" (consider any column for now) and the second column should be of "SecurityAccessCard" (consider any column for now). I believe we can use @OrderBy annotation for such purpose.

My question is, how should I use @OrderBy annotation for my use case ? My consolidated XSD (for both "Employee" and "SecurityAccessCard") is attached (referred the same from Appian Forum). Where should I place @OrderBy annotation in this XSD ?...

O2O.xsd

Discussion posts and replies are publicly visible

Parents

0 mayankk718 over 9 years ago

Actually my requirement is that whenever that query rule returns the data, it returns it in sorted order based on those 2 columns (or whatever criteria I give in XSDs). I might show the data in Appian form or tempo report, but I am avoiding to write the sorting part in externally (for eg :- in SAIL). I want to give sorting login in XSDs only.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mayankk718 over 9 years ago

Actually my requirement is that whenever that query rule returns the data, it returns it in sorted order based on those 2 columns (or whatever criteria I give in XSDs). I might show the data in Appian form or tempo report, but I am avoiding to write the sorting part in externally (for eg :- in SAIL). I want to give sorting login in XSDs only.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data