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

empty kbaInfo is returned as null in explicit mapping JDBC repo

    XMLWordPrintable

    Details

    • Case Id:
      46974
    • Support Ticket IDs:
    • Zendesk ID:
      46974

      Description

      To reproduce this:

      1. Set up explicit mapping JDBC for managed/user, with the samples provided in db/. The kbaInfo is defined as array in managed.json

                          "kbaInfo" : {
                              "description" : "KBA Info",
                              "type" : "array",
      

      2. Create two users, test1 and test2. Populate kbaInfo for test1.

      3. Read/Query test2 user, the kbaInfo is null instead of an empty array. Here is a query example

      /openidm/managed/user?_queryFilter=userName+co+"test"&_fields=_id,userName,kbaInfo
      
      {
          "result": [
              {
                  "_id": "74571409-3bf1-40ca-bb88-0644017b0e39",
                  "_rev": "8",
                  "userName": "test1",
                  "kbaInfo": [
                      {
                          "answer": ...,
                          "questionId": "1"
                      },
                      {
                          "answer": ...,
                          "questionId": "2"
                      }
                  ]
              },
              {
                  "_id": "a840f0ea-c737-4dd4-a59b-507b072b8824",
                  "_rev": "1",
                  "userName": "test2",
                  "kbaInfo": null
              }
          ],
      

        Attachments

          Activity

            People

            Assignee:
            brmiller Brendan Miller
            Reporter:
            yinyan.cao Yinyan Cao
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: