Field-Based Queries
Contents
To create field-based queries
1.From the main window in CloudNine™ LAW, on the Tools menu, click Search Records. The Database Query Builder opens.
2.Configure your search as follows:
To find documents that match these criteria: |
Configure search Field - Operator - Value like this: |
|---|---|
Microsoft Office documents with more than one revision. A document increases its revision number each time it is saved after being edited. |
Revision | Is Greater Than | 1 |
Microsoft Word or Excel file with tracked changes. |
HasTrackChanges | Equals | Y |
E-mails with "Accounting" in the subject line. |
EMail-Sub | Contains | Accounting |
E-mails sent after June 15 2010. |
DateSent | Greater than | 6/15/2010 |
Any document created before June 15 2010 |
DateCreated | Less than | 6/15/2010 |
Documents whose text was successfully extracted during TIFF conversion process. |
TextPStatus | Equals | C |
Documents that had no text extracted during TIFF conversion process. |
TextPStatus | Equals | N |
Documents whose text extraction during TIFF conversion process resulted in an error. |
TextPStatus | Equals | E |
3.Click Add Condition.
4.In the Send Results To field, select one of the tools as needed.
5.Click Execute.