Click or drag to resize
DataQuerySettings Properties

The DataQuerySettings type exposes the following members.

Properties
  NameDescription
Public propertyDataSourceName
Data source identifier that represents the location from which the data are obtained.
(Inherited from WhereConditionBaseTParent.)
Public propertyDefaultQuerySource
Default source of the query in case source is not defined
(Inherited from DataQuerySettingsBaseTQuery.)
Public propertyFilterColumns
List of columns used for extra filtering within the query, e.g. "CMS_C, CMS_RN"
(Inherited from DataQuerySettingsBaseTQuery.)
Protected propertyForceOrderBy
If true, the order by should be forced in the process of execution
(Inherited from DataQuerySettingsBaseTQuery.)
Public propertyGroupByColumns
List of columns to group by, by default doesn't group, e.g. "NodeLevel, NodeOwner"
(Inherited from DataQuerySettingsBaseTQuery.)
Public propertyHasGroupBy
Returns true if the given query has group by set
(Inherited from DataQuerySettingsBaseTQuery.)
Public propertyHavingCondition
Where condition for the group by on the data, e.g. "DocumentName = 'ABC'"
(Inherited from DataQuerySettingsBaseTQuery.)
Public propertyHavingIsComplex
Returns true if the given having condition is a complex condition
(Inherited from DataQuerySettingsBaseTQuery.)
Public propertyHavingIsEmpty
Returns true if the having condition is empty
(Inherited from DataQuerySettingsBaseTQuery.)
Protected propertyIsImmutable
If true, this object instance is immutable, and next subsequent modification starts with a clone of the object.
(Inherited from QueryParametersBaseTParent.)
Public propertyIsNested
Indicates that this query is nested within another query as its source. This brings certain constraints such as that is cannot use CTE.
(Inherited from DataQuerySettingsBaseTQuery.)
Public propertyIsPagedQuery
Returns true if the query has the paging enabled
(Inherited from DataQuerySettingsBaseTQuery.)
Public propertyIsSubQuery
If true, the query is a sub-query used in another query. This brings certain constraints such as that it cannot use order by or CTE.
(Inherited from DataQuerySettingsBaseTQuery.)
Public propertyMaxRecords
Maximum number of results to return (use for paging together with Offset)
(Inherited from DataQuerySettingsBaseTQuery.)
Public propertyName
Object name, empty by default
(Inherited from AbstractQueryObject.)
Public propertyOffset
Index of the first record to return (use for paging together with MaxRecords)
(Inherited from DataQuerySettingsBaseTQuery.)
Public propertyOrderByColumns
List of columns by which the result should be sorted, e.g. "NodeLevel, DocumentName DESC"
(Inherited from DataQuerySettingsBaseTQuery.)
Public propertyParameters
Query data parameters
(Inherited from QueryParametersBaseTParent.)
Public propertyQuerySource
Query source object
(Inherited from DataQuerySettingsBaseTQuery.)
Public propertyReturnsNoResults
Returns true if query doesn't return any results
(Inherited from WhereConditionBaseTParent.)
Public propertySelectColumnsList
List of columns to return, by default returns all columns, e.g. "DocumentName, DocumentID"
(Inherited from DataQuerySettingsBaseTQuery.)
Public propertySelectDistinct
If set to true, returns only distinct (different) values.
(Inherited from DataQuerySettingsBaseTQuery.)
Public propertyTopNRecords
If set, selects only first top N number of records
(Inherited from DataQuerySettingsBaseTQuery.)
Public propertyTotalExpression
Total items expression. When defined, used instead default total items for a paged query.
(Inherited from DataQuerySettingsBaseTQuery.)
Protected propertyWhereBuilder
Where condition builder
(Inherited from WhereConditionBaseTParent.)
Public propertyWhereCondition
Where condition on the data, e.g. "DocumentName = 'ABC'"
(Inherited from WhereConditionBaseTParent.)
Public propertyWhereIsComplex
Returns true if the given where condition contains compound conditions, e. g. "A > 1 AND B = 5"
(Inherited from WhereConditionBaseTParent.)
Public propertyWhereIsEmpty
Returns true if the where condition is empty
(Inherited from WhereConditionBaseTParent.)
Protected propertyWhereOperator
Operator used for adding where condition. Default is AND
(Inherited from WhereConditionBaseTParent.)
Top
See Also