Introduction
When creating targets in S-360 SAM module you have access to what is called the "SECUTIX Query Engine".
These are the main areas and functions of the engine:
- Query starting condition
- Add filter / sub-query
- List of available filters and examples
- List of selected filters and conditions
- Disable/remove filters
- Search and results
1. Query starting condition
The engine allows you to build a query as naturally as you construct a sentence. The standard start of the sentence is always set as: "Select records for which all conditions below apply."
You can however choose between 4 different possibilities depending on what you want to do:
- all ( + / and ): allows you to add contacts to the list and to link the conditions with an and
- none (- / and): allows you to exclude contacts from the list and to link the conditions with an and
- at least one (+ / or): allows you to add contacts to the list and link the conditions with one or
- at least not one ( - / or): allows you to exclude contacts from the list and to link the conditions with one or
2. Add filter / sub-query
These two buttons allow you to:
- Add a new conditions / sub-conditions → it will open the list of filters (see §3)
- Add a nested query → this is an advanced setting, see the section below if you already know who to create and use standard queries/filters.
3. List of available filters and examples
Please remember that SAM will always target cultural contacts (so including also those who have tickets/items that might have been bought/paid by someone else).
Important
As a general rule it is not possible to use the same filter twice in the same query with different value. The result is always zero.
According to your needs you may instead use:
- a sub-query (those who have tickets sold for both Don Giovanni and La Traviata): see nested query above.
- operator inList (those who have tickets sold for Don Giovanni or La Traviata)
Here you find the filters among which you may choose. Click on them for a quick explanation and an example.
4. List of selected filters
This is where you will be able to define the conditions of your request. As seen above the button allows you to add a new condition.
When selected, each filter comes with its own set of operators (usually but not always including equal, notEqual, inList etc) and values to define the condition to be applied.
5. Disable/remove filter
These buttons will be displayed for each filter row and allow you to
- Disable a condition temporarily →
- Delete a condition
6. Search and results
A simple click on "search" allows you to see the volume of contacts meeting the defined conditions. Please note you'll see on screen only the first 100 contacts.
You can click on contacts to access their files if needed..
After the target is saved and closed you can open it again to have access to export options: