Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-10827

Sorting records with sample scripted-sql-with-mysql not working anymore

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.5.0
    • Fix Version/s: 6.5.0
    • Component/s: _Samples
    • Labels:
    • Environment:
      OpenIDM version "6.5.0-SNAPSHOT" (build: 20180502032806, revision: cfaed6e)
    • Target Version/s:
    • Verified Version/s:
    • Story Points:
      3
    • Sprint:
      OpenIDM Sprint 6.5-1, OpenIDM Sprint 6.5-2

      Description

      Since this commit done for OPENIDM-8115, sorting records with sample scripted-sql-with-mysql not working anymore.

      See this section of the doc about the sample:

      curl --header "X-OpenIDM-Password: openidm-admin" --header "X-OpenIDM-Username: openidm-admin"  --request GET "http://localhost:8080/openidm/system/hrdb/account?_queryFilter=uid%20sw%20%22%22&_pageSize=2&_sortKeys=timestamp,id"
      {
        "code": 400,
        "reason": "Bad Request",
        "message": "Unsupported _sortKey: timestamp"
      }
      

      This error looks legit, but I did not find out how to do paging/sorting using other properties.
      I tried with "name" for example but got similar error.
      Does the sample needs to be updated so that we can do sorting?
      Otherwise we should update the doc.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                cgdrake Chris Drake
                Reporter:
                laurent.bristiel Laurent Bristiel [X] (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: