Show/Hide Toolbars

Therefore Web API Programming Interface 1.0

Therefore Web API > Developers Guide > Queries

Internal (built-in) Query Fields

Scroll

These internal values are used to define additional document meta data for searching and sorting in a search execution.

Ā 

Field Name

FieldNo

Description

DocSizeĀ 

1

Size of the Thereforeā„¢ document

FileCount

2

Number of files in the Thereforeā„¢ document

LastModified

3

Date/time when the document was last modified

OldVersion

4

Is there an older version of the document. Returns Yes/No

CreatedOn

5

Date/time when the document was created

CreatedByDisplayName

6

User who created the document

ModifiedByDisplayName

7

Last user who modified the document

CheckedOutOn

8

Date/time when the document was checked-out

CheckedOutByDisplayName

9

User who checked the document out

IsCheckedOut

10

Is the document checked out. Returns Yes/No

Extension

11

The document extension.

CreatedBy

13

User who created the document

CreatedByUserNo

14

User who created the document

ModifiedBy

15

Last user who modified the document

ModifiedByUserNo

16

Last user who modified the document

CheckedOutBy

17

User who checked the document out

CheckedOutByUserNo

18

User who checked the document out

DocSize_DESCĀ 

-1

Size of ThereforeĀ­ā„¢ document in descending order (only for sorting)

FileCount_DESC

-2

Number of files in the Thereforeā„¢ document  in descending order (only for sorting)

LastModified_DESC

-3

Date/time when the document was last modified in descending order (only for sorting)

OldVersion_DESC

-4

Is there an older version of the document. Returns Yes/No in descending order (only for sorting)

CreatedOn_DESC

-5

Date/time when the document was created in descending order (only for sorting)

CreatedByDisplayName_DESC

-6

User who created the document in descending order (only for sorting)

ModifiedByDisplayName_DESC

-7

Last user who modified the document in descending order (only for sorting)

CheckedOutOn_DESC

-8

Date/time when the document was checked-out in descending order (only for sorting)

CheckedOutByDisplayName_DESC

-9

User who checked the document out in descending order (only for sorting)

IsCheckedOut_DESC

-10

Is the document checked out. Returns Yes/No in descending order (only for sorting)

Extension_DESC

-11

The document extension. (only for sorting)

CreatedBy

-13

User who created the document in descending order (only for sorting)

CreatedByUserNo

-14

User who created the document in descending order (only for sorting)

ModifiedBy

-15

Last user who modified the document in descending order (only for sorting)

ModifiedByUserNo

-16

Last user who modified the document in descending order (only for sorting)

CheckedOutBy

-17

User who checked the document out in descending order (only for sorting)

CheckedOutByUserNo

-18

User who checked the document out in descending order (only for sorting)

Ā 

Ā 

Ā 

 

Ā© 2023 Therefore Corporation, all rights reserved.