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

        This is the controller panel for Smart Panels app

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

                Created:
                Updated:
                Resolved: