I can query for Users using a native query

XMLWordPrintable

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

      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

            Assignee:
            Unassigned
            Reporter:
            Christopher Kujawa
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: