Base
Object
Object is the base type and all phrases defined for Object are applicable for every type unless otherwise specified.
<object> is <object>
Phrase type: boolean
This phrase checks the equality of two objects. It is similar to Java’s equals.
<object> is not <object>
Phrase type: boolean
This phrase checks the inequality of two objects.
<object> is present
Phrase type: boolean
This phrase checks the existence of an object. It is similar to Java’s nullness check.
<object> is not present
Phrase type: boolean
This phrase checks the non-existence of an object.
Boolean
<boolean> and <boolean>
Phrase type: boolean
This is the boolean logical operator to check if both of two boolean expressions are true. If both are true, the result will be true. Otherwise, the result is false.
It supports short circular evaluation.
<boolean> or <boolean>
Phrase type: boolean
Boolean logical operator used to check if any of two boolean expressions are true. If any one of the expressions is true, the returned result will be true.
It supports short circular evaluation.
Note
and has higher precedence than or when they are used in combination.
For example true or false and false
will be evaluated to true as it is equivalent to true or (false and false)
Proper use of parenthesis could make the phrase more understandable when there are multiple logical operators.
Number
Arithmatic Operators
Phrase type: number
The supported arithmetic operators are:
-
-
-
- /
Comparison Operators
Phrase type: number
The supported comparison operators are:
- is more than
- is less than
- is at least
- is at most
String
Note
All string comparison phrases are case sensitive.<string> is blank
Phrase type: boolean
Check the blankness of a string.
Note
The result will be true if the string is null or contains only spaces.<string> is not blank
Phrase type: boolean
Check the blankness of a string.
<string> + <string>
Phrase type: string
Concatenate a string with another string. Similar to the behavior of Java string.
<string> + <number>
Phrase type: string
Concatenate a string with a number. Similar to the behavior of Java string.
<string> contains <string>
Phrase type: boolean
Check if a string contains another string.
<string>does not contain <string>
Phrase type: boolean
Check if a string does not contain another string.
<string> starts with <string>
Phrase type: boolean
Check if a string starts with another string
<string> does not start with <string>
Phrase type: boolean
Check if a string does not start with another string
<string> ends with <string>
Phrase type: boolean
Check if a string ends with another string
<string> does not end with <string>
Phrase type: boolean
Check if a string does not end with another string
<string> is like <string>
Phrase type: boolean
Check if a string matches the specified sql LIKE pattern.
There are two wildcards used in the LIKE pattern:
-
% - the percent sign represents zero, one, or multiple characters
-
_ - the underscore represents a single character
They can be used in combinations.
<string> is not like <string>
Phrase type: boolean
Check if a string does not match the specified sql LIKE pattern.
<string> matches <string>
Phrase type: boolean
Check if a string matches the specified regular expression pattern.
<string> does not match <string>
Phrase type: boolean
Check if a string does not match the specified regular expression pattern.
Note
The regex pattern syntax can be found from: https://docs.oracle.com/javase/8/docs/api/java/util/regex/Pattern.htmlDate
today / tomorrow / yesterday
Phrase type: date
Predefined constants
<date> + <number> <TimeUnit>
Phrase type: date
Add a number of days/weeks/months to the supplied date
<date> - <number> <TimeUnit>
Phrase type: date
Subtract a number of days/weeks/months from the supplied date
<date> is before <date>
Phrase type: boolean
Check if a date is earlier than another date
<date> is after <date>
Phrase type: boolean
Check if a date is later than another date