dms.SelectDistinctFieldValues

This job returns a list of all values of a given DMS field. Multiple parameter fields cannot be considered.

1. Input Parameters

Name Type Required Description

Name	Type	Required	Description
`[FieldName]`	STRING	No	Name of the field
`[ColumnName]`	STRING	No	When [FieldName] refers to a table, [ColumnName] must specify the column. Access rights are not checked, [Filter] is not possible.
`[Notation]`	INT	No	Type of field name: 0 (Default) = DMS Name, 1 = internal name, 2 = database field name
`[Filter]`	STRING	No	Restriction/Search criterion. For text fields, a * is automatically appended. For tables, [Filter] is not evaluated.
`[SortOrder]`	STRING	No	Sort order. Allowed values: 'ASC' (default) or 'DESC'
`[MaxHits]`	INT	No	Maximum number of values to return. Default=-1 (all)

[FieldName]

STRING

Name of the field

[ColumnName]

STRING

When [FieldName] refers to a table, [ColumnName] must specify the column. Access rights are not checked, [Filter] is not possible.

[Notation]

INT

Type of field name: 0 (Default) = DMS Name, 1 = internal name, 2 = database field name

[Filter]

STRING

Restriction/Search criterion. For text fields, a * is automatically appended. For tables, [Filter] is not evaluated.

[SortOrder]

STRING

Sort order. Allowed values: 'ASC' (default) or 'DESC'

[MaxHits]

INT

Maximum number of values to return. Default=-1 (all)

Name Type Dependency Description

Name	Type	Dependency	Description
`Count`	INT	—	Number of output field values (see input parameter Max Hits)
`FieldValues`	BASE64	—	Object list in UTF-8 encoded DMSFieldValueList XML format:

Count

INT

—

Number of output field values (see input parameter Max Hits)

FieldValues

BASE64

—

Object list in UTF-8 encoded DMSFieldValueList XML format:

(INT): 0 = Job successful, otherwise error code
Complete list of error codes