GenosDB - Query Playground

Graph Traversal ($edge)

All Employees of a Company Uses $edge to find Innovate Inc. and return all its Employee descendants.
All Active Developers Uses $edge to find all active developers across all companies.
Find by Hierarchy (Nested) Finds a Company, then finds a Developer descendant, then finds that Developer's descendant named "Bob".
Employees >= 38 in Data Corp Uses $edge to find employees in Data Corp who are 38 or older.
Employees with 'JavaScript' tag Uses $edge to find all employees who have "JavaScript" in their tags array.

Conditional Operators

$eq: Name is "Alice" Finds the employee with the exact name "Alice".
$gte: Age >= 35 Finds all employees aged 35 or older.
$between: Age between 30 and 40 Finds employees whose age is between 30 and 40.
$in: Level is 'Senior' or 'Lead' Finds employees who are either 'Senior' or 'Lead'.
$exists: Has an email address Finds all employees who have an email property.

Logical Operators

$and: Is a Developer AND from the USA Finds employees who are both developers and from the USA.
$or: Is Inactive OR older than 40 Finds employees who are inactive OR are older than 40.
$not: Country is NOT USA Finds all employees who are not from the USA.

Text Search Operators

$regex: Name starts with "B" Uses a regular expression to find names starting with 'B'.
$regex: Name contains "an" Finds names containing the substring "an".

Search using (NL Query Prompt)

Find by Hierarchy Finds a Company, then finds a Developer descendant, then finds that Developer's descendant named "Bob".
Company → descendant named Bob Company → descendant named "Bob" (sin especificar type/role).
Finds only Companies Finds all Companies.
finds descendant Developers finds descendant Developers.
Get posts order desc by id limit 3 Get posts order desc by id limit 3
Nested $edge with type + role + name Company → Employee(role=Developer) → descendant named Bob, ordered desc by id, limit 5.
$edge with unnamed type Company → descendant named Bob (sin especificar type/role).
$or + $and (roles OR) AND country role is Developer OR role is Designer, AND country is USA.
In-list: role in Developer, Designer role in Developer, Designer (usa $in).
Starts with + order asc + limit name starts with B, order asc by name, limit 10.
Between age 30–40 + sort/limit age between 30 and 40, order asc by age, limit 5.
$edge + includes Company → Employee with tags includes JavaScript.
Not equals country is not USA.
Equality in $edge: level Senior Company → Employee with level Senior.
Ends with + sort/limit name ends with "son", order asc by name, limit 5.
Like operator name like "J%".
Text search Full text search "Developer".
Text search (case-insensitive) Full text search "developer" (case-insensitive).
Text search (tags) Matches tags via $in when applicable.
Text search (unquoted single word) Same behavior as quoted when single-word term.
Between dates + sort/limit hireDate between 2020-01-01 and 2020-12-31, order asc by hireDate, limit 5.
List: first 2 employees by name order asc by name, limit 2.
List: last 5 employees by name order desc by name, limit 5.
Finds only Employees Find all Employees.

Ready