| 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 |
Deprecated, operand is ignored
Equal / bool
|
| OnlyShortcuts | 39 |
Deprecated, if true nothing is returned
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
|
| StopSearchAfter | 69 |
Limits the number of items returned by search
Equals / bool
|
| OnlyLastDocumentVersion | 70 |
Only last DocumentVersion (dbo.DocumentVersions.IsLast)
Equals / bool
|
| OnlyLastMetadataVersion | 71 |
Only last MetadataVersion (dbo.MetadataVersions.IsLastForDocumentVersion)
Equals / bool
|
| OnlyNotActiveWorkflow | 72 |
Only files without active workflows are included
Equals / bool
|
| OnlyHasNoSupporitingWorkflow | 73 |
Only files without active supporting workflows are included
Equals / bool
|
| OnlyNotActiveEasyApprovalWorkflow | 74 |
Only files without active easy approval workflows are included
Equals / bool
|
| OnlyNotActiveEasyViewWorkflow | 75 |
Only files without active easy view workflows are included
Equals / bool
|
| IncludeEditWhileWorkflowActiveEnabledOption | 76 |
When EditWhileWorkflowActiveEnabledOption system-wide option is enabled,
utilization of IncludeEditWhileWorkflowActiveEnabledOption
will alert the search for files without active workflow, without active supporting workflow,
and without active easy approval workflow. So, these three conditions are not taken into account
(i.e. returned document can have, e.g., active workflow).
Equals / bool
|
| NotProcessedScheduledEventDateId | 77 |
Search for not processed documents in event
any / (int) event id, int for Before/After operator or DateTime for other operators
|