Logikcull uses a proprietary version of Elasticsearch to run search queries within Projects.

ℹ️ Need a primer on how Logikcull search syntax works compared to other systems? View our comparison table. 🔗

Logikcull uses common Boolean operators AND, OR, AND NOT; and combines/nests search terms using parentheses.
View our tip sheet for using Boolean operators and nesting your searches here. 🔗

Encapsulate a group of words with double quotes " " to search exactly that combination of words.

Example: "hello john" will return all records where "hello" and "john" are grouped as "hello john".

* asterisk: open-ended character wildcard search

Example: bean* will return beans, beanies, beanbags, etc.

? question mark: single character wildcard searches.

Example: b?an will return bean or bran.

Note: For projects created prior to 5/22/2016, you can't use a wildcard search within a phrase search (i.e. "bean* soup" will not work).

To find misspelled words (or words with similar spellings), use the tilde, ~ , symbol at the end of the term. Add a value between 0.1 and 0.9 to alter the level of similarity.

Example: color~0.3 may return colour, culor, and culur. Whereas color~0.7 may only return colour.

To find words within a specific distance of one another use the tilde, ~ , symbol at the end of a phrase plus the number of words within. ⚠️ We recommend using fewer than 10 words in a proximity search.

Example: (beans rice)~10 will return all records where rice is within 10 words of beans.

Use parentheses to surround the terms being searched. We recommend using parentheses to enclose terms and quotation marks to denote multi-word terms, such as "bank account" in ("bank account" money)~10

Proximity searching is order specific. The proximity value takes into account the order or placement of the words (from left to right) therefore the search (front back)~2 may not necessarily return the exact same records as (back front)~2 due to the shift of adjacent words required for the match. We recommend combining searches in reverse order as a best practice.

Wildcards are supported in proximity searches.

Increase the relevance of returned records by adding the caret ^ symbol with a boost factor (a number) at the end of a term you are searching. The higher the boost number, the more relevant the term will be.

Example: beans^5 rice will make the records with beans more relevant than those with rice.

You can then sort your search results by "Relevancy (desc)" to show your relevant search results first.

Elasticsearch syntax can be entered in any of the following fields:

Your method for searching production Bates numbers in Logikcull depends on how they were generated:

Universal Bates Search

From Logikcull-Generated Downloads (exported from Logikcull)

From Production Uploads (imported into Logikcull)

By Filename

By Document Text

Combining Metadata and Text Searches

Searching Bates Ranges

Searching for a List of Bates Numbers

Note: To search for any documents downloaded prior to April 4, 2018 please use the “Download Doc ID” field.

If the project was created after April 4, 2018, you may use the below syntax to search both database upload and download items for any control number (begin, internal, or end bates). In the advanced search builder, you can use the "Bates number" field. Example search syntax would be:

If the same Bates number exists in another upload/download within the same project, you may narrow the search further to a specific produced set. For example:

If the Bates number you’re looking for was created when the document was produced/downloaded from Logikcull, you can use the “Download Doc ID” field in the advanced search builder. Example search syntax would be:

If the bates number was part of a database upload/production import, you can use the “beg_bates” field. Example search syntax would be:
Unified Bates Search:

If the searches above don't yield results, you may also try searching for Bates numbers against the filename field or text content, depending on how they were loaded in the system. Example search syntax to search by the filename would be:

To search both the text and Bates metadata, you can combine syntax:

file_name:BATES_*0489 OR bates:BATES_*0489 OR text:BATES_*0489

With any of these options above (except text), you can also search for a Bates range.

If you're still unable to locate the document, please don't hesitate to reach out to our support team. You can also grant temporary access to the project and our team can take a closer look and provide suggestions.

You can search for a list of Bates numbers by separating them with spaces and enclosing them in parentheses, like this:

Note: you can search for up to 1,024 boolean operators with a maximum of 40,000 characters.

Logikcull’s Advanced Search Tools allow you build complex searches with Advanced Search Builder, an easy-to use user interface, or Bulk Keyword Search, where you can enter or copy/paste rows of searches to generate search term reports.

Both of these tools can be accessed by clicking the spyglass + gear icon just to the right of the search bar:

The Advanced Search Builder can be used to craft Boolean searches using natural language. This tool can be accessed by clicking the spyglass + gear icon just to the right of the search bar. View our Advanced Search Builder guide. 🔗

DO use the advanced search builder form to Test your results. This will show you how many hits are found within your data.

