Querying Data

  • Updated

OWL’s Query Data modules have the complete functionality of different types of searches. These can be accessed from the OWL Intelligence Platform header. 

 

Steps to Access Query Data Search Options

  1. Hover over Query Data. 
  2. This will open a menu of all the available searches. 

    - The searches that are available under the Query Data menu are Data source, Geospatial, Keyword, Smart City View, and Batch (under development).

page136_img1.png

 

OWL Data Source Searches

 

Steps to Query by Data Source: 

1. Go to the Home Page. 

2. Click on “Query Data” located in the header. 

3. A menu will appear displaying all available search types. 

4. Select the “Data Source” option. 

5. You’ll be redirected to the Product Selection page. 

6. Choose the relevant OWL products from the product search interface. 

page131_img1.png

7. If you select Docs or Vaults, an additional dropdown will appear beneath the product list. This dropdown displays all data sources created and assigned to OWLdocs and OWLvault records. 

8. You can view the selected data source by clicking on the View Selected Data source link. 

page132_img1.png

9. To refine your search, select only the specific data sources you wish to include. 

10. Once your selections are complete, the Next button will become active. Click it to proceed. 

11. You’ll be taken to the OWL Keyword Search page. 

12. Enter your desired query into the Keyword Search field. 

page132_img2.png

13. Click Submit to initiate the search. 

14. OWL will analyze the input to determine its data type (e.g., phone number, SSN, address) and automatically map it to the appropriate global attribute for the search. 

15. You can modify the selected attribute and keyword or add new ones before proceeding. 

page133_img1.png

16. Click Resubmit to activate the product search. 

page133_img2.png

17. The products you selected on the Data Source Product Selection page—along with any chosen OWLvault data sources—will be displayed as selected. 

page134_img1.png

18. After confirming your product and keyword selections, choose the desired view to display your search results. Select Compliance and Case Management data: 

page134_img2.png

19. Choose a Retention Policy from the available options under your organization’s search compliance settings. 

20. If applicable, select Data Access Rights—especially if they are required or mandatory for the search. 

21. Include 28 CFR Part 23 compliance fields if your search criteria demand it. 

22. In the Case Management section, use the Department dropdown to select the department where the search will be conducted. This dropdown displays all departments where the logged-in user is active. 

23. Optionally, choose a Case or Subject from the corresponding dropdown to narrow your search within a specific context. 

24. If Case and Subject selection are not mandatory, you may proceed without them. This will create what is referred to an orphan search (see below).

25. If both a search compliance and a case compliance are present, you may choose to retain the search compliance and bypass the case compliance. 

26. Once all required fields are selected, click the Search button to initiate the OWL search. 

page135_img1.png

27. A loading indicator will appear on the page while the search is in progress. 

page135_img2.jpeg

28. Once the search completes, you’ll be automatically redirected to the Results screen, where all product search results will be displayed according to the views you previously selected.

 

OWL Keyword Searches

Keyword search in OWL enables users to query the entire organizational OWL database using a single keyword. This includes all record types—documents, extracted and imported data, structured and unstructured query data—ensuring a comprehensive search across the system. When a keyword is entered, OWL scans the database and retrieves all matching records and relevant information, significantly reducing investigation time and enhancing accuracy. 

Example: If a user inputs a phone number like “5123334444,” OWL intelligently analyzes it and returns associated products or records linked to that keyword. 

 

Steps to perform a keyword search

  1. Go to the Home Page.
  2. Click on “Query Data” located in the header. 
  3. A menu will appear displaying all available search types. 
  4. Click on the Keyword search. 

page136_img1.png

5. You will be redirected to the keyword search page. 

page136_img2.png

6. You can also come directly to the keyword page from the Home page, type the address in the keyword field on the keyword search box, and click on the Search button. 

page137_img1.png

7. Enter the keyword that you want to search against the OWL Datasource. The keyword could be any data that can be associated with the organization's attributes. 

For example, 

• Name 

• SSN 

• Phone Number 

• Address 

• Date of Birth 

• Social media username 

• Email Address 

 

8. Once you have entered your keyword into the keyword field. The Submit button will be enabled. 

9. Click on the Submit button. Now, the OWL AI system will analyze the submitted keyword and attempt to map it first with the OWL attributes. For example, if you have entered a person's name. Let's say “Jon Doe”. Now this will map with attributes like FirstName: Jon and LastName: Doe. Keyword: Jon Doe 

page137_img2.png

10. Keyword: jon.doe@gmail.com 

