Table of Contents

Class QueryMacros

Namespace
CMS.DataEngine
Assembly
CMS.DataEngine.dll

Query expressions

public class QueryMacros
Inheritance
object
QueryMacros
Extension Methods

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