"Order by" query on Document DB suddenly stopped working on my development environment and is working fine without "Order by"
Here is the query which is not working (Use to work till yesterday and till yesterday it use to return me 70+ documents and now its returning null results(Empty array)):
SELECT * FROM c WHERE c.Category = 'test' ORDER BY c.StartDate DESC
Here is the query which is working(Currently its returning 70+ results and it use to return the same yesterday (which is not the case with the above query which is not working )):
SELECT * FROM c WHERE c.Category = 'test'
Did someone face the similar problem? What can be the solution for this?