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

Pagination on managed users not working with MS-SQL, DB2 and Oracle as repo

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: OpenIDM 3.1.0, OpenIDM 4.0.0
    • Fix Version/s: OpenIDM 4.0.0
    • Environment:
      r4093, Windows 2008, MS-SQL 2008 as repo, trunk build 554, CentOS DB2 and ORACLE
    • Story Points:
      3
    • Sprint:
      Sprint 28, OpenIDM Sprint 54

      Description

      Pagination on managed users is working with OrientDB and MySQL but not with MS-SQL as repo.
      Steps to reproduce
      1) create 10 managed users
      2) retrieve only 4 of them using _pageSize
      Result with MySQL:

      curl --header "X-OpenIDM-Password: openidm-admin" --header "X-OpenIDM-Username: openidm-admin" --request GET "http://localhost:8080/openidm/managed/user/?_queryId=query-all-ids&_pageSize=4"
      
      Response: {"result":[{"_id":"user0"},{"_id":"user1"},{"_id":"user2"},{"_id":"user3"}],"resultCount":4,"pagedResultsCookie":"4","remainingPagedResults":6}
      

      Result with MS-SQL

      curl --header "X-OpenIDM-Password: openidm-admin" --header "X-OpenIDM-Username: openidm-admin" --request GET "http://localhost:8080/openidm/managed/user/?_queryId=query-all-ids&_pageSize=4"
      
      Response Content: {"result":[{"_id":"user0"},{"_id":"user1"},{"_id":"user2"},{"_id":"user3"},{"_id":"user4"},{"_id":"user5"},{"_id":"user6"},{"_id":"user7"},{"_id":"user8"},{"_id":"user9"}],"resultCount":10,"pagedResultsCookie":null,"remainingPagedResults":0}
      

        Attachments

          Activity

            People

            • Assignee:
              jason.vincent jason vincent
              Reporter:
              laurent.bristiel Laurent Bristiel [X] (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: