Question
What are virtual fields?
Answer
"Virtual" fields/columns are system fields, included in the database, that do not have a physical column to display in the user interface.
Searching, using virtual columns, will result in records being displayed in the item list that meet the search criteria, but the virtual column will not appear to display the data. These virtual fields can be selected in the Advanced Search builder, when building a "Conditions" search and can be used in the quick search box.
Below are the virtual fields and their associated search operators.
Virtual Field | Search Operators | Description |
AnyDate | Equal | Searches any date field identified in the columns in case review. |
AnyField | Equal, Contains | Searches any meta data fields regardless of field type, i.e., text, date, number. |
AnyText | Equal, Contains | Searches any text fields and FullText/OCR |
Fulltext | Fails, Exists | Searches filtered or OCR text. If a document has both, the OCR is searched. |
Image | Fails, Exists | Identifies records that have an associated image. |
IsPivot | Fails, Exists | Identifies documents that are or are not a pivot document |
OCRText | Fails, Exists | Searches for documents that contain OCR Text, text loaded through the Import Process. |
Redaction | Fails, Exists | Identifies documents that have been redacted or have not been redacted. |