Query Rules

Query Rules

GEODI queries help you find, filter, classify, and analyze content across all connected data sources.

You can start with a word or phrase—just like a web search—and then narrow the results using file properties, dates, recognized data, permissions, locations, and other conditions.

The query can be used across different GEODI DSPM capabilities:

  • Search: Find relevant information across documents, emails, databases, images, and other content.

  • Discovery: Identify sensitive, risky, duplicated, or misplaced data.

  • Classification: Automatically classify content that matches defined conditions.

  • Data Analysis: Filter dashboards and reports to analyze a specific part of your data.

  • Workflows: Apply actions such as classification, masking, quarantine, or secure deletion to matching content.

  • Alarms: Receive notifications when matching content is discovered or changed.

 

Basic Search Rules

GEODI searches all content across the data sources connected to your project unless you narrow the scope.

  • In GEODI, content refers to any searchable item, such as a file, email, social media post, or database row.

  • Search is case-insensitive, so Georgia and GEORGIA return the same results.

  • By default, multiple search terms are combined with AND. Therefore, you do not normally need to write AND.

What do you want to find?

Query

Result

What do you want to find?

Query

Result

A word

Georgia

Contains Georgia

Multiple words

Georgia Aquarium

Contains both words, not necessarily together. Georgia Aquarium and Georgia AND Aquarium are equivalent. Writing AND explicitly is optional but can make complex queries easier to read.

An exact phrase

"Georgia Aquarium"

Contains the complete phrase

Either condition

Georgia OR Florida

Contains Georgia, Florida, or both

Grouped alternatives

(Georgia OR Florida) Aquarium

Contains Aquarium and either Georgia or Florida. Use parentheses when combining alternatives with other conditions:

A word beginning with specific characters

Georg*

Matches words such as Georgia or George

A word ending with specific characters

*city

Matches words ending in city

Exclude a word

Georgia -Aquarium

Contains Georgia but not Aquarium

A word with uncertain spelling

Berlon~

Finds similar words, such as Berlin

 


Predefined Queries

GEODI provides ready-to-use queries for common DSPM and discovery scenarios. These queries enable you to perform complex searches without having to understand all the underlying rules.

Predefined queries follow the same rules described in Basic Search. You can combine them with words, phrases, other predefined queries, AND, OR, parentheses, and - for exclusion.

Query

Finds

Query

Finds

predefined:PII

Personally identifiable information

predefined:PCI

Payment card information

predefined:CV

CVs and résumés

predefined:Fraud

Content associated with potential fraud indicators

predefined:O10Y

Content older than ten years

predefined:PII customer

PII in content containing customer

predefined:Fraud (invoice OR payment)

Potential fraud indicators in invoices or payment-related content

predefined:PII predefined:O5Y

PII in content older than five years

predefined:PII -predefined:CV

PII excluding CVs and résumés

Query

Purpose

Query

Purpose

predefined:Money

Recognizes multiple currencies ($, €, £, SAR, etc.)

predefined:CreditCard

Covers over 10 CC types and test cards

predefined:DB

Brings DB files like SQL Server, Oracle, SQLite, MDB

predefined:Videos

Finds video files

predefined:Images

Finds image files

predefined:Web

Web content, including email

predefined:Maskcontent

Maskable content

predefined:Local

Local-only content

predefined:GDE

GDE-fed content

predefined:PII

PII-related content, adaptable to local rules

predefined:scpd_religion

Religion

predefined:scpd_race

Ethnicity

predefined:scpd_MaritalStatus

Marital status

predefined:scpd_health

Health-related terms

predefined:scpd_unions

Unions

predefined:scpd_PoliticalOpinion

Political views

predefined:scpd_foundations

Foundations

predefined:CV

CV-related documents

predefined:AbleToClassifyByLabel

Classifiable by tag

predefined:AbleToClassifyByADS

Classifiable by ADS rules

predefined:SourceCode

Source code files

 

Search Scopes and Fields

Unless you specify a section, GEODI searches across all available sections of the content. Use a prefix to limit the search to a particular section or property. When a value contains spaces or multiple conditions, enclose it in parentheses.

Query prefix

Searches in

Example

Result

Query prefix

Searches in

Example

Result

header:

Content metadata, including document metadata and email subjects

header:(Georgia Aquarium)

Limits both words to the header. If you do not use parentheses, as in header:Georgia Aquarium, only Georgia is limited to the header.

body:

Main document text or email message body

body:(Georgia Aquarium)

Main content containing both Georgia and Aquarium

doc:

Document name or type; a specialized subset of header:

doc:*.pdf predefined:PII

PDF documents or content whose name begins with Georgia

from: / to:

Email sender or recipient

from:(*@georgia.com)

Emails sent from the georgia.com domain

owner:

Content owner

owner:me or owner:<user>

Content owned by the active user or specified user

source:

Connected data source

source:(OurFileserver)

OR

source:(OracleDB)

Content discovered from the source

fieldname:<criteria>

Searches in the given fieldname(s).

name:(john doe)

creation_date:(May 1999)

It should be enabled for Structured sources.

GDE(feed) sources also provides extra fields to search.

Content type

Query

Description

Content type

Query

Description

Files

doc:*.pdf, doc:*.docx, doc:*.xlsx, doc:*.pptx

Selects files by extension. Any supported file extension can be used.

Emails and web pages

doc:*.html

Email messages and indexed web pages

GEODI notes

doc:*.geodinote

Notes created in GEODI

Database rows

doc:geodi_row

Individual rows retrieved from a database

Database tables

doc:geodi_table

Database tables indexed by GEODI

 


 

 

 

 

 

 

Sample Queries

We suggest you to try the following samples with your content. You will see how easy and effective to find content in’s no problem.

Jan-March 2017 doc:*.PDF Georgia

If the document came via email, the rule remains the same. We specify the PDF just as we specify the email, as both are content types for GEODI.

content:e-Mail Georgia

We know that it was in a ZIP file. The document name was something “Geological..” and contains the the word wall.

parent:*.ZIP doc:Geological* Wall

You looked at hundreds of resumes during an HR process and made notes indicating your opinions. Now you want to find the resumes that received positive notes.
child:(.geodinote “let’s interview”)
child:(.geodinote “not suitable”)

Search for Georgia but not auarium.

Georgia -Aqua*

When you want to search a word and sinonims at the same time you may simply define a GEODI dictionary. The following queries may be identical using a single line dictionary:

Artifical Intelligence

AI

Expert System

Using just words in long documents may be misleading. Lets assume , a 10 page document first word in the first page, second word is in the last page. To prevent this situation you may use proximity rule that is ().

Education() “High School”

find High School within 10 words of education. Try removing () and see the result.

Education “High School”

100..500GBP

Words can be found close to currency expressions that fit the range.