QueryDependentFieldsDirect |
Scroll |
REST URL (POST) https://tenant.thereforeonline.com/theservice/v0001/restun/QueryDependentFieldsDirect
SOAP Action (POST) http://schemas.therefore.net/webservices/interop/v0001/messages/IThereforeService/QueryDependentFieldsDirect
Search Therefore database table for content
Input Message: http://schemas.therefore.net/webservices/interop/v0001/messages/IThereforeService/QueryDependentFieldsDirect
Element Name |
Element Type |
Restrictions |
Description |
â– parameters |
|
|
|
â– DataTypeNo |
xs:int |
mandatory |
The datatype to query for information |
â–¡ maxRows |
xs:int |
nillable |
Maximum number of rows to return |
â–¡ queryConditions |
|
mandatory nillable |
The query conditions for different columns to search |
≡ WSQueryDependentFieldsDirectCondition |
|
list nillable |
|
â–¡ ColName |
xs:string |
nillable |
Sets the column name to query |
â– ColumnType |
xs:int |
|
Sets the type of the column to query |
â–¡ Condition |
xs:string |
nillable |
Sets the query condition |
â–¡ selectColumns |
|
mandatory nillable |
The columns to select from the datatype table |
≡ SelectColumn |
xs:string |
list nillable |
|
â– FormNo |
xs:int |
mandatory |
The eForm no in which context the datatype should be searched |
Output Message: http://schemas.therefore.net/webservices/interop/v0001/messages/IThereforeService/QueryDependentFieldsDirectResponse
Element Name |
Element Type |
Restrictions |
Description |
â– parameters |
|
|
|
â–¡ QueryResult |
|
nillable |
Gets the query result. |
â–¡ Columns |
|
nillable |
Gets the query result rows. |
≡ string |
xs:string |
list nillable |
|
â–¡ ResultRows |
|
nillable |
Gets the query result rows. |
≡ WSDependentFieldsQueryResultRow |
|
list nillable |
|
â–¡ FieldValues |
|
nillable |
List of index values presented as a string list. |
≡ IndexValue |
xs:string |
list nillable |
|
â– IsClosedCase |
xs:boolean |
|
Flag indicating a closed case. |
â– AllRowsReturned |
xs:boolean |
|
indicate if all rows were returned or the maximum hitcount was exceeded |
Legend:
â– |
Not nillable element. |
â–¡ |
Nillable element. |
≡ |
List of elements. |
Bold |
Mandatory element. |