Table of Contents

Class QueryMacros

Namespace
CMS.DataEngine
Assembly
CMS.DataEngine.dll

Query expressions

public class QueryMacros
Inheritance
object
QueryMacros
Extension Methods

Constructors

QueryMacros()

public QueryMacros()

Fields

COLUMNS

Columns query macro

public const string COLUMNS = "##COLUMNS##"

Field Value

string

DISTINCT

Distinct query macro

public const string DISTINCT = "##DISTINCT##"

Field Value

string

GROUPBY

Group by query macro

public const string GROUPBY = "##GROUPBY##"

Field Value

string

HAVING

Having query macro

public const string HAVING = "##HAVING##"

Field Value

string

ORDERBY

Order by query macro

public const string ORDERBY = "##ORDERBY##"

Field Value

string

OUTPUT

Output from non query statement. Allows to return data from inserted and deleted rows.

public const string OUTPUT = "##OUTPUT##"

Field Value

string

SOURCE

Source query macro

public const string SOURCE = "##SOURCE##"

Field Value

string

TOPN

Top N query macro

public const string TOPN = "##TOPN##"

Field Value

string

VALUES

Values query macro

public const string VALUES = "##VALUES##"

Field Value

string

WHERE

Where query macro

public const string WHERE = "##WHERE##"

Field Value

string

Properties

Columns

List of columns to select

public string Columns { get; set; }

Property Value

string

DefaultSource

Default query source

public string DefaultSource { get; set; }

Property Value

string

Distinct

If set to true, returns only distinct (different) values.

public bool Distinct { get; set; }

Property Value

bool

GroupBy

List of columns to group by

public string GroupBy { get; set; }

Property Value

string

Having

Where condition for the GroupBy clause

public string Having { get; set; }

Property Value

string

OrderBy

Order by

public string OrderBy { get; set; }

Property Value

string

Output

Output from non query statement. Allows to return data from inserted and deleted rows.

public string Output { get; set; }

Property Value

string

Source

Query source

public string Source { get; set; }

Property Value

string

TopN

Top N records

public int TopN { get; set; }

Property Value

int

Total

Total items expression

public string Total { get; set; }

Property Value

string

Values

List of values for the update / insert query

public string Values { get; set; }

Property Value

string

Where

Where condition

public string Where { get; set; }

Property Value

string

Methods

ResolveMacros(string)

Resolves the given macros within a query

public string ResolveMacros(string queryText)

Parameters

queryText string

Query text

Returns

string

ToString()

Gets the string representation of the where condition

public override string ToString()

Returns

string