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	applicationId()	Groups the result of the query by the field ApplicationId.
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.

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

create, executor, groupBy, orderBy, where

Method Detail

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 IvyScript and Java. It has the visibility EXPERT.

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 IvyScript and Java. It has the visibility EXPERT.

applicationId

public UserQuery.GroupByQuery applicationId()

Description copied from interface: UserQuery.IGroupByQueryColumns

Groups the result of the query by the field ApplicationId.

SQL part: GROUP BY ApplicationId

Specified by:

applicationId in interface UserQuery.IGroupByQueryColumns

Returns:

query for further composition

See Also:

UserQuery.IGroupByQueryColumns.applicationId()

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

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 IvyScript and Java. It has the visibility EXPERT.

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 IvyScript and Java. It has the visibility EXPERT.

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 IvyScript and Java. It has the visibility EXPERT.