dms.ExecuteStoredQuery
This job executes stored queries. The result is returned in the DMS Content format.
1. Input Parameters
| Name | Type | Required | Description |
|---|---|---|---|
|
INT |
Yes |
Flags to control the output format |
|
INT |
Yes |
ID of the query |
|
INT |
No |
|
If it is a parametrized query, the query parameters must be passed as job parameters.
The $ characters that surround the parameters in the query must be omitted (e.g. VAR1 or STAT3).
The parameter QueryCatalogueLocale can be used to control in which language multilingual catalogs are passed as query parameters.
Additionally, the following parameters can be set to format the returned XML document:
RequestType, OutputFormat, BaseParams, Offset, Pagesize, MaxHits, Rights, DateFormat, Variants, FileInfo, Baseparams.
The description of these parameters can be found in the description of the job dms.GetResultList.
|
2. Output Parameters
| Name | Type | Dependency | Description |
|---|---|---|---|
|
INT |
— |
Number of records returned |
|
INT |
— |
Number of available hits |
|
BASE64 |
Optional |
Hit list in DMSContent XML format (when Flags is not |
3. Output Files
| Name | Description |
|---|---|
|
Only one file is always returned |
|
Name and path of the DMSContent XML file containing the hit list |
4. Return Value
(INT): 0 = Job successful, otherwise error code
Complete error list