page138_img1.png

11. If the mapped attribute or suggested attribute by OWL does not match your expectation, then there is an option to edit and change the attribute manually from the available list. To do that, click on the edit button next to the Search variables and select a new attribute or value if needed. 

page138_img2.png

12. You can manually add more attributes to your keyword search by clicking on the Add More Attribute button. This will allow you to select new attributes from the list of available attributes. 

page138_img3.png

13. Once you have selected the attributes and the respective keywords, click on the Resubmit button to fetch the available OWL products and enable the Search. 

page139_img1.png

14. Now, select/unselect the OWL products from the list. Whatever products you select here will go under a deep keyword search based on the attributes selected. 

page139_img2.png

15. To view the OWL search response after performing a keyword search, you need to select the appropriate result screen views from the available options in OWL. These views determine how the search results are displayed and what type of data is emphasized. 

page139_img3.png

16. The next section will be the compliance section. As per the compliance guideline defined by your organization admins, select the compliance that are required or optional, such as Retention Policy, Data Access Rights, and/or industry-specific regulations such as 28 CFR part 23.

page140_img1.png

17. After selecting compliances, you need to select fields from the Case Management section. If you are working under multiple departments in an organization, then you need to select a department from the department dropdown from where you want this search to happen. 

18. Once you select a department, all cases and subjects either created by you or shared with you will appear in the respective dropdown menus. Choose the Case and Subject you want to associate with the search. If you select a Subject before choosing a Case, the search will be linked to a subject that isn’t tied to any case. If you select a Case first, the Subject dropdown will update to show only the subjects associated with that case. The Collaborators and Case Name fields will be automatically populated based on the selected case. 

  • Alternatively, you can choose not to associate this search with an existing record. These are referred to as orphan searches (see below).

page140_img2.png

19. When you select search compliance and also select Case/Subject, then before searching, there is a checkbox to give precedence to the search compliance over Case/Subject compliance. 

page141_img1.png

20. Once you have selected all the mandatory fields that are required for the search, the search button will be enabled. 

21. Click on the Search button to initiate the keyword search. You will see a loader on the page for some time. Once the search completes, you will see the search results on the result screen view with whatever views you have selected previously. 

22. Keyword search in OWL functions by combining all the attributes you've selected as search variables into a single query. For instance, if you choose First Name, Last Name, and SSN, OWL will merge these into one keyword string and search accordingly. 

Example

• First Name: Jon 

• Last Name: Doe 

• SSN: 777-22-4444 

• Keyword: Jon + Doe + 777-22-4444 

 

23. OWL will then look for records that match this exact combination. If a record contains only partial matches—such as just the first name or last name—it will not appear in the results. Only complete matches across all selected attributes are considered valid and displayed on the result screen.

 

Wildcard & Range Searches

Wildcard and range searches are powerful forms of keyword search that enable users to locate partial matches when the exact term is unknown. These search methods allow for flexible and precise querying by leveraging pattern recognition and value intervals, significantly improving the scope and accuracy of results. 

OWL supports wildcard and range searches across various data types, using both partial and exact match techniques: 

 Text: Exact match, prefix, suffix, and contains 

• Boolean: Exact match 

• Date: Exact match, before, after, and date range 

 Time: Exact match, before, after, and time range 

• Date-Time: Exact match, before, after, and range

• Number: Equals, less than, greater than, and range 

• Amount: Equals, less than, greater than, and range 

• Duration: Exact time, before, after, and time range These capabilities make OWL searches highly adaptable to diverse data formats and investigative needs. 

 

Steps to perform wildcard & range search: 

1. Go to the Home Page. 

2. Click on “Query Data” located in the header. 

3. A menu will appear displaying all available search types. 

4. Click on the Keyword search. 

5. You will be redirected to the keyword search page.

6. Select the Wildcard & Range tab. You will see the wildcard & range search page. 

A screenshot of a computer

AI-generated content may be incorrect.

7. The Add Attribute section contains a Category dropdown. Select a category. Each category represents a number of attributes that have a common category. You will see the attributes in the attribute dropdown. These attributes can be of different data types. 

8. Based on the attribute data type, OWL decided what kind of wildcard or range search is allowed. For example, if you have selected the First Name attribute, then only the data type that can be searched is “Text”. So, for text, the searches that will be possible are “Exact match, prefix, suffix, and contains”.

A screenshot of a computer

AI-generated content may be incorrect.

