|
Produced by Siminov Software Solution LLP | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface IGroupConcat
Exposes API's to get group concat that returns a string which is the concatenation of all non-NULL values of X. If parameter Y is present then it is used as the separator between instances of X. A comma (",") is used as the separator if Y is omitted. The order of the concatenated elements is arbitrary.
Field Summary | |
---|---|
static java.lang.String |
INTERFACE_NAME
|
Method Summary | |
---|---|
IGroupConcatClause |
and(java.lang.String column)
Used to specify AND condition between where clause. |
IGroupConcat |
column(java.lang.String column)
Used to provide name of column for which average will be calculated. |
IGroupConcat |
delimiter(java.lang.String delimiter)
Used to specify separator if Y is omitted. |
java.lang.Object |
execute()
Used to get average, this method should be called in last to calculate group concat. |
IGroupConcat |
groupBy(java.lang.String... columns)
Used to specify GROUP BY statement in conjunction with the aggregate functions to group the result-set by one or more columns. |
IGroupConcatClause |
having(java.lang.String column)
Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions. |
IGroupConcat |
havingClause(java.lang.String havingClause)
Used to provide manually created Where clause, instead of using API's. |
IGroupConcatClause |
or(java.lang.String column)
Used to specify OR condition between where clause. |
IGroupConcatClause |
where(java.lang.String column)
Column name of which condition will be specified. |
IGroupConcat |
whereClause(java.lang.String whereClause)
Used to provide manually created Where clause, instead of using API's. |
Field Detail |
---|
static final java.lang.String INTERFACE_NAME
Method Detail |
---|
IGroupConcat delimiter(java.lang.String delimiter)
delimiter
- Delimiter.
IGroupConcatClause where(java.lang.String column)
column
- Name of column.
IGroupConcat whereClause(java.lang.String whereClause)
whereClause
- Manually created where clause.
IGroupConcatClause and(java.lang.String column)
column
- Name of column on which condition need to be specified.
IGroupConcatClause or(java.lang.String column)
column
- Name of column on which condition need to be specified.
IGroupConcat groupBy(java.lang.String... columns)
columns
- Name of columns.
IGroupConcatClause having(java.lang.String column)
column
- Name of column on which condition need to be applied.
IGroupConcat havingClause(java.lang.String havingClause)
havingClause
- Where clause.
IGroupConcat column(java.lang.String column)
column
- Name of column.
java.lang.Object execute() throws DatabaseException
DatabaseException
- Throws exception if any error occur while calculating group concat.
|
Apache License 2.0 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |