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.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
fullName()
Groups the result of the query by the fieldFullName
.UserQuery.GroupByQuery
name()
Groups the result of the query by the fieldName
.
-
-
-
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.
-
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.
-
-