public class CrossTabQueryImpl extends BaseSelectQueryImpl implements CrossTabQuery
TRANSFORM <expr> SELECT <query> PIVOT <expr>
QueryImpl.AppendableList<E>, QueryImpl.Row, QueryImpl.RowFilter, QueryImpl.RowFormatter
Query.Type
Constructor and Description |
---|
CrossTabQueryImpl(String name,
List<QueryImpl.Row> rows,
int objectId,
int objectFlag) |
Modifier and Type | Method and Description |
---|---|
protected List<QueryImpl.Row> |
getColumnRows() |
protected List<QueryImpl.Row> |
getGroupByRows() |
String |
getPivotExpression() |
protected QueryImpl.Row |
getPivotRow() |
String |
getTransformExpression() |
protected QueryImpl.Row |
getTransformRow() |
protected void |
toSQLString(StringBuilder builder) |
getFromRemoteDbPath, getFromRemoteDbType, getFromTables, getGroupings, getHavingExpression, getOrderings, getSelectColumns, getSelectType, getWhereExpression, toSelectInto, toSQLSelectString
create, filterRowsByFlag, filterRowsByNotFlag, getFlagRow, getHavingRow, getIntValue, getJoinRows, getName, getObjectFlag, getObjectId, getOrderByRows, getOwnerAccessType, getParameterRows, getParameters, getRemoteDatabaseRow, getRowByAttribute, getRows, getRowsByAttribute, getShortValue, getTableRows, getType, getTypeRow, getUniqueRow, getWhereRow, hasFlag, hasFlag, isHidden, isQuoted, supportsStandardClauses, toAlias, toOptionalQuotedExpr, toQuotedExpr, toRemoteDb, toSQLParameterString, toSQLString, toString
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
getFromRemoteDbPath, getFromRemoteDbType, getFromTables, getGroupings, getHavingExpression, getOrderings, getSelectColumns, getSelectType, getWhereExpression
getName, getObjectFlag, getObjectId, getOwnerAccessType, getParameters, getType, isHidden, toSQLString
public CrossTabQueryImpl(String name, List<QueryImpl.Row> rows, int objectId, int objectFlag)
protected QueryImpl.Row getTransformRow()
protected List<QueryImpl.Row> getColumnRows()
getColumnRows
in class QueryImpl
protected List<QueryImpl.Row> getGroupByRows()
getGroupByRows
in class QueryImpl
protected QueryImpl.Row getPivotRow()
public String getTransformExpression()
getTransformExpression
in interface CrossTabQuery
public String getPivotExpression()
getPivotExpression
in interface CrossTabQuery
protected void toSQLString(StringBuilder builder)
toSQLString
in class QueryImpl
Copyright © 2005–2018. All rights reserved.