Package ch.ivyteam.ivy.security.query

Class UserQuery.GroupByQuery

java.lang.Object

ch.ivyteam.ivy.persistence.query.Query<IUser>

ch.ivyteam.ivy.security.query.UserQuery

ch.ivyteam.ivy.security.query.UserQuery.GroupByQuery

All Implemented Interfaces:

UserQuery.IGroupByQueryColumns

Enclosing class:

UserQuery

public static class UserQuery.GroupByQuery
extends UserQuery
implements 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.

Nested Class Summary

Nested classes/interfaces inherited from class ch.ivyteam.ivy.security.query.UserQuery

UserQuery.FilterLink, UserQuery.FilterQuery, UserQuery.GroupByQuery, UserQuery.IBoolFilterQuery, UserQuery.IColumnFilterQuery, UserQuery.IFilterableColumns, UserQuery.IFilterLink, UserQuery.IFilterQuery, UserQuery.IGroupByQueryColumns, UserQuery.IIntegerColumnFilterQuery, UserQuery.INumberColumnFilterQuery, UserQuery.IOrderByQueryColumns, UserQuery.IPatternColumnFilterQuery, UserQuery.IStringColumnFilterQuery, UserQuery.OrderByColumnQuery, UserQuery.OrderByQuery

Method Summary

Modifier and Type	Method	Description
UserQuery.GroupByQuery	eMailAddress()	Groups the result of the query by the field EMailAddress.
UserQuery.GroupByQuery	externalId()	Groups the result of the query by the field ExternalId.
UserQuery.GroupByQuery	fullName()	Groups the result of the query by the field FullName.
UserQuery.GroupByQuery	name()	Groups the result of the query by the field Name.
UserQuery.GroupByQuery	securityMemberId()	Groups the result of the query by the field SecurityMemberId.
UserQuery.GroupByQuery	securitySystemId()	Groups the result of the query by the field SecuritySystemId.

Methods inherited from class ch.ivyteam.ivy.security.query.UserQuery

create, executor, groupBy, orderBy, where

Methods inherited from class ch.ivyteam.ivy.persistence.query.Query

equals, hashCode

Method Details

name

public UserQuery.GroupByQuery name()

Description copied from interface: UserQuery.IGroupByQueryColumns

Groups the result of the query by the field Name.

SQL part: GROUP BY Name

Specified by:

name in interface UserQuery.IGroupByQueryColumns

Returns:

query for further composition

See Also:

• UserQuery.IGroupByQueryColumns.name()

API:

This public API is available in Java.

fullName

public UserQuery.GroupByQuery fullName()

Description copied from interface: UserQuery.IGroupByQueryColumns

Groups the result of the query by the field FullName.

SQL part: GROUP BY FullName

Specified by:

fullName in interface UserQuery.IGroupByQueryColumns

Returns:

query for further composition

See Also:

• UserQuery.IGroupByQueryColumns.fullName()

API:

This public API is available in Java.

securitySystemId

public UserQuery.GroupByQuery securitySystemId()

Description copied from interface: UserQuery.IGroupByQueryColumns

Groups the result of the query by the field SecuritySystemId.

SQL part: GROUP BY SecuritySystemId

Specified by:

securitySystemId in interface UserQuery.IGroupByQueryColumns

Returns:

query for further composition

See Also:

• UserQuery.IGroupByQueryColumns.securitySystemId()

API:

This public API is available in Java.

externalId

public UserQuery.GroupByQuery externalId()

Description copied from interface: UserQuery.IGroupByQueryColumns

Groups the result of the query by the field ExternalId.

SQL part: GROUP BY ExternalId

Specified by:

externalId in interface UserQuery.IGroupByQueryColumns

Returns:

query for further composition

See Also:

• UserQuery.IGroupByQueryColumns.externalId()

API:

This public API is available in Java.

eMailAddress

public UserQuery.GroupByQuery eMailAddress()

Description copied from interface: UserQuery.IGroupByQueryColumns

Groups the result of the query by the field EMailAddress.

SQL part: GROUP BY EMailAddress

Specified by:

eMailAddress in interface UserQuery.IGroupByQueryColumns

Returns:

query for further composition

See Also:

• UserQuery.IGroupByQueryColumns.eMailAddress()

API:

This public API is available in Java.

securityMemberId

public UserQuery.GroupByQuery securityMemberId()

Description copied from interface: UserQuery.IGroupByQueryColumns

Groups the result of the query by the field SecurityMemberId.

SQL part: GROUP BY SecurityMemberId

Specified by:

securityMemberId in interface UserQuery.IGroupByQueryColumns

Returns:

query for further composition

See Also:

• UserQuery.IGroupByQueryColumns.securityMemberId()

API:

This public API is available in Java.