9. Select the type of search you want to do by selecting the radio button from all the options. OWL supports multiple keyword matching techniques to enhance search flexibility and accuracy: 

• Exact Match: The full keyword is searched exactly as entered. Example: Searching for Full Name: Jon Doe will look for records containing the exact phrase “Jon Doe” across selected products. 

 Prefix Search: Matches records where the beginning of a field aligns with the keyword. Example: Searching First Name: Jon will return results where the first name starts with “Jon,” such as “Jonathan” or “Jonas.” 

• Suffix Search: Matches records where the end of a field aligns with the keyword. Example: Searching Last Name: Doe will return results where the last name ends with “Doe,” such as “McDoe” or “Doe.” 

• Wildcard (Contains) Search: Matches any record that contains the keyword anywhere within the field. Example: Searching Middle Name: Jon will return results where “Jon” appears anywhere in the middle name, such as “Aljon” or “Jonas.” 

 

10. After selecting the search type, enter the value that you want to search for in the Attribute Value field. 

A screenshot of a computer

AI-generated content may be incorrect.

11. Click on the Add button to add this attribute to the search attribute. 

A screenshot of a computer

AI-generated content may be incorrect.

12. If you want to add new attributes, click on the Add Attribute button. This will open new attribute fields to be selected. Select an attribute: Age from the person category. Here, the attribute data type is number. 

A screenshot of a computer

AI-generated content may be incorrect.

Search Types available are – 

 Equal To: Searches for records that exactly match the specified value. Example: Age = 50 will return records where age is exactly 50. 

 Less Than: Retrieves records where the attribute value is lower than the specified input. Example: Age < 50 will match records with an age below 50. 

 Greater Than: Retrieves records where the attribute value exceeds the specified input. Example: Age > 50 will match records with an age above 50. 

 Range: Requires two boundary values; records falling within this interval will be matched. Example: Age: [45 TO 60] will extract records. 

 

13. Select an attribute having a Data type category of Date. Now you will see that the search options have changed. 

A screenshot of a computer

AI-generated content may be incorrect.

• Exact Date: Searches for records that exactly match the specified date. 

• Before: Searches for records that happened before the specified date. 

 After: Searches for records that happened after the specified date. 

• Date Range: Searches for records that happened between the specified dates. 

 

14. When you have selected multiple attributes for the wildcard & range search, you have to select another option, whether you need to do an OR or AND operation between the attributes selected. To do that, you need to select the toggle button present on the top right corner of the selected attributes. 

A screenshot of a computer

AI-generated content may be incorrect.

The AND operation generates a query that combines all selected attributes. A record in OWL will only be retrieved if it matches the complete set of attributes specified. This ensures precise results based on exact attribute combinations. 

In contrast, the OR operation treats each attribute independently. If any single attribute matches a record in OWL, that record will be included in the results. This approach supports broader searches based on individual attribute matches. 

• AND: Requires all selected attributes to match for a result to be returned. 

• OR: Returns results if any one of the selected attributes matches. 

 

15. Once the attributes are selected, you can select the OWL products that are available for the wildcard & range searches. So far, Docs and Vault products have been enabled for this search. 

16. Select these products for the search. Once you select the products, you will see the Datasource dropdown for OWLdocs & Vault products. You can select all data sources or any specific data sources from which the search should be conducted. 

17. Select the views from the view options that you need to see the data loaded on the result screen. 

A screenshot of a computer

AI-generated content may be incorrect.

18. The next section will be the compliance section. As per the compliance guideline defined by your organization admins, select the compliance that are required or optional (Retention Policy, Data Access Rights, 28 CFR part 23, etc.)

19. After selecting compliances, you need to select fields from the Case Management section. If you are working under multiple departments in an organization, you will need to select a department from the department dropdown from where you want this search to happen. 

20. Once you select a department, all cases and subjects either created by you or shared with you will appear in the respective dropdown menus. If desired, choose the Case and Subject you want to associate with the search. If you select a Subject before choosing a Case, the search will be linked to a subject that isn’t tied to any case. If you select a Case first, the Subject dropdown will update to show only the subjects associated with that case. The Collaborators and Case Name fields will be automatically populated based on the selected case.

  • Alternatively, you can choose not to associate this search with an existing record. These are referred to as orphan searches (see below).

A screenshot of a computer

AI-generated content may be incorrect.

21. When you select search compliance and also select Case/Subject, then before searching, there is a checkbox to give precedence to the search compliance over Case/Subject compliance. 

A screenshot of a computer

