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:
Corresponds to SQL:UserQuery.create().groupBy().name();
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
All Methods Instance Methods Concrete Methods Modifier and Type Method Description UserQuery.GroupByQuery
applicationId()
Groups the result of the query by the fieldApplicationId
.UserQuery.GroupByQuery
eMailAddress()
Groups the result of the query by the fieldEMailAddress
.UserQuery.GroupByQuery
externalId()
Groups the result of the query by the fieldExternalId
.UserQuery.GroupByQuery
fullName()
Groups the result of the query by the fieldFullName
.UserQuery.GroupByQuery
name()
Groups the result of the query by the fieldName
.UserQuery.GroupByQuery
securityMemberId()
Groups the result of the query by the fieldSecurityMemberId
.
-
-
-
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 interfaceUserQuery.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 interfaceUserQuery.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 interfaceUserQuery.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 interfaceUserQuery.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 interfaceUserQuery.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 interfaceUserQuery.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.
-
-