Therefore Web API Programming Interface 1.0

Zoom Window Out
Larger Text | Smaller Text
Hide Page Header
Show Expanding Text
Printable Version
Save Permalink URL

Therefore Web API > Web API Reference > Operations

GetSavedQuery

REST URL (POST) https://tenant.thereforeonline.com/theservice/v0001/restun/GetSavedQuery

SOAP Action (POST) http://schemas.therefore.net/webservices/interop/v0001/messages/IThereforeService/GetSavedQuery

Gets saved query (search). The Query object returned in response can be used in the ExecuteSingleQuery request (as it is or with changes).

Input Message: http://schemas.therefore.net/webservices/interop/v0001/messages/IThereforeService/GetSavedQuery

Element Name	Element Type	Restrictions	Description
■ parameters
■ QueryNo	xs:int	mandatory	Sets number of the query to get.

Output Message: http://schemas.therefore.net/webservices/interop/v0001/messages/IThereforeService/GetSavedQueryResponse

Element Name	Element Type	Restrictions	Description
■ parameters
□ Query		optional nillable	Gets configuration of the search (query).
□ CaseDefinitionNo	xs:int	optional nillable	Sets the number of the case definition to search in the case definition.
□ CategoryNo	xs:int	optional nillable	Sets the number of the category to search in the category.
□ Conditions		optional nillable	Sets the conditions list for the query.
≡ WSCondition		optional unbounded nillable
□ Condition	xs:string	mandatory nillable	Sets or gets condition.
□ FieldNoOrName	xs:string	mandatory nillable	Sets or gets number or name of the field. When returned from the server it contains field number. When returned from the server it contains field number.
■ TimeZone		optional restriction enum (xs:string) - UTC (0) - ServerLocal (1)	Sets or gets the time zone used in the condition for date/time values. The 'ServerLocal' option means that timezone from HTTP header 'The-Timezone-IANA' or 'The-Timezone-Microsoft' will be used if defined, otherwise the server local time zone will be used. If not set the UTC time zone will be used.
□ FileByColName	xs:string	optional nillable	Looks up the specified column name and uses the field number for a query for an external data table.
□ FileByFieldNo	xs:int	optional nillable	Sets the field number for a query for an external data table.
■ MaxRows	xs:int	optional	Sets the maximum number of rows the query will retrieve from the server.
□ Mode		optional nillable restriction enum (xs:string) - NormalQuery (0) - FileQuery (1) - WorkflowQuery (4) - CaseQuery (5)	Sets the mode of the query.
□ OrderByFieldsNoOrNames		optional nillable	Orders result rows by field numbers or names. When returned from the server it contains field numbers. When returned from the server it contains field numbers.
≡ FieldNoOrName	xs:string	optional unbounded nillable
■ RowBlockSize	xs:int	optional	Sets the rows block size for the query. The default value is 100.
□ SelectedFieldsNoOrNames		optional nillable	Sets the list of field numbers or names to get these fields as a result. Set to null to get all the fields. Empty list means no fields will be returnded in response. When returned from the server it contains field numbers.
≡ FieldNoOrName	xs:string	optional unbounded nillable
□ GroupByFieldsNoOrNames		optional nillable	Contains list of field numbers, that the query should be grouped by
≡ FieldNoOrName	xs:string	optional unbounded nillable
□ FullText	xs:string	optional nillable	Sets the string to search in the query.
□ ValidOperandMacros		optional nillable	Gets list of valid macros operands for queries.
≡ ValidOperandMacros	xs:string	optional unbounded nillable
□ ValidQueryOperators		optional nillable	Gets list of valid operators for queries.
□ And	xs:string	optional nillable	Operator AND.
□ Empty	xs:string	optional nillable	Operator EMPTY.
□ GreaterThan	xs:string	optional nillable	Operator GREATER THAN.
□ GreaterThanOrEqual	xs:string	optional nillable	Operator GREATER THAN OR EQUAL.
□ LessThan	xs:string	optional nillable	Operator LESS THAN.
□ LessThanOrEqual	xs:string	optional nillable	Operator LESS THAN OR EQUAL.
□ Not	xs:string	optional nillable	Operator NOT.
□ NotEmpty	xs:string	optional nillable	Operator NOT EMPTY.
□ Or	xs:string	optional nillable	Operator OR.
□ To	xs:string	optional nillable	Operator TO.
□ Wildcard	xs:string	optional nillable	Wildcard.

Legend:

■	Not nillable element.
□	Nillable element.
≡	Unbounded element (List of elements).
Normal	Optional element.
Bold	Mandatory element.