Click or drag to resize
QueryMacros Class
Query expressions
Inheritance Hierarchy
SystemObject
  CMS.DataEngineQueryMacros

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 12.0.0
Syntax
C#
public class QueryMacros

The QueryMacros type exposes the following members.

Constructors
  NameDescription
Public methodQueryMacros
Top
Fields
  NameDescription
Public fieldStatic memberCOLUMNS
Columns query macro
Public fieldStatic memberDISTINCT
Distinct query macro
Public fieldStatic memberGROUPBY
Group by query macro
Public fieldStatic memberHAVING
Having query macro
Public fieldStatic memberORDERBY
Order by query macro
Public fieldStatic memberOUTPUT
Output from non query statement. Allows to return data from inserted and deleted rows.
Public fieldStatic memberSOURCE
Source query macro
Public fieldStatic memberTOPN
Top N query macro
Public fieldStatic memberVALUES
Values query macro
Public fieldStatic memberWHERE
Where query macro
Top
Properties
  NameDescription
Public propertyColumns
List of columns to select
Public propertyDefaultSource
Default query source
Public propertyDistinct
If set to true, returns only distinct (different) values.
Public propertyGroupBy
List of columns to group by
Public propertyHaving
Where condition for the GroupBy clause
Public propertyOrderBy
Order by
Public propertyOutput
Output from non query statement. Allows to return data from inserted and deleted rows.
Public propertySource
Query source
Public propertyTopN
Top N records
Public propertyTotal
Total items expression
Public propertyValues
List of values for the update / insert query
Public propertyWhere
Where condition
Top
Methods
  NameDescription
Public methodResolveMacros
Resolves the given macros within a query
Public methodToString
Gets the string representation of the where condition
(Overrides ObjectToString.)
Top
See Also