Executes query and returns result as a dataset.
Namespace: CMS.DocumentEngineAssembly: CMS.DocumentEngine (in CMS.DocumentEngine.dll) Version: 8.0.0.0 (8.0.5239.26125)
Parameters
- queryName
- Type:
System String
Name of the query in format application.class.queryname
- parameters
- Type: CMS.DataEngine QueryDataParameters
Query parameters
- where
- Type:
System String
Where condition
- orderBy
- Type:
System String
Order by clause
- topN
- Type:
System Int32
Limits the number of returned items.
- columns
- Type:
System String
Columns that the result will contain.
- offset
- Type:
System Int32
Index of first record to get
- maxRecords
- Type:
System Int32
Maximum number of records to get. If maxRecords is zero or less, all records are returned (no paging is used)
- totalRecords
- Type:
System Int32
Returns total records count.
Return Value
Type: TreeNodeDataSetSee Also