Show/Hide Toolbars

Therefore Web API Programming Interface 1.0

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

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

 

Executes query for dependent field. Returns values from related referenced table.

 

 

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

 

Element Name

Element Type

Restrictions

Description

â–  parameters

 

 


â–¡ CaseDefinitionNo

xs:int

nillable

Sets the number of the case definition for the query. If CaseDefinitionNo is set CategoryNo should not be set.

â–¡ CategoryNo

xs:int

nillable

Sets the category number for the query. If CategoryNo is set CaseDefinitionNo should not be set.

â–  FieldNo

xs:int

mandatory

Sets the field number of given category or case definition.

â–¡ IndexDataItems

 

nillable

Set index data items for filtering. Result rows will be filtered based on the criteria(s) you set here.

≡ WSIndexDataItem

 

list nillable


â–¡ DateIndexData

 

nillable


â–  FieldNo

xs:int

mandatory

Gets or sets the number of the field. Doing request set it to proper field number or to 0 (zero) in order to use the FieldName property instead.

â–¡ DataValue

xs:dateTime

nillable

Gets or sets date value of the field. Date value should be specified without time zone information (in .net DateTimeKind.Uspecified, xml value like 2002-09-24T00:00:00) or as UTC date time (in .net DateTimeKind.Utc, xml value like 2002-09-24T00:00:00Z). This is mandatory, especially when client and server are located in different time zones. See also the *DataISO8601Value* property. The DataValue property is ignored if the DataISO8601Value property has a value.

â–¡ DataISO8601Value

xs:string

nillable

Gets or sets date value of the field in ISO 8601 format (YYYY-MM-DD, example 2017-07-23). See also the *DataValue* property. The DataValue property is ignored if the DataISO8601Value property has a value.

â–¡ FieldName

xs:string

nillable

Gets or sets the name (actualy column name) of the field. Doing request set the FieldNo property to 0 (zero) in order to use specified FieldName.

â–¡ IntIndexData

 

nillable


â–  FieldNo

xs:int

mandatory

Gets or sets the number of the field. Doing request set it to proper field number or to 0 (zero) in order to use the FieldName property instead.

â–¡ DataValue

xs:int

mandatory nillable

Gets or sets the integer value of the field.

â–¡ FieldName

xs:string

nillable

Gets or sets the name (actualy column name) of the field. Doing request set the FieldNo property to 0 (zero) in order to use specified FieldName.

â–¡ LogicalIndexData

 

nillable


â–  FieldNo

xs:int

mandatory

Gets or sets the number of the field. Doing request set it to proper field number or to 0 (zero) in order to use the FieldName property instead.

â–¡ DataValue

xs:boolean

mandatory nillable

Gets or sets Boolean value of the field.

â–¡ FieldName

xs:string

nillable

Gets or sets the name (actualy column name) of the field. Doing request set the FieldNo property to 0 (zero) in order to use specified FieldName.

â–¡ MoneyIndexData

 

nillable


â–  FieldNo

xs:int

mandatory

Gets or sets the number of the field. Doing request set it to proper field number or to 0 (zero) in order to use the FieldName property instead.

â–¡ DataValue

xs:double

nillable

Gets or sets the DOUBLE value of the field. Value for the field sould be set either by DataValue or by DecimalDataValue proiperty. DEPRECATED: Use the DecimalDataValue property instead for Thereforeâ„¢ version 2018 and newer.

â–¡ FieldName

xs:string

nillable

Gets or sets the name (actualy column name) of the field. Doing request set the FieldNo property to 0 (zero) in order to use specified FieldName.

â–¡ DecimalDataValue

xs:decimal

nillable

Gets or sets the DECIMAL value of the field. Value for the field sould be set either by DataValue or by DecimalDataValue proiperty.

â–¡ MultipleKeywordData

 

nillable


â–  FieldNo

xs:int

mandatory

Gets or sets the number of the field. Doing request set it to proper field number or to 0 (zero) in order to use the FieldName property instead.

