Hi. When I add

ORDER BY

to my queries, I get no result.

SELECT LastName FROM Employee ORDER BY LastName

will give:

{
  "links": [
    {
      "rel": "self",
      "href": "....rest/query/v1/suiteql?limit=1000"
    }
  ],
  "count": 0,
  "hasMore": false,
  "items": [],
  "offset": 0,
  "totalResults": 124
}

If I remove the

ORDER BY

I will get the 124 results. What am I doing wrong?