Skip to main content
Français Italiano Português

Targeting operators

This article describes targeting operators used for expert queries in the quick search field.

 

When doing a quick search:

  1. Click in the search field.
  2. Enter the letter S.
  3. Target fields are suggested.
  4. Click on the “Transaction status” target field.
  5. Immediately, the following list is suggested:
    • =
    • !=
    • IN
    • NOT IN

 

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:

magnify.png“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:

magnify.png“Transaction status” != Captured

Search all transactions that include neither the name Paul nor an email address starting with Paul:

magnify.png“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:

magnify.png“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:

magnify.png“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:

magnify.png“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:

magnify.png“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

magnify.png“Status after scoring” IN (“Accepted”, “Blocked”)

is the same as

magnify.png“Status after scoring” = “Accepted” OR “Status after scoring” = “Blocked”

Find all transactions carried out with VISA, Mastercard, American Express and iDEAL payment means:

magnify.png“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

magnify.png“Status after scoring” NOT IN (“Accepted”, “Blocked”)

is the same as

magnify.png“Status after scoring” != “Accepted” OR Status after scoring != “Blocked”

Find all transactions that are not from France, Belgium or Italy:

magnify.png“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:

Related articles