In mysql we have ORDER BY FIELD(status,'OnBoarded','Expired','Invited');
I need the same for Azure CosmosDB sql to sort the records with required order of my enum 'InvitedStatus'.
Below are example records.
{
"LastName": "ExpiredUser",
"FirstName": "Name",
"id": "cimata5282@shopxda.com",
"Role": "Administrator",
"InvitedStatus": "Expired",
},
{
"LastName": "InvitedUser",
"FirstName": "Name",
"id": "cimata5282@shopxda.com",
"Role": "Administrator",
"InvitedStatus": "Invited",
}
,
{
"LastName": "OnboardedUser",
"FirstName": "Name",
"id": "cimata5282@shopxda.com",
"Role": "Administrator",
"InvitedStatus": "OnBoarded",
}