| Member name | Value | Description |
---|
| AnywhereInFileHold | 0 |
Search for any user defined metadata field, document name or file contents using Full Text Search.
Contains / String
|
| FullTextSearch | 1 |
Obsolete. Use AnywhereInFileHold instead.
|
| DocumentName | 2 |
Equal, Contains / String.
Contains operator uses Full Text Search index.
|
| FolderName | 3 |
Equal, Contains / String
Contains operator uses simple SQL search without Full Text Search index.
|
| OwnedBy | 4 |
Equal, InList
|
| ApprovedBy | 5 |
Equal, InList
|
| DateLastModified | 6 |
any / DateTime
|
| DateCreated | 7 |
any / DateTime
|
| DateApproved | 8 |
any / DateTime
|
| FolderId | 9 |
Equal / int (id)
|
| CabinetId | 10 |
Equal / int (id)
|
| DrawerId | 11 |
Equal / int (id)
|
| CategoryId | 12 |
Equal / int (id)
|
| DrawerAndFolderGroup | 13 |
Equal / 2 operands required: int (DrawerId) + int (FolderGroupId)
Note exception in description of operands.
|
| SchemaFieldValue | 14 |
This type of search requires providing FieldDefinitionId (int) as the first operand.
First is int with FieldDefinitionId.
Operand types from 2. to n. depend on FileHold data type of the field identified by FieldDefinitionId.
Operators also depend of field data type.
text -> Equal / String; IsBlank (without operands)
number, currency -> any / number?; IsBlank (without operands)
date -> any / DateTime; IsBlank (without operands)
checkbox -> Equal, bool
drop down menu -> Equal, InList / int (item id); IsBlank (without operands)
Note exception in description of operands.
|
| SchemaId | 15 |
Equal, InList / int (schema id)
|
| IncludeArchive | 16 |
if not present assume false
Equal / bool
|
| IncludeDeleted | 17 |
if not present assume false
Equal / bool
|
| OnlyDeleted | 18 |
Equal / bool (default is false, you must also set IncludeDeleted to true for this search type to work)
|
| LogAction | 19 |
Equal, InList / int (action id, FileHold.Common.ActionType enumeration)
|
| LogEntryDate | 20 |
any / DateTime
|
| LogActionPerformer | 21 |
Equal, InList / Guid (Guid.Empty means current user)
|
| FileType | 22 |
Equal, InList / int (extension id as returned by the GetFileExtensions() method of Document Manager)
|
| DocumentId | 23 |
Equal / int (document id)
|
| DocumentVersionId | 24 |
Equal, InList / int (document version id)
|
| MetadataVersionId | 25 |
Equal / int (metadata version id)
|
| ScanningBatchId | 26 |
Obsolete. Do not use.
|
| OnlyLastVersion | 27 |
Equal / bool (only last binary version - default is true), bool (only last metadata version - default is true)
|
| VirtualFolderId | 28 |
Equal / int (virtual folder id)
|
| Tray | 29 |
Equal / bool
|
| IsStarredByUser | 30 |
Equal / bool
|
| IsCheckedOutByUser | 31 |
Equal, InList / int (user)
|
| OnlyWhenCabinetOwner | 32 |
Equal / bool
|
| ApprovalStatus | 33 |
Equal / int (ApprovalStatus Enumeration)
|
| WithAlert | 34 |
Equal / bool
|
| WithReminder | 35 |
Equal / bool
|
| DateAccessed | 36 |
Allows for searches like 'recently accessed'
any / DateTime
|
| IsLinkedWithDocument | 37 |
Equal / int (document id of document for which linked document should be returned)
|
| IncludeShortcuts | 38 |
if not present assume true
Equal / bool
|
| OnlyShortcuts | 39 |
if not present assume false
Equal / bool
|
| ReturnLastForBinaryVersion | 40 |
Return last metadata version for each matching document version. Used for searching for historical
metadata values.
if not present assume false
Equal / bool
|
| FileSize | 41 |
any / long
|
| IncludeInvisible | 42 |
if not present assume true
Equal / bool
|
| Location | 43 |
Wrap a FolderId, DrawerId, DrawerAndFolderGroup or CabinetId condition.
Equal / SearchType, params
|
| SchemaWithField | 44 |
Equal / int, int (schemaId, fieldId)
|
| IsAssociatedWithActiveTask | 45 |
operator is not taken into consideration; operands are not needed
|
| IsAssociatedWithWorkflow | 46 |
operator is not taken into consideration; operands are not needed
WARNING: must be used with ReturnLastForBinaryVersion condition set to true
|
| HasMarkup | 47 |
Equal / bool
|
| DocumentFormat | 48 |
Equal / DocumentSchemaType
|
| DocumentNumber | 49 |
Equal / string
|
| VersionNumber | 50 |
Equal / string
|
| SmartFolderId | 51 |
For internal use only
|
| HasLink | 52 |
Equal / bool
|
| IsFavorite | 53 |
Equal / bool
|
| ScheduledEventDate | 54 |
any / (int) documentSchemaId, (int) event type, int for Before/After operator or DateTime for other operators
|
| CheckedOutStatus | 55 |
Equal / bool ( (false)CheckedIn / (true)CheckedOut)
|
| CheckedOutBy | 56 |
Equal, InList / (int) user id
|
| AllReminders | 57 |
has reminder with given initial date
any / DateTime
|
| ActiveTaskDueDate | 58 |
has active task with given due date
any / DateTime
|
| CompletedTaskDate | 59 |
has completed task with given completed date
any / DateTime
|
| WorkflowInstance | 60 |
is associated with specific workflow instance
Equal / guid
|
| ScheduledEventDateId | 61 |
any / (int) event id, int for Before/After operator or DateTime for other operators
|
| ReviewStatus | 62 |
Equal / int (ReviewStatus enum)
|
| DateReviewed | 63 |
any / DateTime
|
| NotNotifiedScheduledEventDateId | 64 |
any / (int) event id, int for Before/After operator or DateTime for other operators
|
| DtSearchFileOnly | 65 |
Search in file content using dtSearch.
Contains / String
|
| DtSearchMetadataOnly | 66 |
Search in metadata content using dtSearch.
Contains / String
|
| DtSearchRawQuery | 67 |
Search that send user query directly to dtSearch.
Contains / String
|
| EmptySnapshot | 68 |
Create an empty snapshot
Equals / bool
|