Opérateurs
Le tableau suivant liste les opérateurs disponibles en mode simple.
| Operator (Opérateur) | Exemple | Détails | |
|---|---|---|---|
| Type | Name (Nom) | ||
| Text | IS | CustomerName is (est) Smith | - |
| is not (n'est pas) | FirstName is not (n'est pas) John | - | |
| contient | StatusCode contains (contient) 0AZ | - | |
| does not contain (ne contient pas) | ItemID does not contain (ne contient pas) X32 | - | |
| commence par | BankNumber starts with (commence par) FR | - | |
| does not start with (ne commence pas par) | ItemID does not start with (ne commence pas par) DE123 | - | |
| ends with (termine par) | BankNumber ends with (termine par) 0089 | - | |
| does not end with (ne termine pas par) | BankNumber does not end with (ne termine pas par) Y9 | - | |
| matches regex (correspond à la regex) | PostalCode matches regex (correspond à la regex) ^[0-9]{5}(-[0-9]{4})?$ | - | |
| does not match regex (ne correspond pas à la regex) | SSN does not match regex (ne correspond pas à la regex) ^\\d{3}-\\d{2}-\\d{4}$ | - | |
| is of type (est de type) | Location is of type (est de type) Asia | Saisissez un type sémantique ou un type standard : boolean (booléen), date, decimal (décimal) ou integer (entier). | |
| is empty | DriverLicense is empty (est vide) | - | |
| Number | is equal to | Age is equal to (est égal à) 21 | - |
| is not equal to | CustomerID is not equal to (n'est pas égal à) 16742 | - | |
| is greater than | Age is greater than (est supérieur à) 17 | - | |
| greater than or equal to (est supérieur ou égal à) | Age is greater than or equal to (est supérieur ou égal à) 21 | - | |
| is less than (est inférieur à) | Age is less than (est inférieur à) 16 | - | |
| is less than or equal to (est inférieur ou égal à) | Age is less than or equal to (est inférieur ou égal à) 20 | - | |
| Date et heure | is equal to | DateOfReceipt is equal to (est égal à) 2020-05-14 09:55:00 | Vous pouvez sélectionner une date, une heure ou les deux. Les formats supportés sont :
|
| is not equal to | ValidationDate is not equal to (n'est pas égal à) 2020-09-02 | ||
| is before | BirthDate is before (est antérieure à) 2003-12-16 | ||
| is before or equal to (est antérieure ou égale à) | ExpiryDate is before or equal to (est antérieure ou égale à) 2002-01-01 | ||
| is after | BirthDate is after (est postérieure à) 1983-12-31 | ||
| is after or equal to (est postérieure ou égale à) | BirthDate is after or equal to (est postérieure ou égale à) 1971-01-01 | ||
| is in (month) (est en (mois)) | HireDate is in month (est en) March |
- |
|
| is on (day of the week) (est le (jour de la semaine)) | PublicationDate is on day of the week (est le) Friday |
- |
|
| is on (day of the month) (est le (jour du mois)) | PublicationDate is on day of the month (est le) 16 | - | |
| Booléen | is true (est vrai) | Validity is true (est vrai) | - |
| is false (est faux) | Validity is false (est faux) | - | |
| is equal to | Access is equal to (est égal à) Validity | Ces opérateurs vous permettent de comparer deux variables de type booléen. | |
| is not equal to | Access is not equal to (n'est pas égal à) Validity | ||