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 Detail

      • 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.

      • applicationId

        UserQuery.GroupByQuery applicationId()

        Groups the result of the query by the field ApplicationId.

        SQL part: GROUP BY ApplicationId

        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.