AI-generated content may be incorrect.

22. Once you have selected all the mandatory fields that are required for the search, the search button will be enabled. 

23. Click on the Search button to initiate the Wildcard search. You will see a loader on the page for some time. Once the search completes, you will see the search results on the result screen view with whatever views you have selected previously. 

24. To initiate a wildcard search from a specific vault Datasource, click the “Select Template from OWLvault” button. This will reveal the Datasource field. 

A screenshot of a computer

AI-generated content may be incorrect.

25. Choose the desired Datasource template for your search. Once selected, all attributes associated with that vault template will automatically populate on the screen—initially without any values. 

26. Enter values for the attributes you wish to include in the search. After setting your criteria, proceed to select the appropriate views, compliance settings, and case management details. Finally, click Search to execute the wildcard search.

A screenshot of a computer

AI-generated content may be incorrect.

 

OWL Free Text Searches

Most searches in OWL utilize structured data in conjunction with keywords. However, OWL also allows you to perform a free-text search, which works on unstructured data, such as the data extracted by OWL. This type of search looks through both structured and unstructured data to find anything that contains the word or phrase you entered. 

For example, if you search for “Jon”, OWL will look for matches anywhere that word appears—whether it’s inside a sentence, a phrase, or even part of a larger text. 

OWL’s free-text search doesn’t just look for single words—it also supports conditional operators. This means you can combine multiple keywords in one search, separated by operators, to narrow down your results and make them more precise. 

For example, if you enter: 

Orange Theory + Austin 12, 2022 + Shooting in Austin 

OWL will search across both structured and unstructured data to find matches that contain all of those terms together. 

In short, free-text search lets you go beyond simple keywords by building more complex queries that help you find exactly what you’re looking for. 

 

Operators 

• AND 

• OR 

• + (plus) - considered as AND 

• | (pipe) - considered as OR 

 

Free Text Search Considerations 

• Words between double quotes (“) should be considered as a single word and should not be split. 

• Any spaces in the Free text should be trimmed (Spaces between words are not to be considered here). Spaces within double quotes should not be trimmed and should be considered as-is received. 

• Currently, only one SINGLE operator in the Free text is supported. e.g., Jon or Doe | Austin 

• Multiple operators in Free text are not supported currently. e.g., Jon and Doe | Austin → and Operator, pipe (which is OR) Operator 

 

Steps to perform Free Text Search in OWL:

1. Go to the Home Page. 

2. Click on “Query Data” located in the header. 

3. A menu will appear displaying all available search types. 

4. Click on the Keyword search. 

5. You will be redirected to the keyword search page. 

6. From the keyword page, enter the keyword that you want to search inside the keyword field. 

7. Once you enter the keyword into the keyword field, the “Free Text Search” checkbox below the keyword field will be enabled. 

8. Click the checkbox. Once selected, all keyword search attribute fields will disappear, and only the OWL product list will be shown. 

A screenshot of a computer

AI-generated content may be incorrect.

9. Choose the OWL products you want to include in your free-text search. 

10. If you select OWL Docs or Vault products, the Data Sources dropdown will become available. Pick the data sources you want to target. 

A screenshot of a computer

AI-generated content may be incorrect.

11. Select the views where you’d like your search results to appear on the results screen. 

12. Choose the compliance options required for your organization (e.g., Retention Policies, 28 CFR Part 23, Data Access Rights). 

A screenshot of a computer

AI-generated content may be incorrect.

13. From Case Management, select the Case and Subject to link your search to a specific investigation. If it’s not mandatory, you can also run the search without linking to a case/subject. These are referred to as orphan searches (see below).

A screenshot of a computer

AI-generated content may be incorrect.

14. Select the Retain the Search Compliance and Status checkbox to give more precedence to the search compliance over parent record compliances (Case/Subject). 

15. Once all selections are complete, click the Search button to start the free-text search in OWL. 

16. A loader will appear while the search runs. When it finishes, the matching information will automatically populate on the results screen. 

17. Keyword creation with operators: Supported and Unsupported keywords for free text search – 

• Jon (Supported) • “Jon Doe” (Supported) 

• Orange Theory + Austin 12, 2022 + Shooting in Austin (Supported) 

• Orange Theory AND Austin 12, 2022 AND shooting in Austin (Supported) 

• Orange Theory | Austin 12, 2022 | Shooting in Austin (Supported) 

• Orange Theory OR Austin 12, 2022 OR shooting in Austin (Supported) 

