メイン コンテンツをスキップする

演算子

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

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

-

is on (day of the week) PublicationDate is on day of the week Friday

-

is on (day of the month) PublicationDate is on day of the month 16 -
Boolean is true Validity is true -
is false Validity is false -
is equal to Access is equal to Validity これらの演算子では、ブール値タイプの変数を2つ比較できます。
is not equal to Access is not equal to Validity

このページは役に立ちましたか?

このページまたはコンテンツにタイポ、ステップの省略、技術的エラーなどの問題が見つかった場合はお知らせください。