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

Compare with Current View Page History

« Previous Version 12 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 Column Type (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
is emptyISEMPTY
is not emptyISNOTEMPTY
is anythingANYTHING

Choice


User nameSystem name
ChangesVALCHANGES
Changes fromCHANGESFROM
Changes toCHANGESTO
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
ChangesVALCHANGES
Changes fromCHANGESFROM
Changes toCHANGESTO

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
ChangesVALCHANGES
Changes fromCHANGESFROM
Changes toCHANGESTO
ContainsLIKE
Does not containNOTLIKE
Is emptyISEMPTY
Is not emptyISNOTEMPTY
Is anythingANYTHING
Is empty stringEMPTYSTRING

Keywords

User nameSystem name
AreARE
ChangesVALCHANGES
Changes fromCHANGESFROM
Changes toCHANGESTO

Image


User nameSystem name
ChangesVALCHANGES
Changes fromCHANGESFROM
Changes toCHANGESTO
Is emptyISEMPTY
Is not emptyISNOTEMPTY


List


User nameSystem name
ChangesVALCHANGES
Changes fromCHANGESFROM
Changes toCHANGESTO
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
ChangesVALCHANGES
Changes fromCHANGESFROM
Changes toCHANGESTO
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
ChangesVALCHANGES
Changes fromCHANGESFROM
Changes toCHANGESTO
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

Record Class

User nameSystem name
Starts withSTARTSWITH
Ends withENDSWITH
ContainsLIKE
Does not containNOTLIKE
Is=
Is not!=
Is one ofIN

String


User nameSystem name
ChangesVALCHANGES
Changes fromCHANGESFROM
Changes toCHANGESTO
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