Versions Compared

Old Version 30

changes.mady.by.user Igor Shakhbazyan

Saved on

compared with

New Version 31

changes.mady.by.user Anna Kryzhanovskaya

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Note

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 nameOperator Display NameSystem name
Isis=
Is is not!=
Is is sameSAMEAS
Is is differentNSAMEAS
Is is emptyISEMPTY
Is is not emptyISNOTEMPTY
Is is anythingANYTHING
Is is (calculated)IS_CALCULATED


Tip

To use the IS_CALCULATED operator, you need to configure it as a column extra attribute first. This attribute allows to use scripts as a condition value.

Choice

User nameOperator Display NameSystem name
Isis=
Is is not!=
Is is one ofIN
Is is not one ofNOT IN
Containscontains

LIKE

Starts starts with
STARTSWITH
Ends ends withENDSWITH
Is is emptyISEMPTY
Is is not empty
ISNOTEMPTY
Less less than
<
Greater greater than
>
Less less than or is
 <=
Greater greater than or is>=
BetweenbetweenBETWEEN
Is is anythingANYTHING
Is is sameSAMEAS
Is is differentNSAMEAS
Is is (calculated)IS_CALCULATED

 

Datetime

User nameOperator Display NameSystem name
ChangeschangesVALCHANGES
Changes changes fromCHANGESFROM
Changes changes toCHANGESTO

Onon

ON
Not not onNOTON
Beforebefore<
Afterafter>
At at or before<=
At at or after>=
BetweenbetweenBETWEEN
Is is emptyISEMPTY
Is is not emptyISNOTEMPTY
Is is anythingANYTHING
Is is sameSAMEAS
Is is differentNSAMEAS
Is is (calculated)IS_CALCULATED


Fieldname

User nameOperator Display NameSystem name
Starts starts withSTARTSWITH
Ends ends withENDSWITH
ChangeschangesVALCHANGES
Changes changes fromCHANGESFROM
Changes changes toCHANGESTO
ContainscontainsLIKE
Does does not containNOTLIKE
Is is emptyISEMPTY
Is is not emptyISNOTEMPTY
Is is anythingANYTHING
Is is (calculated)IS_CALCULATED

Keywords

User nameOperator Display NameSystem name
AreareARE
ChangeschangesVALCHANGES
Changes changes fromCHANGESFROM
Changes changes toCHANGESTO
Is is (calculated)IS_CALCULATED

Image

User nameOperator Display NameSystem name
ChangeschangesVALCHANGES
Changes changes fromCHANGESFROM
Changes changes toCHANGESTO
Is is emptyISEMPTY
Is is not emptyISNOTEMPTY
Is is (calculated)IS_CALCULATED


List

User nameOperator Display NameSystem name
ChangeschangesVALCHANGES
Changes changes fromCHANGESFROM
Changes changes toCHANGESTO
HashasHAS
Has has notHASNOT
Is is emptyISEMPTY
Is is not emptyISNOTEMPTY
Isis=
Is is not!=
Is is one ofIN
Contains contains (dynamic)CONTAINS_DYNAMIC
Does does not contain (dynamic)DOESNOTCONTAIN_DYNAMIC
ContainscontainsLIKE
Is is (calculated)IS_CALCULATED


Big Integer, Decimal, Float, Integer, Numeric, Percent Complete, Percent Decimal, Small Integer

User nameOperator Display NameSystem name
ChangeschangesVALCHANGES
Changes changes fromCHANGESFROM
Changes changes toCHANGESTO
Isis=
Is is not!=
Is is one ofIN
Is is emptyISEMPTY
Is is not emptyISNOTEMPTY
Is is anythingANYTHING
Less less than<
Greater greater than>
Less less than or is<=
Greater greater than or is>=
BetweenbetweenBETWEEN
Is is sameSAMEAS
Is is differentNSAMEAS
Greater greater than fieldGT_FIELD
Less less than fieldLT_FIELD
Greater greater than or is fieldGT_OR_EQUALS_FIELD
Less less than or is fieldLT_OR_EQUALS_FIELD
Is is (calculated)IS_CALCULATED

Reference

User nameOperator Display NameSystem name
ChangeschangesVALCHANGES
Changes changes fromCHANGESFROM
Changes changes toCHANGESTO
Starts starts withSTARTSWITH
Ends ends withENDSWITH
ContainscontainsLIKE
Does does not containNOTLIKE
Isis=
Is is not!=
Is is one ofIN
Is is emptyISEMPTY
Is is not emptyISNOTEMPTY
Is is anythingANYTHING
Is is sameSAMEAS
Is is differentNSAMEAS
Is is (dynamic)DYNAMIC
Is is not (dynamic)

ISNOT_DYNAMIC

Is is (calculated)IS_CALCULATED

Record

Class field

Class

Operator Display NameUser nameSystem name
Starts starts withSTARTSWITH
Ends ends withENDSWITH
ContainscontainsLIKE
Does does not containNOTLIKE
Isis=
Is is not!=
Is is one ofIN
СhangeschangesVALCHANGES
Сhanges changes fromCHANGESFROM
Сhanges changes toCHANGESTO
Is is (calculated)IS_CALCULATED

Script

User nameOperator Display NameSystem name
СontainscontainsLIKE
Does does not containNOTLIKE
Is is not emptyISNOTEMPTY
Is is anythingANYTHING
ChangeschangesVALCHANGES
Changes changes fromCHANGESFROM
Changes changes toCHANGESTO
Is is (calculated)IS_CALCULATED

String, Text

User nameOperator Display NameSystem name
Starts starts withSTARTSWITH
Ends ends withENDSWITH
ContainscontainsLIKE
Does does not containNOTLIKE
Isis=
Is is not!=
Is is emptyISEMPTY
Is is not emptyISNOTEMPTY
Is is anythingANYTHING
Is is empty stringEMPTYSTRING
Is is sameSAMEAS
Is is differentNSAMEAS
Is is (calculated)IS_CALCULATED


Time

>
User nameOperator Display NameSystem name
ContainscontainsLIKE
OnonON
Not not onNOTON
Before<
After
At or before<=
At or after>=
BetweenBETWEEN
Is emptyISEMPTY
Is not emptyISNOTEMPTY
Is anythingANYTHING
Is sameSAMEAS
Is differentNSAMEAS
ChangesVALCHANGES
Changes fromCHANGESFROM
Changes toCHANGESTO
Is (calculated)IS_CALCULATED

Timestamp

at
User nameSystem nameContainsLIKEOnONNot onNOTONBefore<After>At
or before<=
At
at or after>=
Between
betweenBETWEEN
Is
is emptyISEMPTY
Is
is not emptyISNOTEMPTY
Is
is anythingANYTHING
Is
is sameSAMEAS
Is
is differentNSAMEAS
Changes
changesVALCHANGES
Changes
changes fromCHANGESFROM
Changes
changes toCHANGESTO
Is
is (calculated)IS_CALCULATED


Table of Contents
absoluteUrltrue
classfixedPosition