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

Paged queries with query-all-ids don't work correctly for explicit mappings

    Details

      Description

      The query string for query-all-ids and query-all-ids-count are incorrect, e.g. for mysql they should read

                  "query-all-ids" : "SELECT objectid FROM ${_dbSchema}.${_table} LIMIT ${int:_pageSize} OFFSET ${int:_pagedResultsOffset}",
                  "query-all-ids-count" : "SELECT COUNT(objectid) AS total FROM ${_dbSchema}.${_table}",

      Without the LIMIT and OFFSET portion the _pageSize parameter is not honored, and the count query is currently not correctly tailored to explicit mappings.

       

        Attachments

          Activity

            People

            • Assignee:
              ben.apple Ben Apple
              Reporter:
              matthias.grabiak Matthias Grabiak
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: