Show/Hide Toolbars

Therefore Web API Programming Interface 1.0

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

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

 

Executes a workflow query returning process information for all active processes.

 

 

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

 

Element Name

Element Type

Restrictions

Description

â–  parameters

 

 


â–  WorkflowFlags

 

mandatory

restriction enum (xs:string)

- DefaultInstances (0)

- RunningInstances (1)

- FinishedInstances (2)

- AllInstances (3)

- ErrorInstances (4)

Sets workflow flags for the query.

 

 

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

 

Element Name

Element Type

Restrictions

Description

â–  parameters

 

 


â–¡ WorkflowQueryResultList

 

optional nillable

Gets list containing query result items, representing process information for one process each.

≡ WSWorkflowQueryResult

 

optional unbounded nillable


â–¡ ResultRows

 

optional nillable

Result rows

≡ WSWorkflowResultRow

 

optional unbounded nillable


â–¡ AccessMask

 

optional nillable

DEPRECATED: Use the RoleAccessMask parameter instead. Gets the access mask of the permissions.

â–  Value

xs:unsignedLong

optional

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

â–¡ IndexValues

 

optional nillable

List of index values presented as a string list.

≡ IndexValue

xs:string

optional unbounded nillable


â–  Size

xs:long

optional

Gets the size of the associated Thereforeâ„¢ document.

â–  VersionNo

xs:int

optional

Gets the version number of the document.

â–  WorkflowNo

xs:int

optional

Gets the workflow number.

â–  Status

 

optional

restriction enum (xs:string)

- DocStatusCheckedIn (0)

- DocStatusCheckedOutByUser (1)

- DocStatusCheckedOut (2)

- CaseStatusNormal (10)

- CaseStatusClosed (11)

- Reserved1 (9101)

- Reserved2 (9102)

Gets status of the document.

â–  InstanceNo

xs:int

optional

Gets instance number.

â–  TokenNo

xs:int

optional

Gets token number.

â–¡ RoleAccessMask

 

optional nillable

Gets role access mask for connected user.

â–  Value

xs:unsignedLong

optional

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

â–¡ CaseDefName

xs:string

optional nillable


â–¡ CaseDefNo

xs:int

optional nillable


â–¡ CategoryName

xs:string

optional nillable


â–¡ CategoryNo

xs:int

optional nillable


â–¡ ProcessName

xs:string

optional nillable


â–¡ ProcessNo

xs:int

optional nillable


â–¡ Columns

 

optional nillable

List of fields in the result.

≡ WSCategoryField

 

optional unbounded nillable


â–  BelongsTo

xs:int

optional

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

â–  BelongsToTable

xs:int

optional

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

â–¡ Caption

xs:string

optional nillable

Gets the caption of the field.

â–  CaseSensitive

xs:boolean

optional

Gets information if the field is case sensitive.

â–¡ ColName

xs:string

optional nillable

Gets the column name of the field in the database.

â–  CounterMode

 

optional

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

optional nillable

Gets the default value for this field.

â–  DependencyMode

 

optional

restriction enum (xs:string)

- Referenced (0)

- SynchronizedRedundant (1)

- EditableRedundant (2)

Gets the dependency mode of this field.

â–  DisplayOrderPos

xs:int

optional

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

â–  DontLoadValues

xs:boolean

optional

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

â–  FieldNo

xs:int

optional

Gets the field number of this field.

â–  FieldType

 

optional

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

optional nillable

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

â–  Guid

xs:string

optional

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

optional

Gets the height of this field in the category dialog.

â–¡ IndexDataFieldName

xs:string

optional nillable

Gets the name of the index data field.

â–  IndexType

xs:int

optional

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

â–  IsForeignDatatype

xs:boolean

optional

Returns whether the field is a foreign data type.

â–  IsMultipleKeyword

xs:boolean

optional

Returns whether the field is a multiple keyword.

â–  IsSingleKeyword

xs:boolean

optional

Returns whether the field is a single keyword.

â–  KeepRedundant

xs:boolean

optional

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

â–  Length

xs:int

optional

Gets the length of the field.

â–  Mandatory

xs:boolean

optional

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

optional

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

â–  PosY

xs:int

optional

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

â–¡ RegularExpr

xs:string

optional 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

optional

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

â–  TypeGroup

 

optional

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

optional nillable

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

