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

difference in behavior for link-expanded relationship query between DS and jdbc

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 7.0.0
    • Fix Version/s: 7.0.0
    • Component/s: None
    • Labels:

      Description

      Doing a relationship-based link-expanded query against DS and jdbc yields different results. In DS, the state of the referred-to vertex is not returned.

      The query dispatched against DS, will return 

      http://localhost:8080/openidm/managed/user/dhogan/roles?_queryFilter=true&_fields=*,temporalConstraints,assignments/*
      {
          "result": [
              {
                  "_id": "db525679-5e2a-4d85-97ae-2f113ab54149",
                  "_rev": "000000006bbe9011",
                  "_refResourceCollection": "managed/role",
                  "_refResourceId": "admin",
                  "_refResourceRev": "000000001b6b41d0",
                  "name": "admin",
                  "assignments": [
                      {
                          "_ref": "managed/assignment/70facf07-a037-4224-9869-16c4c9e3a2ef",
                          "_refResourceCollection": "managed/assignment",
                          "_refResourceId": "70facf07-a037-4224-9869-16c4c9e3a2ef",
                          "_refProperties": {
                              "_id": "d8a66de5-243f-47e0-be6e-6a5b62edab64",
                              "_rev": "000000004d829d18"
                          }
                      }
                  ],
                  "_ref": "managed/role/admin",
                  "_refProperties": {
                      "_id": "db525679-5e2a-4d85-97ae-2f113ab54149",
                      "_rev": "000000006bbe9011"
                  }
              }
          ] 

       

      The identical query dispatched against mysql, will return

      http://localhost:8080/openidm/managed/user/dhogan/roles?_queryFilter=true&_fields=*,temporalConstraints,assignments/*  
        "result": [
              {
                  "_id": "4aaec353-e5f0-4e33-8b09-c4a342b49acd",
                  "_rev": "0",
                  "_refResourceCollection": "managed/role",
                  "_ref": "managed/role/admin",
                  "_refResourceId": "admin",
                  "_refResourceRev": "0",
                  "name": "admin",
                  "assignments": [
                      {
                          "_ref": "managed/assignment/59219966-f3b2-46f0-bb57-a338f8161485",
                          "_refResourceCollection": "managed/assignment",
                          "_refResourceId": "59219966-f3b2-46f0-bb57-a338f8161485",
                          "_refProperties": {
                              "_id": "507bf4a2-99bc-40a6-8858-09011aca7e2f",
                              "_rev": "0"
                          },
                          "name": "new_assignment",
                          "description": "a new assignment",
                          "mapping": "managedUser_systemLdapAccounts",
                          "_id": "59219966-f3b2-46f0-bb57-a338f8161485",
                          "_rev": "0"
                      }
                  ],
                  "_refProperties": {
                      "_id": "4aaec353-e5f0-4e33-8b09-c4a342b49acd",
                      "_rev": "0"
                  }
              }
          ]

      Note in the DS case, the state of the referred-to vertex, the assignment, is not returned - only the edge state pointing to the referred-to vertex. In the mysql case, assignment state - e.g. name and description and mapping - are returned.

      Something is amiss with the augmentation filter when consumed from a query against the relationship endpoint.

        Attachments

          Activity

            People

            • Assignee:
              dhogan Dirk Hogan
              Reporter:
              dhogan Dirk Hogan
              QA Assignee:
              Alexander Dracka
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: