2,155
edits
Changes
no edit summary
* '''Value type operand''': Are numeric values of the float type (Real numbers domain). These values allow the use of a integer and a fraction part, separated by the dot (.) character (decimal separator). '''Examples''': 1, 1.05, 2.55;
* '''Text type operand''': Are literal string data operands. These values allow the use of characters chain fields (strings), being delimited by the simple quote (') character. '''Examples''': 'John Snow', 'California', 'Spaghetti';
* '''Date type operand''': Are values that express any date. It is possible to determine a date representing it as a string, being delimited by the simple quote (') character and separated by the bar (/) character. The default supported format is "dd/MM/yyyy". '''Examples''': '01/01/2011', '29/02/2000';
* '''Boolean type operand''': Are values from the ''true'' or ''false'' kind. Usually used to validate or not a condition. '''Examples''': true e false;
* '''Identifier type operand''': Are values that represents a field or variable in the expression. Used to make reference to data source columns, delimited by double quotes ("). '''Examples''': "City.City", "Product.Product";
* '''System variable type operand''': Are system pre-defined variables. These values are replaced in run-time by pre-determined values, delimited by double quotes (") and preceded by star (#). By now only one variable is available: "#null" that indicates null values or fields.
The arithmetic expressions relate two operands (value or another expression) to compose a sum, subtraction, multiplication or division.
* '''Sum (+)''': Sum two operands. Represented by the sum (+) character. The expression syntax is Syntax: ''<operand/expression> + <operand/expression>''.
'''Examples''': "Taxes" + "Commissions";
* '''Subtraction (-)''': Subtract two operands. Represented by the subtract or hyphen (-) character. The expression syntax is Syntax: ''<operand/expression> - <operand/expression>''.
'''Examples''': "Gross Sale" - "Taxes";
* '''Multiplication (*)''': Multiplicate two operands. Represented by the multiplication or star (*) character. The expression syntax is Syntax: ''<operand/expression> * <operand/expression>''.
'''Examples''': "Amount" * "Unit Price";
* '''Division(/)''': Divides two operands. Represented by the divide or bar (/) character. The expression syntax is Syntax: ''<operand/expression> / <operand/expression>''.
'''Examples''': "Total Value" / "Amount".
The relational expressions compare two operands (value or another expression) two evaluate if a condition is ''true'' or ''false''. Usually used with decision functions, like the ''IF''.
* '''Equal (==)''': Performs the equal comparison expression between two operands. Represented by the equal operator (==). The expression syntax is Syntax: ''<expression> == <expression>''.
'''Examples''': "Unit Price" == "Total Price";
* '''Different (!=)''': Performs the different comparison expression between two operands. Represented by the different operator (!=). The expression syntax is Syntax: ''<expression> != <expression>''.
'''Examples''': "City.City" != 'New York';
* '''Greater than (>)''': Return ''true'' if the the first expression is greater than the second expression and ''false'' otherwise. Represented by the greater operator (>). The expression syntax is Syntax: ''<expression> > <expression>''.
'''Examples''': "Order Date" > '01/01/2011';
* '''Greater or equal than (>=)''': Return ''true'' if the the first expression is greater than or equal to the second expression and ''false'' otherwise. Represented by the greater or equal operator (>=). The expression syntax is Syntax: ''<expression> >= <expression>''.
'''Examples''': IF("Order Date" >= '01/01/2011';"Order Date";0);
* '''Lesser than (<)''': Return ''true'' if the the first expression is lesser than the second expression and ''false'' otherwise. Represented by the lesser operator (<). The expression syntax is Syntax: ''<expression> < <expression>''.
'''Examples''': "Profit" < '0';
* '''Lesser or equal than (<=)''': Return ''true'' if the the first expression is lesser than or equal to the second expression and ''false'' otherwise. Represented by the lesser or equal operator (<=). The expression syntax is Syntax: ''<expression> <= <expression>''.
'''Examples''': IF("Order Date" <= '01/01/2011';"Order Date";0).
