Order by Field in cosmos sql query

Viewed 27

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",
}
0 Answers
Related