Load Filter Syntax

This page describes the supported syntax in the load filter.

Operators Table

Operator Description Example
<COL_NAME> = <VALUE> This operator returns the rows where the data is equal to a certain value. Note that this operator would not work properly with values of type “double”. For example, if you would like to load the rows where the revenue is 1160.20, which is of type double, it would be impossible to know the exact double value to be matched. User = 1 FirstName = "John" Hire_Date = DATE("03/03/2003")
<COL_NAME> != <VALUE> This operator returns the rows where the data is not equal to a certain value. User != 1 FirstName != "John" Hire_Date != DATE("03/03/2003")
<COL_NAME> < <VALUE> This operator returns the rows where the data is less than a certain value. User < 1 FirstName < "John" Hire_Date < DATE("03/03/2003")
<COL_NAME> > <VALUE> This operator returns the rows where the data is greater than a certain value. User > 1 FirstName > "John" Hire_Date > DATE("03/03/2003")
<COL_NAME> >= <VALUE> This operator returns the rows where the data is greater than or equal to a certain value. User >= 1 FirstName >= "John" Hire_Date >= DATE("03/03/2003")
<COL_NAME> <= <VALUE> This operator returns the rows where the data is less than or equal to a certain value. User <= 1 FirstName <= "John" Hire_Date <= DATE("03/03/2003")
(<COL_NAME1> + <COL_NAME2>) > <VALUE> This operator adds the value of one column to that of another column. Note that the end result of the filter formula should be boolean (i.e. true/ false). This means you would need to compare the addition result to a value. (AMOUNT_SOLD + COST_OF_GOODS) >1160.20
(<COL_NAME1> - <COL_NAME2>) > <VALUE> This operator subtracts the value of one column from that of another column. Note that the end result of the filter formula should be boolean (i.e. true/ false). This means you would need to compare the addition result to a value. (AMOUNT_SOLD - COST_OF_GOODS) >1160.20
(<COL_NAME1> * <COL_NAME2>) > <VALUE> This operator multiplies the value of one column by that of another column. Note that the end result of the filter formula should be boolean (i.e. true/ false). This means you would need to compare the addition result to a value. (AMOUNT_SOLD * COST_OF_GOODS) >1160.20
(<COL_NAME1> / <COL_NAME2>) > <VALUE> This operator divides the value of one column by that of another column. Note that the end result of the filter formula should be boolean (i.e. true/ false). This means you would need to compare the addition result to a value. (AMOUNT_SOLD / COST_OF_GOODS) >1160.20

Functions Table

Function Description Example
For two expressions: AND(<EXP1>, <EXP2>) For more than two expressions, use the nested form: AND(<EXP1>, AND(<EXP2>, AND(<EXP3>, <EXP4>))) This boolean function takes one (or multiple) boolean expressions and returns “true” if all are satisfied, otherwise it returns “false”.
For two expressions: OR(<EXP1>, <EXP2>) For more than two expressions, use the nested form: OR(<EXP1>, OR(<EXP2>, OR(<EXP3>, <EXP4>))) This boolean function takes one (or multiple) boolean expressions and returns “true” if one (or all) is satisfied, otherwise it returns “false”. OR(User>5, User<13) OR(FirstName = "John", FirstName != "Erick") OR(Hire_Date <= DATE("01/01/2000"), Hire_Date = DATE("08/08/2008"))
daysBetween (<DATE_VARIABLE>, <DATE_COLUMN>) <OPERATOR> <VALUE> Returns the data of the days between the date variable and a date column, where the date variable must be greater than the latter. daysBetween( $currentDate, Time_ID) < 2500 The supported date variables are: $currentDate, $currentYear, and $currentMonth.
date(string expression) Converts a string to a date using the “en-US” locale and the format mask “yyyy-MM-dd”.
date ("2001-12-24 23:55:12.000") This function converts the string date representation a value of date type.

Date Variables Table

Operator Description Example
currentDate Date The current date of the Incorta Server time.
currentMonth Integer The month of the current Incorta Server time.
currentYear Integer The year of the current Incorta Server time.

© Incorta, Inc. All Rights Reserved.