Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-7164

I can query for Users using a native query

    Details

    • Type: Feature Request
    • Status: Closed
    • Priority: L3 - Default
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 7.7.0, 7.7.0-alpha2
    • Component/s: engine
    • Labels:

      Description

      AT:

      • query users with the help of native queries so search in different columns as conjunction is possible

      The usage could look like the following:

      List<User> users = identityService.createNativeUserQuery()
        .sql("SELECT * FROM " + managementService.getTableName(User.class) + " U "
                + " WHERE U.FIRST_ LIKE #{search}" 
                + " OR U.LAST_ LIKE #{search}"
                + " OR U.EMAIL_ LIKE #{search}"
              )
        .parameter("search", "%searchStr%")
        .list();
      

      Note: this only works with Database Identity Provider, not with LDAP

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            christopher.zell Christopher Zell
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development