• Orange Theory OR Austin 12, 2022 AND shooting in Austin (Not Supported) 

• Orange Theory + Austin 12, 2022 | Shooting in Austin (Not Supported)

 

OWL Geospatial Searches

Geospatial search allows you to search OWL data based on location information. Instead of just looking for keywords or text, you can filter and find records tied to a specific place, region, or geographic boundary, Geospatial search in OWL supports the following features: 

• Location-based filtering: You can search by coordinates (latitude/longitude), addresses, or defined regions. 

 Map integration: Results can be displayed on a map view, making it easy to visualize where the data points are located. 

• Radius search: You can set a distance around a point (e.g., “within 5 miles of Austin”) to find relevant matches. (Under Development) • Polygon/shape search: Define custom boundaries (like a city block or district) and retrieve all data within that area. (Under Development) 

 

Steps to perform OWL Geospatial Search: 

1. Go to the Home Page. 

2. Click on “Query Data” located in the header. 

3. A menu will appear displaying all available search types. 

4. Click on the Geospatial option. 

5. You will be redirected to the Geospatial Search page. 

6. The geospatial search page will show the ESRI map view. 

A map of a green land

AI-generated content may be incorrect.

7. There are two ways to select an address on the Map. The first option is to enter the address in the Address Search field, and it will auto-suggest all the related addresses as per the address entered. 

8. You can also directly search address from the home page to directly access to geospatial search. 

A screenshot of a computer

AI-generated content may be incorrect.

9. Select any address that is suggested by the map. After selecting the address, click on the Search button. Now, the address will automatically be located on the map. 

A aerial view of a neighborhood

AI-generated content may be incorrect.

10. You can also enter the exact latitude and longitude of the location in the address search box. Click on Search. 

Ex: 33.208978, -87.494221 

11. A search result pop-up will appear on the screen, highlighting the exact location on the map. To zoom in on that location, click the Zoom To option in the pop-up. 

12. Click on a location on the map to select the exact address point. You can also choose nearby locations if needed. When you click anywhere on the map, that location or address will be selected, a red locator will appear to mark it, and all chosen addresses will be listed in the “Address Selected on Map” box. 

A aerial view of a neighborhood

AI-generated content may be incorrect.

13. To remove an address from the map, click the Delete button shown next to each selected address. 

14. After selecting all the addresses you need, click the Next button to move to the product selection page. 

15. On the next screen, all your selected addresses will be displayed. 

• To unselect an address, click the cross (×) icon beside it. 

• To add a new address, click the Back button to return to the geospatial map view, select the additional address, and then click Next again to continue. 

A screenshot of a computer

AI-generated content may be incorrect.

16. Choose the OWL products you want to include in your search. If you select Docs or Vault products, the Data Sources dropdown will appear—use it to pick the specific data sources you want to target 

17. From the View Options, select the views where you’d like your search results to be displayed. This ensures you only see results in the formats or layouts you prefer. 

18. Choose the compliance options required for your organization (e.g., Retention Policies, 28 CFR Part 23, Data Access Rights). 

A screenshot of a computer

AI-generated content may be incorrect.

19. From Case Management, select the Case and Subject to link your search to a specific investigation. If it’s not mandatory, you can also run the search without linking to a case/subject. These are referred to as orphan searches (see below).

A screenshot of a computer

AI-generated content may be incorrect.

20. Select the Retain the Search Compliance and Status checkbox to give more precedence to the search compliance over parent record compliances (Case/Subject). 

21. Once all selections are complete, click the Search button to start the Geospatial search in OWL. 

22. A loader will appear while the search runs. When it finishes, the matching information will automatically populate on the results screen.

 

Temporary or Orphan Data Query Searches

In OWL Intel, orphan searches refer to data query searches initiated without selecting a specific Case or Subject. These searches can only be accessed and launched from the Data Query Logs page within Case Management

A screenshot of a computer

AI-generated content may be incorrect.

To help users track and utilize these frequently performed standalone searches, OWL automatically assigns a temporary case number to each orphan search. This number is unique across the organization and cannot be manually reused as a standard case number. 

While orphan searches cannot be used to initiate new searches under the same temporary case, users can still perform spyglass searches within the context of that temporary case. 

 

Linking an Orphan Search to a record:

Orphan searches can be further linked to any existing Case or subject with the Attach Record option in the Data Query Logs page action menu. 

 

If you detach any Data Query Search from a case and subject, making it an orphan search, a temporary case number is automatically assigned to the orphaned search from OWL.