To conduct advanced queries in our system, you can construct logical expressions using different data fields and operators.
Here is a step-by-step guide to creating advanced queries.
Available data fields:
- firstname: First name of the individual
- lastname: Last name of the individual
- birthdate: Birthdate of the individual
- age: Age of the individual
- country: Country of residence of the individual (e.g., FR, DE)
- region: Region of residence of the individual
- department: Department of residence of the individual
- postalcode: Postal code of residence of the individual
- tags: Tags associated with the individual
- projects: Projects associated with the individual
- newsletters: Whether the individual accepts (true) or not (false) newsletters
- calls: Whether the individual accepts (true) or not (false) calls
- texts: Whether the individual accepts (true) or not (false) texts
- date: Registration date of the individual
- status: Status of the individual ("c" for contact, "m" for member, "u" for unsubscribed)
Available Operators:
- = : Equal to
- != : Not equal to
- > : Greater than
- < : Less than
- >= : Greater than or equal to
- <= : Less than or equal to
- and: Logical AND
- or: Logical OR
Syntax:
String values must be surrounded by quotes in queries, for example: firstname = "John"
Examples of queries:
1. To find all individuals named Titouan born before January 1, 1990:
firstname = "Titouan" and birthdate < "1990-01-01"
2. To find all individuals aged 18 or over and having contact status:
age >= 18 and status = "c"
3. To find all individuals with the tag "Elected" or "Young":
tags = "Elected" or tags = "Young"