â–¡ DataValue

 

mandatory nillable

Gets or sets multiple keyword values of the field.

≡ Keyword

xs:string

list nillable


â–¡ FieldName

xs:string

nillable

Gets or sets the name (actualy column name) of the field. Doing request set the FieldNo property to 0 (zero) in order to use specified FieldName.

â–¡ KeywordNos

 

nillable

Gets or sets multiple keyword numbers of the field.

≡ KeywordNo

xs:int

list


â–¡ SingleKeywordData

 

nillable


â–  FieldNo

xs:int

mandatory

Gets or sets the number of the field. Doing request set it to proper field number or to 0 (zero) in order to use the FieldName property instead.

â–¡ DataValue

xs:string

mandatory nillable

Gets or sets a single keyword value of the field.

â–¡ FieldName

xs:string

nillable

Gets or sets the field name (when you set it use column name + "_Text" suffix. example: for SK field "Department" use "Department_Text" for it's TEXT value) of the field. Doing request set the FieldNo property to 0 (zero) in order to use specified FieldName.

â–¡ StringIndexData

 

nillable


â–  FieldNo

xs:int

mandatory

Gets or sets the number of the field. Doing request set it to proper field number or to 0 (zero) in order to use the FieldName property instead.

â–¡ DataValue

xs:string

mandatory nillable

Gets or sets the string value of the field.

â–¡ FieldName

xs:string

nillable

Gets or sets the name (actualy column name) of the field. Doing request set the FieldNo property to 0 (zero) in order to use specified FieldName.

â–¡ TableIndexData

 

nillable


â–  FieldNo

xs:int

mandatory

Gets or sets the number of the field. Doing request set it to proper field number or to 0 (zero) in order to use the FieldName property instead.

â–¡ DataValue

 

mandatory nillable

Gets or sets the table value of the field.

≡ WSTableFieldDataRow

 

list nillable


â–¡ DataRowItems

 

nillable

Gets or sets the items of the row. If it is set to null for update operation - record with given row number (see RowNo parameter) will be deleted.

≡ WSTableFieldDataRowItem

 

list nillable


â–¡ DateIndexData

 

nillable


â–  FieldNo

xs:int

mandatory

Gets or sets the number of the field. Doing request set it to proper field number or to 0 (zero) in order to use the FieldName property instead.

â–¡ DataValue

xs:dateTime

nillable

Gets or sets date value of the field. Date value should be specified without time zone information (in .net DateTimeKind.Uspecified, xml value like 2002-09-24T00:00:00) or as UTC date time (in .net DateTimeKind.Utc, xml value like 2002-09-24T00:00:00Z). This is mandatory, especially when client and server are located in different time zones. See also the *DataISO8601Value* property. The DataValue property is ignored if the DataISO8601Value property has a value.

â–¡ DataISO8601Value

xs:string

nillable

Gets or sets date value of the field in ISO 8601 format (YYYY-MM-DD, example 2017-07-23). See also the *DataValue* property. The DataValue property is ignored if the DataISO8601Value property has a value.

â–¡ FieldName

xs:string

nillable

Gets or sets the name (actualy column name) of the field. Doing request set the FieldNo property to 0 (zero) in order to use specified FieldName.

â–¡ IntIndexData

 

nillable


â–  FieldNo

xs:int

mandatory

Gets or sets the number of the field. Doing request set it to proper field number or to 0 (zero) in order to use the FieldName property instead.

â–¡ DataValue

xs:int

mandatory nillable

Gets or sets the integer value of the field.

â–¡ FieldName

xs:string

nillable

Gets or sets the name (actualy column name) of the field. Doing request set the FieldNo property to 0 (zero) in order to use specified FieldName.

â–¡ LogicalIndexData

 

nillable


â–  FieldNo

xs:int

mandatory

Gets or sets the number of the field. Doing request set it to proper field number or to 0 (zero) in order to use the FieldName property instead.

â–¡ DataValue

xs:boolean

mandatory nillable

Gets or sets Boolean value of the field.

â–¡ FieldName

xs:string

nillable

Gets or sets the name (actualy column name) of the field. Doing request set the FieldNo property to 0 (zero) in order to use specified FieldName.

â–¡ MoneyIndexData

 

nillable


â–  FieldNo

xs:int

mandatory

Gets or sets the number of the field. Doing request set it to proper field number or to 0 (zero) in order to use the FieldName property instead.

â–¡ DataValue

xs:double

nillable

Gets or sets the DOUBLE value of the field. Value for the field sould be set either by DataValue or by DecimalDataValue proiperty. DEPRECATED: Use the DecimalDataValue property instead for Thereforeâ„¢ version 2018 and newer.

â–¡ FieldName

xs:string

nillable

Gets or sets the name (actualy column name) of the field. Doing request set the FieldNo property to 0 (zero) in order to use specified FieldName.

â–¡ DecimalDataValue

xs:decimal

nillable

Gets or sets the DECIMAL value of the field. Value for the field sould be set either by DataValue or by DecimalDataValue proiperty.

â–¡ SingleKeywordData

 

nillable


â–  FieldNo

xs:int

mandatory

Gets or sets the number of the field. Doing request set it to proper field number or to 0 (zero) in order to use the FieldName property instead.

â–¡ DataValue

xs:string

mandatory nillable

Gets or sets a single keyword value of the field.

â–¡ FieldName

xs:string

nillable

Gets or sets the field name (when you set it use column name + "_Text" suffix. example: for SK field "Department" use "Department_Text" for it's TEXT value) of the field. Doing request set the FieldNo property to 0 (zero) in order to use specified FieldName.

â–¡ StringIndexData

 

nillable


â–  FieldNo

xs:int

mandatory

Gets or sets the number of the field. Doing request set it to proper field number or to 0 (zero) in order to use the FieldName property instead.

â–¡ DataValue

xs:string

mandatory nillable

Gets or sets the string value of the field.

â–¡ FieldName

xs:string

nillable

Gets or sets the name (actualy column name) of the field. Doing request set the FieldNo property to 0 (zero) in order to use specified FieldName.

â–¡ AccessMask

 

nillable

Gets access mask for index data field (column) for connected user.

â–  Value

xs:unsignedLong

 

Represents the access mask of the permissions. See also: operation GetPermissionConstants.

â–¡ DateTimeIndexData

 

nillable


â–  FieldNo

xs:int

mandatory

Gets or sets the number of the field. Doing request set it to proper field number or to 0 (zero) in order to use the FieldName property instead.

â–¡ DataValue

xs:dateTime

nillable

Gets or sets UTC date time value of the field. Date value should be specified as UTC date time. The *DataValue* property is ignored if the *DataISO8601Value* property has a value.

â–¡ DataISO8601Value

xs:string

nillable

Gets or sets UTC date time value of the field in ISO 8601 format (example 2018-05-03T14:45:00Z). Date value should be specified as UTC date time. See also the *DataValue* property. The DataValue property is ignored if the DataISO8601Value property has a value.

â–¡ FieldName

xs:string

nillable

Gets or sets the name (actualy column name) of the field. Doing request set the FieldNo property to 0 (zero) in order to use specified FieldName.

â–¡ RoleAccessMask

 

nillable

Gets the role access mask for index data field(column) for connected user.

â–  Value

xs:unsignedLong

 

Represents the access mask of the permissions. See also: operation GetRolePermissionConstants.

â–¡ RowNo

xs:int

nillable

Gets or sets the number of the row. While updating the data - null value means creating new row. Starts at 0 (zero).

â–¡ AccessIsEditableRow

xs:boolean

nillable

Gets access status for the row for connected user.

â–¡ FieldName

xs:string

nillable

Gets or sets the name (actualy column name) of the field. Doing request set the FieldNo property to 0 (zero) in order to use specified FieldName.

â–¡ AccessMask

 

nillable

Gets access mask for index data field for connected user.

â–  Value

xs:unsignedLong

 

Represents the access mask of the permissions. See also: operation GetPermissionConstants.

â–¡ DateTimeIndexData

 

nillable


â–  FieldNo

xs:int

mandatory

Gets or sets the number of the field. Doing request set it to proper field number or to 0 (zero) in order to use the FieldName property instead.

â–¡ DataValue

xs:dateTime

nillable

Gets or sets UTC date time value of the field. Date value should be specified as UTC date time. The *DataValue* property is ignored if the *DataISO8601Value* property has a value.

â–¡ DataISO8601Value

xs:string

nillable

Gets or sets UTC date time value of the field in ISO 8601 format (example 2018-05-03T14:45:00Z). Date value should be specified as UTC date time. See also the *DataValue* property. The DataValue property is ignored if the DataISO8601Value property has a value.

â–¡ FieldName

xs:string

nillable

Gets or sets the name (actualy column name) of the field. Doing request set the FieldNo property to 0 (zero) in order to use specified FieldName.

â–¡ RoleAccessMask

 

nillable

Gets the role access mask for index data field for connected user.

â–  Value

xs:unsignedLong

 

Represents the access mask of the permissions. See also: operation GetRolePermissionConstants.

â–¡ MaxRows

xs:int

nillable

Set maximum number of the rows to be returned by the query. Set to '0' or not set it at all if all the rows should be returned.

â–¡ SaveMode

xs:boolean

nillable

Set to 'True' to run query in "SaveMode". Set to 'False' for "SearchMode". In SaveMode query doesn't return deleted keywords.

 

 

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

 

Element Name

Element Type

Restrictions

Description

â–  parameters

 

 


â–¡ QueryResult

 

nillable

Gets the query result.

â–¡ Columns

 

nillable

Gets the list of field numbers.

≡ WSCategoryField

 

list nillable


â–  BelongsTo

xs:int

 

Gets the field number of the TheCategoryField this field belongs to (set for dependent fields only).

â–  BelongsToTable

xs:int

 

Gets the field number of the TheCategoryField this field belongs to (is set for fields which belong to table only).

â–¡ Caption

xs:string

nillable

Gets the caption of the field.

â–  CaseSensitive

xs:boolean

 

Gets information if the field is case sensitive.

â–¡ ColName

xs:string

nillable

Gets the column name of the field in the database.

â–  CounterMode

 

 

restriction enum (xs:string)

- Undefined (0)

- ClientCounter (1)

- ServerCounter (2)

Gets the counter mode of the TheCategoryField if it is a counter field.

â–¡ DefaultVal

xs:string

nillable

Gets the default value for this field.

â–  DependencyMode

 

 

restriction enum (xs:string)

- Referenced (0)

- SynchronizedRedundant (1)

- EditableRedundant (2)

Gets the dependency mode of this field.

â–  DisplayOrderPos

xs:int

 

Returns the position of the field inside a table field or the position in the document title.

â–  DontLoadValues

xs:boolean

 

Returns whether choices will be pre-loaded for display (only for keyword and dependent fields).

â–  FieldNo

xs:int

 

Gets the field number of this field.

â–  FieldType

 

 

restriction enum (xs:string)

- StringField (1)

- IntField (2)

- DateField (3)

- LabelField (4)

- MoneyField (5)

- LogicalField (6)

- NumericCounter (8)

- TextCounter (9)

- TableField (10)

- CustomField (99)

Gets the category field type. NOTE: if FieldType value is 'CustomField' check values of IsImageFieldType and IsTabControlFieldType properties to find out type of the field.

â–¡ ForeignCol

xs:string

nillable

Gets the column name of the referenced column in a foreign table (set for dependent fields only).

â–  Guid

xs:string

 

GUID string template:

[\da-fA-F]{8}-[\da-fA-F]{4}-[\da-fA-F]{4}-[\da-fA-F]{4}-[\da-fA-F]{12}

Gets GUID of this field.

â–  Height

xs:int

 

Gets the height of this field in the category dialog.

â–¡ IndexDataFieldName

xs:string

nillable

Gets the name of the index data field.

â–  IndexType

xs:int

 

Gets the index type of the field (no / normal / unique).

â–  IsForeignDatatype

xs:boolean

 

Returns whether the field is a foreign data type.

â–  IsMultipleKeyword

xs:boolean

 

Returns whether the field is a multiple keyword.

â–  IsSingleKeyword

xs:boolean

 

Returns whether the field is a single keyword.

â–  KeepRedundant

xs:boolean

 

Gets information if values from a foreign data type should be copied to the TWC table and kept there redundant.

â–  Length

xs:int

 

Gets the length of the field.

â–  Mandatory

xs:boolean

 

Returns whether or not the field is mandatory and must be filled out before archiving a document or changing the index data.

â–  PosX

xs:int

 

Gets the horizontal position of this field in the category dialog in pixels.

â–  PosY

xs:int

 

Gets the vertical position of this field in the category dialog in pixels.

â–¡ RegularExpr

xs:string

nillable

Gets the regular expression if one has been defined in Solution Designer. Defining regular expressions via the API is not possible.

â–  TabOrderPos

xs:int

 

Gets the tabulator position of this field in the category dialog in pixels.

â–  TypeGroup

 

 

restriction enum (xs:string)

- StandardTypeGroup (1)

- KeywordTypeGroup (2)

- UserInt (3)

- UserTextAnsi (4)

- UserDate (5)

- UserFloat (6)

- UserTextUnicode (7)

- CaseDefinitionTypeGroup (8)

Gets the type group of the field.

â–¡ TypeIndexColumn

xs:string

nillable

Gets the type index column of the field. Additional information for user defined data type (TypeNo > 6).

â–¡ TypeMultiInner

xs:string

nillable

Gets the type multi inner of the field. Additional information for user defined data type (TypeNo > 6).

â–¡ TypeMultiJoin

xs:string

nillable

Gets the type multi join of the field. Additional information for user defined data type (TypeNo > 6).

â–¡ TypeMultiOuter

xs:string

nillable

Gets the type multi outer of the field. Additional information for user defined data type (TypeNo > 6).

â–  TypeNo

xs:int

 

Gets the type number of this field.

â–¡ TypeTableName

xs:string

nillable

Gets the type table name of the field. Additional information for user defined data type (TypeNo > 6).

â–  Visible

xs:boolean

 

Returns whether or not the field is visible in the category dialog.

â–  Width

xs:int

 

Gets the width of this field in the category dialog.

â–¡ WorkflowField

xs:string

nillable

Gets the name of the corresponding Microsoft® Exchange form field (if Microsoft® Exchange workflow is enabled for the category).

â–  SelectFromDropDownBox

xs:boolean

 

Returns whether dropdown box should be used to select value.

â–¡ DisplayProperties

 

nillable

Gets display properties of this field.

â–  BackgroundColor

xs:int

 

Gets the background color of the field.

â–  Bold

xs:boolean

 

True if the font is formatted as bold.

â–¡ FaceName

xs:string

nillable

Gets the face name.

â–  FontSize

xs:int

 

Gets the font size of the field.

â–  HorizontalAlignment

 

 

restriction enum (xs:string)

- Left (0)

- CenterH (1)

- Right (2)

Gets the horizontal alignment of the text.

â–  Italic

xs:boolean

 

True if the font is formatted as italic.

â–  Padding

xs:int

 

Gets a value that indicates the thickness of padding space.

â–  TextColor

xs:int

 

Gets the text color of the field.

â–  Underlined

xs:boolean

 

True if the font is formatted as underlined.

â–  VerticalAlignment

 

 

restriction enum (xs:string)

- Top (0)

- CenterV (4)

- Bottom (8)

Gets the vertical alignment of the text.

â–¡ ImageDocNo

xs:int

nillable

Gets the number of the document image.

â–  IsImageFieldType

xs:boolean

 

Returns whether the field is an image field.

â–  IsTabControlFieldType

xs:boolean

 

Returns whether the field is a tab control field.

â–  ParentFieldNo

xs:int

 

Gets number of parent field (tab control or table field).

â–  ShowInTabNo

xs:int

 

Gets number of tab where current field is shown or 0 (zero).

â–¡ Tabs

 

nillable

Gets list of tabs if current field is a tab control field.

≡ WSTabInfo

 

list nillable


â–  BackgroundColor

xs:int

 

Gets background color.

â–¡ Caption

xs:string

nillable

Gets the caption of the tab.

â–  Position

xs:int

 

Gets the position of the tab in the tab control.

â–  TabColor

xs:int

 

Gets the tab color of the tab.

â–  TabNo

xs:int

 

Gets the number of this tab.

â–  TextColor

xs:int

 

Gets the text color of the tab.

â–  Visible

xs:boolean

 

Gets whether or not the tab is visible in the category dialog.

â–¡ AccessMask

 

nillable

DEPRECATED: Use the RoleAccessMask property instead. Gets access mask for the field for connected user.

â–  Value

xs:unsignedLong

 

Represents the access mask of the permissions. See also: operation GetPermissionConstants.

â–  IsAutoAppendField

xs:boolean

 

Gets access mask for the field for connected user.

â–  IsDateTimeFieldType

xs:boolean

 

Returns whether the field is a Thereforeâ„¢ Timestamp (date/time) field.

â–  Scale

xs:int

 

Returns scale for decimal field.

â–¡ RegExSample

xs:string

nillable

Example of a valid data string for the field.

â–¡ FieldID

xs:string

nillable

Gets the field ID of the field.

â–¡ Condition

xs:string

nillable

Gets condition for conditional formating for the field.

â–¡ ConditionalFormatting

 

nillable

Gets conditional formating specification. Returns null if the condition is empty.

â–¡ BackgroundColorBGR

xs:int

nillable

Gets background color for the field (in BGR color space) or null.

â–¡ BackgroundColorRGB

xs:int

nillable

Gets background color for the field (in RGB color space) or null.

â–  FieldNo

xs:int

 

Gets number of the field.

â–¡ TextColorBGR

xs:int

nillable

Gets text color for the field (in BGR color space) or null.

â–¡ TextColorRGB

xs:int

nillable

Gets text color for the field (in RGB color space) or null.

â–¡ Formula

xs:string

nillable

Gets formula for calculated field.

â–  IsCalculationTrigger

xs:boolean

 

Returns true if data change on the field can trigger a calculation on the index data.

â–  IsFormattingTrigger

xs:boolean

 

Returns true if data change on the field can trigger formatting update for the index data.

â–¡ RoleAccessMask

 

nillable

Gets role access mask for the field for connected user.

â–  Value

xs:unsignedLong

 

Represents the access mask of the permissions. See also: operation GetRolePermissionConstants.

â–  SortDescending

xs:boolean

 

Gets sort order of the field.

â–¡ Filter

 

nillable

Gets list of referenced table filters. It can only be set on a primary field. For any other field type the property will be null.

≡ WSFieldFilter

 

list nillable


â–¡ Condition

xs:string

nillable

Gets or sets filter condition for given field. It contains either an index FieldID (not FieldNo) or a fixed value. Its value is treated as a fixed value when it contains only [0-9] characters or when it is between double quotation marks ("). This index field value or the fixed value will be compared to the value in the ReferencedTableColumn and the non-matching rows will be filtered out.

â–¡ ReferencedTableColumn

xs:string

nillable

Gets or sets referenced table column(field) for the condition. It contains FieldID (not FieldNo) of the referenced index field.

â–¡ 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


â–  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.

 

 

© 2023 Therefore Corporation, all rights reserved.