Operators Supported for Defining Rules

This section provides a list of operators that are supported for defining rules.

This table displays list of operators supported when defining conditions.

Operator	Supported Data Types	Combination with NOT Operator
No Operator	STRING / NUMBER / DATE / BOOLEAN	No
IN	STRING / NUMBER	Yes
BETWEEN	NUMBER / DATE	Yes
STARTS WITH	STRING	Yes
ENDS WITH	STRING	Yes
CONTAINS	STRING	Yes
MATCHES	STRING (also supports regular expressions)	Yes
MORE THAN EQUAL TO / >=	NUMBER	No
LESS THAN EQUAL TO / <=	NUMBER	No
MORE THAN / >	NUMBER	No
LESS THAN / <	NUMBER	No
NOT	STRING / NUMBER / DATE / BOOLEAN	No
EQUALS IGNORE CASE	STRING	Yes
ON OR BEFORE	DATE	No
ON OR AFTER	DATE	No
BEFORE	DATE	No
AFTER	DATE	No
Exists / Not Exists	All nullable attributes

Note that only round brackets () are to be used and only when set values are being specified and that the supported date format is DD-MON-YYYY OR DD/MON/YYYY.

This table lists operators and their usage.

Operator	Supported Data Types	Forms	Comments	Example
No Operator	STRING / NUMBER / DATE / BOOLEAN	<value>	If no operator is specified, it will be treated as equal to (IS operator).	Seeded, Standard
IN	STRING / NUMBER	in (<value1> , <value2>...)	At least two values required.	in (100,200,300 )/ not in (100,200,300 ) in (Tax, Hold, Standard ) / not in (Tax, Hold, Standard )
BETWEEN	NUMBER / DATE	between <value1> AND <value2>	Case insensitive static string (between, and).	between 1000 and 2000 / Not between 1000 and 2000
		<value1> TO <value2>	Both values inclusive	1000 to 2000 / Not 1000 to 2000 between 1/nov/2018 and 1/dec/2018 / Not between 1/nov/2018 and 1/dec/2018 1/jan/2018 and 31/jan/2018 / Not 1/jan/2018 and 31/jan/2018
STARTS WITH	STRING	starts with <value>	Case insensitive static string (starts with, startswith).	starts with Text / Not starts with Text
		startswith <value>		startswith Standard / Not startswith Standard
ENDS WITH	STRING	ends with <value>	Case insensitive static string (ends with, endwith).	ends with Manager / Not ends with Manager
		endswith <value>		endswith Approval / Not endswith Approval
CONTAINS	STRING	contains <value>	Case insensitive static string (contains).	contains invoice / Not contains invoice
MATCHES	STRING (also supports regular expressions)	matches <value>	Case insensitive static string (matches).	matches Seeded\\s(.*)Configuration
				Not matches Seeded\\s(.*)Configuration
				It matches strings Starts with Seeded and ends with configuration. In between there can be one space and any character.
				(.*) - zero or more character
				(.+) - one or more character
				\\s - denotes space
				\\d - digit 0-9
				? - to make a char optional ex - \\d?
				[ ] - to give range like a-z, A-Z, 0-9
				refer java regex support for more.
MORE THAN EQUAL TO / >=	NUMBER	more than equal to <num>	Case insensitive static string (more than equal to).	more than equal to 1000
		>= num		>= 1000
LESS THAN EQUAL TO / <=	NUMBER	less than equal to <num>	Case insensitive static string (less than equal to).	less than equal to 2000
		<= <num>		<= 2000
MORE THAN / >	NUMBER	more than <num>	Case insensitive static string (more than).	more than 10000
		> <num>		>10000
LESS THAN / <	NUMBER	less than <num>	Case insensitive static string (less than).	less than 50000
		< <num>		< 50000
NOT	STRING / NUMBER / DATE / BOOLEAN	Not <value>	Case insensitive static string (not).	not Seeded
EQUALS IGNORE CASE	STRING	equals ignore case <value>	Case insensitive static string (equal ignore case, equalsignorecase).	not 1000
				not 01/jan/2018
				not true
				equalsignorecase withholding tax / Not equalsignorecase withholding tax
ON OR BEFORE	DATE	on or before <value>	Case insensitive static string (on or before).	equals ignore case withholding tax / Not equals ignore case withholding tax
				on or before 1/Dec/2018
ON OR AFTER	DATE	ON or BEFORE	Case insensitive static string (on or after).	on or after 1/Jan/2018
		on OR before
		On Or Before
		on or after <value>
BEFORE	DATE	before <value>	Case insensitive static string (before).	before 1/Nov/2018
AFTER	DATE	after <value>	Case insensitive static string (after).	after 1/Nov/2018