Package ch.ivyteam.ivy.security.query

Interface UserQuery.IGroupByQueryColumns

All Known Implementing Classes:
UserQuery.GroupByQuery
Enclosing class:
UserQuery
public static interface UserQuery.IGroupByQueryColumns
Provides methods to group the result by certain fields.

Example: 

UserQuery.create().groupBy().name();
Corresponds to SQL: 
SELECT Name FROM IWA_User GROUP BY Name

API:
This is a public API.

  • Method Details

    • name

      UserQuery.GroupByQuery name()

      Groups the result of the query by the field Name.

      SQL part: GROUP BY Name

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • fullName

      UserQuery.GroupByQuery fullName()

      Groups the result of the query by the field FullName.

      SQL part: GROUP BY FullName

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • securitySystemId

      UserQuery.GroupByQuery securitySystemId()

      Groups the result of the query by the field SecuritySystemId.

      SQL part: GROUP BY SecuritySystemId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • externalId

      UserQuery.GroupByQuery externalId()

      Groups the result of the query by the field ExternalId.

      SQL part: GROUP BY ExternalId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • eMailAddress

      UserQuery.GroupByQuery eMailAddress()

      Groups the result of the query by the field EMailAddress.

      SQL part: GROUP BY EMailAddress

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • securityMemberId

      UserQuery.GroupByQuery securityMemberId()

      Groups the result of the query by the field SecurityMemberId.

      SQL part: GROUP BY SecurityMemberId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.