The Basics
You can use Boolean queries AND, OR, AND NOT to include or exclude certain search conditions.
⚠️ Ensure your Boolean queries are capitalized, otherwise Logikcull will search for the word "and"
For example:
tags:Harry AND tags:Sally
Include all documents tagged with both Harry AND Sally
tags:Responsive AND NOT tags:Privileged
Include all "Responsive" tags and exclude (AND NOT) all "Privileged" tags
(bean* OR rice) AND NOT quinoa
Include all keywords starting with "Bean" (bean, beans, beanie, etc) OR "Rice", but exclude any documents that contain "quinoa"
Exclusion Searches
Sometimes you need to run an exclusion search, or search using a negative clause. You can do this easily by starting your search query with the Boolean operator NOT.
For example, let's say you need to exclude all emails from domain names dogfancy.com or catfancy.com because they're irrelevant to your review. The search
document_type:Email AND NOT email_fields.from_domain:(dogfancy.com OR catfancy.com)
will result in excluding emails where those domains are in the email metadata.
Nested Boolean Searches
Searches run left-to-right, but you may also "nest" your search conditions in parentheses, so that searches within the parentheses are run first, followed by those outside the parentheses from left-to-right.
For example, let's say you need to run a search for documents tagged "For Further Review" that are also tagged either "Hot" or "Responsive." The search
tags:"For Further Review" AND (tags:Hot OR tags:Responsive)
will result in only those documents tagged "For Further Review" that are also tagged either "Hot" or "Responsive:"
Without parentheses, the search
tags:"For Further Review" AND tags:Hot OR tags:Responsive
will return any document tagged with both "For Further Review" AND "Hot", OR any document tagged "Responsive," regardless of any other condition.
⚠️ important: if using the Advanced Search Builder to construct your search query, you'll need to pay close attention to the order of operations and add parentheses to the resulting search in the search bar as necessary.
Let the support team know if you have any questions about using Boolean operators in your search queries!