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

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

OriginalPostID-132221

OriginalPostID-132221