â–¡ TypeMultiInner

xs:string

optional nillable

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

â–¡ TypeMultiJoin

xs:string

optional nillable

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

â–¡ TypeMultiOuter

xs:string

optional nillable

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

â–  TypeNo

xs:int

optional

Gets the type number of this field.

â–¡ TypeTableName

xs:string

optional nillable

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

â–  Visible

xs:boolean

optional

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

â–  Width

xs:int

optional

Gets the width of this field in the category dialog.

â–¡ WorkflowField

xs:string

optional nillable

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

â–  SelectFromDropDownBox

xs:boolean

optional

Returns whether dropdown box should be used to select value.

â–¡ DisplayProperties

 

optional nillable

Gets display properties of this field.

â–  BackgroundColor

xs:int

optional

Gets the background color of the field.

â–  Bold

xs:boolean

optional

True if the font is formatted as bold.

â–¡ FaceName

xs:string

optional nillable

Gets the face name.

â–  FontSize

xs:int

optional

Gets the font size of the field.

â–  HorizontalAlignment

 

optional

restriction enum (xs:string)

- Left (0)

- CenterH (1)

- Right (2)

Gets the horizontal alignment of the text.

â–  Italic

xs:boolean

optional

True if the font is formatted as italic.

â–  Padding

xs:int

optional

Gets a value that indicates the thickness of padding space.

â–  TextColor

xs:int

optional

Gets the text color of the field.

â–  Underlined

xs:boolean

optional

True if the font is formatted as underlined.

â–  VerticalAlignment

 

optional

restriction enum (xs:string)

- Top (0)

- CenterV (4)

- Bottom (8)

Gets the vertical alignment of the text.

â–¡ ImageDocNo

xs:int

optional nillable

Gets the number of the document image.

â–  IsImageFieldType

xs:boolean

optional

Returns whether the field is an image field.

â–  IsTabControlFieldType

xs:boolean

optional

Returns whether the field is a tab control field.

â–  ParentFieldNo

xs:int

optional

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

â–  ShowInTabNo

xs:int

optional

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

â–¡ Tabs

 

optional nillable

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

≡ WSTabInfo

 

optional unbounded nillable


â–  BackgroundColor

xs:int

optional

Gets background color.

â–¡ Caption

xs:string

optional nillable

Gets the caption of the tab.

â–  Position

xs:int

optional

Gets the position of the tab in the tab control.

â–  TabColor

xs:int

optional

Gets the tab color of the tab.

â–  TabNo

xs:int

optional

Gets the number of this tab.

â–  TextColor

xs:int

optional

Gets the text color of the tab.

â–  Visible

xs:boolean

optional

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

â–¡ AccessMask

 

optional nillable

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

â–  Value

xs:unsignedLong

optional

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

â–  IsAutoAppendField

xs:boolean

optional

Gets access mask for the field for connected user.

â–  IsDateTimeFieldType

xs:boolean

optional

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

â–  Scale

xs:int

optional

Returns scale for decimal field.

â–¡ RegExSample

xs:string

optional nillable

Example of a valid data string for the field.

â–¡ FieldID

xs:string

optional nillable

Gets the field ID of the field.

â–¡ Condition

xs:string

optional nillable

Gets condition for conditional formating for the field.

â–¡ ConditionalFormatting

 

optional nillable

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

â–¡ BackgroundColorBGR

xs:int

optional nillable

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

â–¡ BackgroundColorRGB

xs:int

optional nillable

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

â–  FieldNo

xs:int

optional

Gets number of the field.

â–¡ TextColorBGR

xs:int

optional nillable

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

â–¡ TextColorRGB

xs:int

optional nillable

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

â–¡ Formula

xs:string

optional nillable

Gets formula for calculated field.

â–  IsCalculationTrigger

xs:boolean

optional

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

â–  IsFormattingTrigger

xs:boolean

optional

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

â–¡ RoleAccessMask

 

optional nillable

Gets role access mask for the field for connected user.

â–  Value

xs:unsignedLong

optional

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

â–  SortDescending

xs:boolean

optional

Gets sort order of the field.

 

 

 

Legend:

 

â– 

Not nillable element.

â–¡

Nillable element.

≡

Unbounded element (List of elements).

Normal

Optional element.

Bold

Mandatory element.

 

 

© 2024 Therefore Corporation, all rights reserved.