# 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.<br><br>Les formats supportés sont :<br><br><ul> <li>yyyy-mm-dd (aaaa-mm-jj),</li> <li>hh:mm:ss,</li> <li>yyyy-mm-dd hh:mm:ss (aaaa-mm-jj hh:mm:ss).</li> </ul> |
| 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 |  |  |