ORDER BY

 

 

Catalouge + Normalise Demo

ORDER BY

  • Before my changes this sprint, we could only do ORDER BY with one alias...
  • For example:

 

 

MATCH (a:ASSET) RETURN a.title ORDER BY a.title

ORDER BY

  • After my changes, we can now use multiple aliases with ORDER BY:
  • There is also validation as well 
MATCH (a:ASSET) RETURN a.title ORDER BY a.title, a.parrots

ORDER BY

  • Also CustomerView accepts JSON now as part of these ORDER BY changes - makes manual testing much easier 
  • Example cURL requests...
curl localhost:7000/query 
-H 'X-Customer-App-ID: a40b3181-ab0e-45ef-aa02-29197af29d57' 
-H 'X-REQUEST-ID: test' -H 'X-Customer-ID: 10' -H 'Accept: application/json' 
-H 'Content-Type: application/json' 
--data '{"tql": "MATCH (s:ASSET) return s ORDER BY s.label, s.model limit 2"}' 
| python -m json.tool

Any questions?

ORDER BY

By laches1sm

ORDER BY

  • 653