IDataQuerySettingsTQuery Properties |
The IDataQuerySettingsTQuery generic type exposes the following members.
Name | Description | |
---|---|---|
![]() | DefaultSourceExpression |
Default source of the query in case source is not defined
(Inherited from IDataQuerySettings.) |
![]() | FilterColumns |
List of columns used for extra filtering within the query, e.g. "CMS_C, CMS_RN"
(Inherited from IDataQuerySettings.) |
![]() | GroupByColumns |
List of columns to group by, by default doesn't group, e.g. "NodeLevel, NodeOwner"
(Inherited from IDataQuerySettings.) |
![]() | HavingCondition |
Where condition for the group by on the data, e.g. "DocumentName = 'ABC'"
(Inherited from IDataQuerySettings.) |
![]() | IsNested |
Indicates that this query is part of multi query
(Inherited from IDataQuerySettings.) |
![]() | IsSubQuery |
If true, the query is a sub-query used in another query
(Inherited from IDataQuerySettings.) |
![]() | MaxRecords |
Maximum number of results to return (use for paging together with Offset)
(Inherited from IDataQuerySettings.) |
![]() | Name |
Object name, empty by default
(Inherited from IQueryObject.) |
![]() | Offset |
Index of the first record to return (use for paging together with MaxRecords)
(Inherited from IDataQuerySettings.) |
![]() | OrderByColumns |
List of columns by which the result should be sorted, e.g. "NodeLevel, DocumentName DESC"
(Inherited from IDataQuerySettings.) |
![]() | Parameters |
Query data parameters
(Inherited from IQueryObject.) |
![]() | SelectColumns | Obsolete.
List of columns to return, by default returns all columns, e.g. "DocumentName, DocumentID"
(Inherited from IDataQuerySettings.) |
![]() | SelectColumnsList |
List of columns to return, by default returns all columns, e.g. "DocumentName, DocumentID"
(Inherited from IDataQuerySettings.) |
![]() | SelectDistinct |
If set to true, returns only distinct (different) values.
(Inherited from IDataQuerySettings.) |
![]() | SourceExpression |
Source of the query
(Inherited from IDataQuerySettings.) |
![]() | TopNRecords |
If set, selects only first top N number of records
(Inherited from IDataQuerySettings.) |
![]() | WhereCondition |
Where condition on the data, e.g. "DocumentName = 'ABC'"
(Inherited from IWhereCondition.) |
![]() | WhereIsComplex |
Returns true if the given where condition contains compound conditions, e. g. "A > 1 AND B = 5"
(Inherited from IWhereCondition.) |