Click or drag to resize
SqlHelperPreparePagedQuery 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
C#
public static string PreparePagedQuery(
	string queryText,
	QueryMacros macros,
	int offset,
	int maxRecords,
	bool getTotal = true,
	bool subQuery = false
)

Parameters

queryText
Type: SystemString
Query text
macros
Type: CMS.DataEngineQueryMacros
Query expressions
offset
Type: SystemInt32
Index of first record to get
maxRecords
Type: SystemInt32
Maximum number of records to get
getTotal (Optional)
Type: SystemBoolean
If true, the query should get the total number of records
subQuery (Optional)
Type: SystemBoolean
If true, the query is used as a sub-query

Return Value

Type: String
See Also