This article describes targeting operators used for expert queries in the quick search field.
When doing a quick search:
- Click in the search field.
- Enter the letter S.
- Target fields are suggested.
- Click on the “Transaction status” target field.
- Immediately, the following list is suggested:
Equal to: =
The value of the specified field corresponds exactly to the specified value.
PLEASE NOTE
- By using wildcard characters (? or *), the “accurate” criterion of the search is bypassed.
- The search is only carried out on integers for numerical values. It is impossible to launch a search on a value with decimal places.
|
Example
Search all captured transactions:
“Transaction status” = Captured
|
Different from: !=
The value of the specified field does not correspond to the specified value.
Example
Search all transactions without the “Captured” status:
“Transaction status” != Captured
|
Search all transactions that include neither the name Paul nor an email address starting with Paul:
“Customer name” != Paul OR “Customer email” != Paul*
|
PLEASE NOTE
- The search is only carried out on integers for numerical values. It is impossible to launch a search on a value with decimal places.
|
Higher than: >
The value of the specified field is higher than the specified value.
PLEASE NOTE
- The “>” targeting operator can only be used with date or numerical fields. It cannot be used with text type fields.
- The search is only carried out on integers. It is impossible to launch a search on a value with decimal places.
|
Example
Find all scoring results higher than €100:
“Scoring result” > 100
|
Higher than or equal to: >=
The value of the specified field is higher than or equal to the specified value.
PLEASE NOTE
- The “>=” targeting operator can only be used with date or numerical fields. It cannot be used with text type fields.
- The search is only carried out on integers. It is impossible to launch a search on a value with decimal places.
|
Example
Find all transactions with a scoring result higher than or equal to 1,000:
“Scoring result” >= 1000
|
Lower than: <
The value of the specified field is lower than the specified value.
PLEASE NOTE
- The “<” targeting operator can only be used with date or numerical fields. It cannot be used with text type fields.
- The search is only carried out on integers. It is impossible to launch a search on a value with decimal places.
|
Example
Find all transactions with less than 5 different items in the basket:
“Number of different items” < 5
|
Lower than or equal to: <=
The value of the specified field is lower than or equal to the specified value.
PLEASE NOTE
- The “<=” targeting operator can only be used with date or numerical fields. It cannot be used with text type fields.
- The search is only carried out on integers. It is impossible to launch a search on a value with decimal places.
|
Example
Find all transactions created over the past 5 days:
“Transaction creation date” <= 2021-03-19
|
IN
The value of the specified field is one of the specified values. Values are specified as a list delimited by commas, between brackets.
Using “IN” is the same as using multiple Equal to (=) operators, but it is shorter and more convenient.
Example
“Status after scoring” IN (“Accepted”, “Blocked”)
|
is the same as
“Status after scoring” = “Accepted” OR “Status after scoring” = “Blocked”
|
Find all transactions carried out with VISA, Mastercard, American Express and iDEAL payment means:
“Payment means” IN (“VISA”, “Mastercard”, “American Express”, “iDEAL”)
|
PLEASE NOTE
- It is possible to copy-paste a list of exact values between brackets (this does not work if you use search assistance such as ? and *).
- Select the values of a column in an Excel file (for example).
- Copy.
- Enter a target field, then the IN operator.
- Put an opening bracket.
- Paste.
- Put a closing bracket.
- Press ENTER.
- The system automatically handles commas and quotation marks.
- The system handles operators in both English and French. If you type DANS, the system will process it as IN.
|
NOT IN
The value of the specified field is not part of the list of specified values.
Using “NOT IN” is the same as using multiple Different from (!=) operators, but it is shorter and more convenient.
Example
“Status after scoring” NOT IN (“Accepted”, “Blocked”)
|
is the same as
“Status after scoring” != “Accepted” OR Status after scoring != “Blocked”
|
Find all transactions that are not from France, Belgium or Italy:
“Payment card country” NOT IN (“France”, “Belgium”, “Italy”)
|
PLEASE NOTE
- It is possible to copy-paste a list of exact values between brackets (this does not work if you use search assistance such as ? and *).
- Select the values of a column in an Excel file (for example).
- Copy.
- Enter a target field, then the NOT IN operator.
- Put an opening bracket.
- Paste.
- Put a closing bracket.
- Press ENTER.
- The system automatically handles commas and quotation marks.
- The system handles operators in both English and French. If you type PAS DANS, the system will process it as NOT IN.
|
Related articles:
Comments
0 comments
Article is closed for comments.