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

Audit sample does not support sorting, page sizes, or paged results

    Details

      Description

      The OpenIDM audit sample does not currently supported paged results. This causes the UI to display recon results which are NOT from the last executed reconciliation.

      To clarify, the mappingDetails endpoint which is invoked by the UI results in a query similar to the following being executed:

                  lastRecon = openidm.query("audit/recon", {
                      "_queryFilter": '/entryType eq "start" AND !(/reconAction eq "reconById") AND /mapping eq "' + m.name + '"',
                      "_sortKeys" : '-timestamp',
                      "_pageSize" : 1,
                      "formatted": false
                  });,
      

      Because the search script provided with the audit sample does not support paged results, the above Query Filter is translated to a SQL select similar to the following:

      SELECT * FROM auditrecon mapping = 'systemXmlfileAccounts_managedUser' AND reconaction <> 'reconById' AND entrytype = 'start'
      

      The above select returns all start entries for the given mapping in a unsorted result set. Therefore the recon which ends up being selected by the UI may or may not be the last one executed.

        Attachments

          Activity

            People

            • Assignee:
              cgdrake Chris Drake
              Reporter:
              cgdrake Chris Drake
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: