/
1.2 System Fields

1.2 System Fields

1.2.1 System Fields in General

By default, the old enaio® REST API returns certain basic parameters to every result object. With the DMS service for enaio®, we want to minimize the amount of unnecessary data that is transferred to enaio® client. The concept of basic parameters is no longer available in the DMS service for enaio®. Clients must explicitly query the system fields they want to see in the result set, except for the following three:

  • system:objectId

  • system:objectTypeId

  • system:baseTypeId

The following table shows all enaio® system fields that can be queried. System fields always have the prefix system:. In the table below, the system fields that are highlighted in blue and are lower case are identical to yuuvis® Momentum system fields and can be used in queries for both technologies. The other system fields that are not highlighted in blue and written in upper case can only be used for enaio® and do not apply to yuuvis®. Each object type belongs to one of the following types:

  • Folder

  • Register

  • Document

Folders are the top level. They can have registers and documents as their children. Documents are the lowest level and cannot have any children. Registers are in between. In the columns three, four and five of the following table the availability of any system field is displayed. If the cell contains a Yes, the system field is available for this kind of object type, otherwise it is not. The minimum required enaio server version is stated in the column. If this column is empty, the system column is available on all versions of the DMS service for enaio®.


System Field


Data Type

Available for
Document

Available for
Register

Available for
Folder


Description

Min. enaio® version


System Field


Data Type

Available for
Document

Available for
Register

Available for
Folder


Description

Min. enaio® version

system:objectId

String

Yes

Yes

Yes

The ID of the object.

 

system:createdBy

String

Yes

Yes

Yes

User name of the user who created the object.

 

system:creationDate

DateTime

Yes

Yes

Yes

Date and time of creation of this object.

 

system:lastModifiedBy

String

Yes

Yes

Yes

User name of the user who last modified the object.

 

system:lastModificationDate

DateTime

Yes

Yes

Yes

Date and time of the last modification of the object.

 

system:versionLabel

String

Yes

 

 

ID of the variant root object.

 

system:versionSeriesLockedBy

String

Yes

 

 

ID of the user who checked out the object.

 

system:OBJECT_CHECKOUTTIME

DateTime

Yes

 

 

Date and time the object was checked out.

 

system:OBJECT_COUNT

Integer

Yes

 

 

Amount of content files attached to the object.

 

system:OBJECT_FLAGS

Integer

Yes

 

 

Binary encoded information in this integer value. See separate table below.

 

system:OBJECT_AVID

String

Yes

 

 

User name of the user who archived the object.

 

system:OBJECT_AVDATE

Date

Yes

 

 

Date the object was archived. If it is not archived, then the date of creation.

 

system:OBJECT_MAIN

Integer

Yes

 

 

The main type of the object.

 

system:OBJECT_CO

Integer

Yes

 

 

The co-type of the object.

 

system:OBJECT_MEDDOCID

Integer

Yes

 

 

Technical ID of the media where the content is located.

 

system:OBJECT_MEDDOCNA

String

Yes

 

 

Relative path to the content file on the medium.

 

system:OBJECT_LINKS

Integer

Yes

Yes

Yes

Number of links the object contains.

 

system:OBJECT_SYSTEMID

Integer

Yes

Yes

Yes

The ID of the foreign archive. 0 if the content is not stored in a foreign archive.

 

system:OBJECT_FOREIGNID

String

Yes

Yes

Yes

ID of the content on the foreign archive. For reference documents, this is the object Id of the original object.

 

system:OBJECT_USERGUID

String

Yes

Yes

Yes

User name of the enaio user who owns the object.

 

system:OBJECT_DELETED

DateTime

Yes

Yes

Yes

Timestamp the object was moved into the recycle bin.

 

system:OBJECT_INDEXHISTFLAGS

Integer

Yes

Yes

Yes

If the index data history is active for this object, this value is 1. Else it is 0.

 

system:OBJECT_DOCHISTFLAGS

Integer

Yes

 

 

If the content history is active for this object, this value is 1. Else it is 0.

 

system:OBJECT_MIMETYPEID

Integer

Yes

 

 

ID of the mime type for this object.

 

system:OBJECT_FILESIZE

Integer

Yes

 

 

The total size of all content in bytes of the object.

 

system:OBJECT_RETENTION_PLANNED

Date

Yes

 

 

Planned retention date. If there is no retention planned, the value is null and the system field is not in the result.

 

system:OBJECT_RETENTION

Date

Yes

 

 

Retention date. If there is no retention, the value is null and the system field is not in the result.

 

system:OBJECT_SIGNSTATE

Integer

Yes

 

 

Possible values:

 0 – not signed

1 – signed in older versions

2 – signed  in current version

 

system:OBJECT_LOCATIONSCOUNT

Integer

Yes

 

 

The amount of locations of the object.

 

system:OBJECT_DOCPAGECOUNT

Integer

Yes

 

 

Rendtion page count of the content.

 

system:OBJECT_PDFANNOTATIONCOUNT

Integer

Yes

Yes

 

PDF annotations count.

 

system:OBJECT_TXTNOTICECOUNT

Integer

Yes

Yes

Yes

Text notes (details viewer) count.

 

system:SDSTA_ID

Integer

Yes*

 

 

ID of the first parent folder in which the document is located. It does not matter whether it is inside a register of the folder.

 

system:SDREG_ID

Integer

Yes*

 

 

ID of the parent register. If the document is directly located inside a folder, this value is 0. Multiple locations are not taken into account.

 

system:SDREG_TYPE

Integer

Yes*

 

 

Object type ID of the parent register. If the document is directly located inside a folder, this value is 0. Multiple locations are not taken into account.

 

system:REG_STAID

Integer

 

Yes

 

ID of the folder the register is located in.

 

system:REG_PARID

Integer

 

Yes

 

ID of the parent register. If the register is directly inside a folder, the value is 0.

 

system:REG_COLAB

Integer

 

Yes

 

If the register is available in enaio® coLab, this system field has the value 1, otherwise NULL.

10.10

system:FOLDERTYPE

Integer

 

Yes*

 

Object type ID of the folder the register is located in.

 

system:PARENTREGTYPE

Integer

 

Yes*

 

Object type ID of the parent register. If the register is directly inside a folder, the value is 0.

 

system:STAMM_COLAB

Integer

 

 

Yes

If the Folder is available through enaio® coLab this system field has the value 1, otherwise NULL.

10.10

*) These system fields are only available in the [POST] /search endpoint, not [GET] /{objectId}.

1.2.2 System Field OBJECT_SEARCHFLAGS

In addition to the above listed system fields, there is one special system field called system:OBJECT_SEARCHFLAGS.
This system field is only available for search conditions and can take a bit-based integer value.

Bit Value (Decimal)

Description

Bit Value (Decimal)

Description

1

The document objects in the result are archived

2

The document objects in the result are approved for archiving

4

The document objects in the result are not approved for archiving

8

The objects in the result have no content

16

The objects in the result are locked (checked out) by me

32

The objects in the result are locked (checked out) by someone else

64

The objects in the result are located inside a register

128

The objects in the result are located directly inside a folder

256

The objects in the result are loaned out

512

Each one of the objects in the result references another document

1024

The objects in the result have multiple locations

2048