DO use the advanced search builder form to add parentheses for nested Boolean searches. If you have nested parameters in your advanced search, you'll need to add the parentheses to the resulting query in the search bar. Learn more about nested searches in this article. 🔗

⚠️ DO NOT continue to use the Advanced Search Builder after you have made changes to the resulting search query in the search bar. Once you run a modified search in the search bar, Logikcull stops querying the Advanced Search builder.

The Bulk Keyword Search and Search Term Reporting can be used to type (or copy/paste) multiple search queries that can be compared or combined into a comprehensive search. View our guide for generating bulk keyword and search term reports in Logikcull. 🔗

ℹ️ Please note: filters applied in the filter carousel remain active and will impact your search results.

To create a CSV report of your current search results, click the "Download CSV" icon located above the search bar:

This will open a window where you can customize your report:

If you choose "Create a new template" from the dropdown in step 4, you'll be presented with a new window where you can select the metadata fields to include in your report.

Select fields from the left table to be added to your template on the right by clicking one on the field name. These can be renamed and rearranged on the right side.

Save your template for future use, then press Continue.

Click "Create CSV Download" and watch for your CSV download to appear directly below the Search Results statistics row and begin progressing.

When you're creating a new Logikcull Download, simply choose the following load file field(s) from the list of choices in Step 2:

Comments will contain both the comments themselves, as well as the comment authors.

The CSV Download feature can also be used to create a quick report of these fields outside of a full Download.

Once complete, click the "Click here to download" link to retrieve the CSV file of your search results featuring your chosen metadata.

Once you download your CSV it will disappear from the search page, but you can find a copy of it in your Downloads tab, inside of the CSV Search Results folder by default.

This error message means there's a space at character number # where Logikcull wasn't expecting a space. This is usually the result of a space between the colon separating a field name from a search query, e.g., tags: "tag name". Removing the space at the location indicated by the error should resolve this message.

This is usually because there's an active filter applied to your search and documents are falling out of the results because you've made a change to the work product (i.e., documents disappear when you apply a tag to documents when you're filtering on "Has No Tags" in the filter carousel). The best way to avoid this is to remove the filter and instead run a search directly from the search bar (use syntax tags:none).

There are many reasons why running searches based on other searches may be problematic. Saved search parameters include all filters and deduplication views, which may impact your search results. For example, if you're in the "Global Dedupe" view and you search on a saved search that is in "No Dedupe" view, the results will be constrained to your active filter view. The best practice is to make sure that your deduplication view remains consistent across any saved searches you wish to combine.

Download templates containing Begin Doc or End Doc metadata fields can be selected from the list of available templates for your CSV download, but those fields are not currently available for this type of report. To pull in Bates ranges for your CSV download, you must select Begin Bates num from ____ and/or End Bates num from ____ fields from the list of available fields, like this:

Here’s a search workflow to help identify family members from search results that:

In the following example, we'll use the tags “Responsive” AND “QC Reviewed” for inclusion.

We'll use the tags “Privilege Withhold” OR “Confidential” OR “Do not produce” OR "Has No Tags" to indicate documents which have not been reviewed for exclusion.

ℹ️ TIP: Build your search using the Advanced Search Builder to pick up the syntax for your query. The parentheses will have to be added after your search is populated in the search bar.

(tags:responsive AND tags:”QC Reviewed”) AND NOT (tags:”Privilege Withhold” OR tags:Confidential OR tags:”Do not produce” OR tags:"Has No Tags")

⚠️ TIP: When using parentheses pay close attention to the order of operations. More on Boolean search tips from this FAQ

Create a locked saved search of the results and include families. Name it as "Prod001 Inclusion with family" as an example.

saved_search_name:"Prod001 Inclusion with family" AND (tags:”Privilege Withhold” OR tags:Confidential OR tags:”Do not produce”)

Create a locked saved search of the results and include families. Name it as "Prod001 Exclusion with family" as an example.

TIP: If your exclusion criteria remains consistent you have the option to create just one exclusion saved search that you can reference moving forward. Maybe you can call this "Docs to exclude with family"?

Step 3: Now that you have full family members included in each group you can create a final saved search to remove full family members from your exclusion set.

saved_search_name:"Prod001 Inclusion with family" AND NOT saved_search_name:"Prod001 Exclusion with family"

You can then create a saved search (locked) of the results to use as your final production saved search. These results should leave behind documents that are family inclusive with consistent tagging.

NOTE: Please keep in mind that for any locked saved search with families included, you may need to temporarily unlock and re-lock the search to make sure you are accounting for documents added to the population by way of new uploads added to the project or from having documents tagged or untagged from existing review.