Affects Version/s: servicenow-connector-184.108.40.206
Fix Version/s: servicenow-connector-220.127.116.11
Component/s: ServiceNow Connector
Environment:ServiceNowConnector: 18.104.22.168-SNAPSHOT afe43cba2e7,
OpenIDM version "6.5.0-SNAPSHOT" 6f21de8,
Linux Mint 18.2 64-bit,
openjdk version "1.8.0_181"
`_sortKeys` doesn't have effect at queries requests for serviceNow connector. However we are able to sorting at REST API for servicenow developer instance (for example use REST API exploler tools at serviceNow developer instance web page).
Steps to reproduce:
- Download, unzip openidm, start openidm and set up serviceNow connector according documentation
- When exists less than 2 records in user table so create more records e.g.
- SEND GET request with queryFilter=True and without setup `_sortKeys` parametr
- SEND GET request with queryFilter=True and with `_sortKeys=last_name`
Actual result: Records in the response was not order by `last_name` field.
Expected result: Records in the response should be ordered by `last_name` field.
Note: When I tried ORDERBY and ORDERBYDESC in REST API exploler in REST API exploler in serviceNow instance, so there ordering was working correctly.