# 演算子

利用対象...

* Cloud API Services Platform
* Cloud Big Data
* Cloud Big Data Platform
* Cloud Data Fabric
* Cloud Data Integration
* Cloud Data Management Platform
* Cloud Pipeline Designer Standard Edition
* Data Fabric

以下のテーブルにより、基本モードで使用できる演算子がリスト表示されます。

演算子と例のリスト演算子と例のリスト

| 演算子名 | 演算子タイプ | 例 | 詳細 |
| --- | --- | --- | --- |
| is | Text | CustomerName is Smith | 該当せず |
| is not | Text | FirstName is not John | 該当せず |
| contains | Text | StatusCode contains 0AZ | 該当せず |
| does not contain | Text | ItemID does not contain X32 | 該当せず |
| starts with | Text | BankNumber starts with FR | 該当せず |
| does not start with | Text | ItemID does not start with DE123 | 該当せず |
| ends with | Text | BankNumber ends with 0089 | 該当せず |
| does not end with | Text | BankNumber does not end with Y9 | 該当せず |
| matches regex | Text | PostalCode matches regex ^[0-9]{5}(-[0-9]{4})?$ | 該当せず |
| does not match regex | Text | SSN does not match regex ^\\d{3}-\\d{2}-\\d{4}$ | 該当せず |
| is of type | Text | Location is of type Asia | セマンティックタイプまたは標準タイプ: ブール値、日付、小数点、整数のいずれか |
| is empty | Text | DriverLicense is empty | 該当せず |
| is equal to | Number | Age is equal to 21 | 該当せず |
| is not equal to | Number | CustomerID is not equal to 16742 | 該当せず |
| is greater than | Number | Age is greater than 17 | 該当せず |
| is greater than or equal to | Number | Age is greater than or equal to 21 | 該当せず |
| is less than | Number | Age is less than 16 | 該当せず |
| is less than or equal to | Number | Age is less than or equal to 20 | 該当せず |
| is equal to | Date and time | DateOfReceipt is equal to 2020-05-14 09:55:00 | 日付、時刻、その両方のいずれかを選択できます。<br><br>サポートされている形式は以下のとおりです。<br><br><ul> <li>yyyy-mm-dd</li> <li>hh:mm:ss</li> <li>yyyy-mm-dd hh:mm:ss</li> </ul> |
| is not equal to | Date and time | ValidationDate is not equal to 2020-09-02 |  |
| is before | Date and time | BirthDate is before 2003-12-16 |  |
| is before or equal to | Date and time | ExpiryDate is before or equal to 2002-01-01 |  |
| is after | Date and time | BirthDate is after 1983-12-31 |  |
| is after or equal to | Date and time | BirthDate is after or equal to 1971-01-01 |  |
| is in (month) | Date and time | HireDate is in month March | 該当せず |
| is on (day of the week) | Date and time | PublicationDate is on day of the week Friday | 該当せず |
| is on (day of the month) | Date and time | PublicationDate is on day of the month 16 | 該当せず |
| is true | Boolean | Validity is true | 該当せず |
| is false | Boolean | Validity is false | 該当せず |
| is equal to | Boolean | Access is equal to Validity | これらの演算子では、ブール値タイプの変数を2つ比較できます。 |
| is not equal to | Boolean | Access is not equal to Validity |  |