Content Studio Web Content Management System
Assembly: CS_SiteLib (in CS_SiteLib.dll) Version: 5.7.5016.0 (5.7.5016.0)
An array of dictionaries filled with the result. The key will be the same as the field name. One key that is always returned is documentid.
[This is preliminary documentation and is subject to change.]
Returns a Dictionary containing query results.
Namespace: ContentStudio.Site.ActiveScripting
Assembly: CS_SiteLib (in CS_SiteLib.dll) Version: 5.7.5016.0 (5.7.5016.0)
Syntax
protected Dictionary<string, string>[] ReturnQueryAsDictionary( int categoryId, string filterCriteria, XmlIndexQueryQueryAggregate qa, string sortFields, Nullable<bool> listDrafts, bool ignorePublishStatus, bool checkForReadPermission, bool returnExtendedFields, string[] xmlFields, XmlIndexQueryQueryDataTypes[] dataTypes, bool[] returnFieldsInResult, bool useApplicationCache, int applicationCacheTimeout, string applicationCacheUniqueIndex, int rangeSize, int pageNo, int pageSize, out int pageCount, out int recordCount )
Parameters
- categoryId
- Type: SystemInt32
Category id to query. - filterCriteria
- Type: SystemString
SQL filter criteria. This is the same as the where statement in sql-server, make sure all fields are surronded with []. Ex: [Country] = 'Sweden'. Can be a empty string. - qa
- Type: ContentStudio.Document.EPTXmlIndexQueryQueryAggregate
XML index query aggregate. Tells witch aggregate type to return. - sortFields
- Type: SystemString
SQL sort parameter. This is the same as the order by statement in sql-server, make sure all fields are surronded with []. Ex: [Lastname] ASC, [Firstname] ASC. - listDrafts
- Type: SystemNullableBoolean
Set to true for querying drafts only. Pass null (Nothing in Visual Basic) to query against the draft or the approved content, if draft was not found. This will require readpermission on the category/documets. If this is set to false, only approved documents will be queried and only browse permission is required. - ignorePublishStatus
- Type: SystemBoolean
If this is set to true, documents will be queried even if it is not published. This will require read permission. - checkForReadPermission
- Type: SystemBoolean
Determines whether the component should check permissions or not. Setting this value to false can improve performance. - returnExtendedFields
- Type: SystemBoolean
Returns extra information in the queryresult (filename for the XML-file). - xmlFields
- Type: SystemString
An array of fileds to be used inte the query. Max fields number of are: XmlIndexQuery.PARAMETER_COUNT - dataTypes
- Type: ContentStudio.Document.EPTXmlIndexQueryQueryDataTypes
Datatype for the fields specified in XMLFields. - returnFieldsInResult
- Type: SystemBoolean
A list of fileds to be returned in the result specified in XMLFields. - useApplicationCache
- Type: SystemBoolean
Determines whether the component should use the Application cache or not. - applicationCacheTimeout
- Type: SystemInt32
The time (in minutes) for the application cache to live before it is refreshed. Setting it to zero means that the application cache not is used. - applicationCacheUniqueIndex
- Type: SystemString
A site unique name to be used with the application cache - rangeSize
- Type: SystemInt32
This is used for icreased performance. If the range size is set to 10 than sql-server will only query max 20 pages. If this is used, the parameter RecordCount will only return max PageSize * (RangeSize * 2) - pageNo
- Type: SystemInt32
The page number to retreive. - pageSize
- Type: SystemInt32
The maximum number of page size to return. - pageCount
- Type: SystemInt32
This parameter will contain the number of pages - recordCount
- Type: SystemInt32
This parameter will contation the number of records.
Return Value
Type: DictionaryString, StringAn array of dictionaries filled with the result. The key will be the same as the field name. One key that is always returned is documentid.
See Also