After extracting the data filtered by creation type, my intention is to arrange the data based on the the approval_type column in the folllowing order : "Initiator" first, followed by "Reviewer" and finally "Approver". I am not sure what went wrong in my ODATA order by query and hope to seek your assistance.
ODATA Order By query:
?$orderby=approval_type desc&$orderby=approval_type eq 'Initiator' desc&$orderby=approval_type eq 'Reviewer' desc&$orderby=approval_type eq 'Approver' desc
This is the error detail that I received:
Expression expected at position 0 in '?$orderby=approval_type desc&$orderby=approval_type eq 'Initiator' desc&$orderby=approval_type eq 'Reviewer' desc&$orderby=approval_type eq 'Approver' desc'.
inner exception: Expression expected at position 0 in '?$orderby=approval_type desc&$orderby=approval_type eq 'Initiator' desc&$orderby=approval_type eq 'Reviewer' desc&$orderby=approval_type eq 'Approver' desc'.
clientRequestId: 6ec5ede0-ecde-4c33-a0dd-9c5f07062dc3

Report
All responses (
Answers (