You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

On this page, operators separated by type of condition are listed.

Please pay attention that these are condition types, not the system types listed in the sys_db_column_type table.

In the first column, the user operator name is specified.

In the second column, the system operator name is specified, which is usable in condition strings.

Boolean

User nameSystem name
Is=
Is not!=
Is sameSAMEAS
Is differentNSAMEAS

Choice

User nameSystem name
Is=
Is not!=
Is one ofIN
Is not one ofNOT IN
Is emptyISEMPTY
Is not emptyISNOTEMPTY
Less than<
Greater than>
Less than or is<=
Greater than or is>=
BetweenBETWEEN
Is anythingANYTHING
Is sameSAMEAS
Is differentNSAMEAS
ContainsLIKE

 

Datetime

User nameSystem name

On

ON
Not onNOTON
Before<
After>
At or before<=
At or after>=
BetweenBETWEEN
Is emptyISEMPTY
Is not emptyISNOTEMPTY
Is anythingANYTHING
Is sameSAMEAS
Is differentNSAMEAS


Fieldname

User nameSystem name
Starts withSTARTSWITH
Ends withENDSWITH
ContainsLIKE
Does not containNOTLIKE
Is emptyISEMPTY
Is not emptyISNOTEMPTY
Is anythingANYTHING
Is empty stringEMPTYSTRING


Image

User nameSystem name
Is emptyISEMPTY
Is not emptyISNOTEMPTY


List

User nameSystem name
HasHAS
Has notHASNOT
Is emptyISEMPTY
Is not emptyISNOTEMPTY
Is=
Is not!=
Contains (dynamic)CONTAINS_DYNAMIC
Does not contain (dynamic)DOESNOTCONTAIN_DYNAMIC


Numeric

User nameSystem name
Is=
Is not!=
is one ofIN
Is emptyISEMPTY
Is not emptyISNOTEMPTY
Is anythingANYTHING
Less than<
Greater than>
Less than or is<=
Greater than or is>=
BetweenBETWEEN
Is sameSAMEAS
Is differentNSAMEAS
Greater than fieldGT_FIELD
Less than fieldLT_FIELD
Greater than or is fieldGT_OR_EQUALS_FIELD
Less than or is fieldLT_OR_EQUALS_FIELD

Reference


User nameSystem name
Starts withSTARTSWITH
Ends withENDSWITH
ContainsLIKE
Does not containNOTLIKE
Is=
Is not!=
Is one ofIN
Is emptyISEMPTY
Is not emptyISNOTEMPTY
Is anythingANYTHING
Is sameSAMEAS
Is differentNSAMEAS
Is (dynamic)DYNAMIC

 

String

User nameSystem name
Starts withSTARTSWITH
Ends withENDSWITH
ContainsLIKE
Does not containNOTLIKE
Is=
Is not!=
Is one ofIN
Is emptyISEMPTY
Is not emptyISNOTEMPTY
Is anythingANYTHING
Is empty stringEMPTYSTRING
Less than or is<=
Greater than or is>=
BetweenBETWEEN
Is sameSAMEAS
Is differentNSAMEAS

  • No labels