SqlHelper.PreparePagedQuery Method

Prepares the query for paging, adds additional system columns and updates the columns list.

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

Syntax

public static string PreparePagedQuery(
	string queryText,
	QueryMacros macros,
	int offset,
	int maxRecords,
	bool getTotal = true,
	bool subQuery = false
)

Parameters

queryText

Type: System.String
Query text

macros

Type: CMS.DataEngine.QueryMacros
Query expressions

offset

Type: System.Int32
Index of first record to get

maxRecords

Type: System.Int32
Maximum number of records to get

getTotal (Optional)

Type: System.Boolean
If true, the query should get the total number of records

subQuery (Optional)

Type: System.Boolean
If true, the query is used as a sub-query

Return Value

Type: String