QueryMacros Class

Query expressions

Inheritance Hierarchy

System.Object
  CMS.DataEngine.QueryMacros

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 12.0.0

Syntax

public class QueryMacros

The QueryMacros type exposes the following members.

Constructors

	Name	Description
Public method	QueryMacros

Fields

	Name	Description
Public field Static member	COLUMNS	Columns query macro
Public field Static member	DISTINCT	Distinct query macro
Public field Static member	GROUPBY	Group by query macro
Public field Static member	HAVING	Having query macro
Public field Static member	ORDERBY	Order by query macro
Public field Static member	OUTPUT	Output from non query statement. Allows to return data from inserted and deleted rows.
Public field Static member	SOURCE	Source query macro
Public field Static member	TOPN	Top N query macro
Public field Static member	VALUES	Values query macro
Public field Static member	WHERE	Where query macro

Properties

	Name	Description
Public property	Columns	List of columns to select
Public property	DefaultSource	Default query source
Public property	Distinct	If set to true, returns only distinct (different) values.
Public property	GroupBy	List of columns to group by
Public property	Having	Where condition for the GroupBy clause
Public property	OrderBy	Order by
Public property	Output	Output from non query statement. Allows to return data from inserted and deleted rows.
Public property	Source	Query source
Public property	TopN	Top N records
Public property	Total	Total items expression
Public property	Values	List of values for the update / insert query
Public property	Where	Where condition

Methods

	Name	Description
Public method	ResolveMacros	Resolves the given macros within a query
Public method	ToString	Gets the string representation of the where condition (Overrides Object.ToString().)