|
Use macros for complex search queries (Regular Expressions) that will be used regularly. Contact your Administrator for more information on the macros that can be used. By default, you can use macros for date manipulations, e.g. to be able to find documents that have been created, modified or sent 2 days, 5 weeks, 7 months or 3 years ago. With other macros you can search for social security numbers, amounts, holidays, ip numbers, etc. For the complete list, see below. For the complete queries, see the QueryMacros.config file. In this file the predefined queries can be adjusted. Please contact your Administrator.
Instructions
- The following macros can be used to find files that have been created, modified or sent a number of days, weeks, months or years ago:
-
#DaysAgo(<number>)#
-
#WeeksAgo(<number>)#
-
#MonthsAgo(<number>)#
-
#YearsAgo(<number>)#
The mm/dd/yy format will be used for the evaluation, relative to the current date. Leap years and the number of days in a month are taken into account. If the resulting day is not a valid day in the resulting month, the last valid day of the resulting month is used.
#DaysAgo(0)# is resolved in 00:00 of the current day.
Note: Date db type is not supported in Legal Review, only DateTime. Hence "=" is not applicable with these types of macros.
-
The following macros can also be used:
-
#ssn#
Query: (Social Security* or Soc Sec or SSN* or SSNS or SSID) w/2 [0-9]{3}-[0-9]{2}-[0-9]{4}
-
#amount#
Query: (1 of {EUR, CAD, USD, GBP, US$, $, £, €} w/1 1 of {[0-9]+, [0-9]+?[0-9]+, [0-9]+?[0-9]+?[0-9]+, [0-9]+?[0-9]+?[0-9]+?[0-9]+, [0-9]+?[0-9]+?[0-9]+?[0-9]+?[0-9]+}) or (1 of {[$€£][0-9]+, [$€£][0-9]+?[0-9]+, [$€£][0-9]+?[0-9]+?[0-9]+, [$€£][0-9]+?[0-9]+?[0-9]+?[0-9]+, [$€£][0-9]+?[0-9]+?[0-9]+?[0-9]+?[0-9]+}) or (1 of {[0-9]+[$€£], [0-9]+?[0-9]+[$€£], [0-9]+?[0-9]+?[0-9]+[$€£], [0-9]+?[0-9]+?[0-9]+?[0-9]+[$€£], [0-9]+?[0-9]+?[0-9]+?[0-9]+?[0-9]+[$€£]})
-
#holiday#
Query: 1 of { <comma divided list of holidays> }
Note: For the complete query, see the QueryMacros.config file.
-
#month#
Query: 1 of {january, february, march, april, may, june, july, august, september, october, november, december}
-
#day#
Query: 1 of {monday, tuesday,wednesday,thursday,friday,saturday, sunday}
-
#date#
Query: ([0-3][0-9]?[0-3][0-9]?[12][09][0-9]{2}) or (((1 of {jan, feb, mar, apr, may, jun, jul, aug, sep, oct, nov, dec} or #month#) w/1 [0-9]{1,2}) w/1 [12][09][0-9]{2})
-
#ip#
Query: *[1-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}*
-
#nonlatin#
Query: [^a-z0-9]+
-
#DutchAddress#
Query that searches for Dutch streets, postal codes and cities
Note: For the complete query, see the QueryMacros.config file.
Please be aware that very long queries take some time to process.
-
#DutchStreetPostalCode#
Query that searches for Dutch streets and postal codes
Note: For the complete query, see the QueryMacros.config file.
Please be aware that very long queries take some time to process.
-
#DutchCity#
Query: 1 of { <comma divided list of Dutch cities> }
Note: For the complete query, see the QueryMacros.config file.
Please be aware that very long queries take some time to process.
-
#DutchPostalCodeCity#
Query: (([1-9][0-9]{3} [A-Z]{2}) or ([1-9][0-9]{3}[A-Z]{2})) p/2 (1 OF { <comma divided list of Dutch cities> })
Note: For the complete query, see the QueryMacros.config file.
Please be aware that very long queries take some time to process.
-
#DutchIBAN#
Query: 1 of {(NL[0-9]{2} [A-Z]{4} [0-9]{4} [0-9]{4} [0-9]{2}), (NL[0-9]{2} [A-Z]{4}[0-9]{10,11}), (NL[0-9]{2}[A-Z]{4}[0-9]{10,11}), (NL[0-9]{2} [A-Z]{4} [0-9]{10,11})}
-
This functionality is available in:
-
Legal Review
-
Search
-
Document-Level Security
-
Auto-Classification
-
Production
-
Batch Assignment
- Keyword Highlighting
-
Legal Review Collector
|