V6.1

Statements

With analytical expressions, you can query and return the data defined by a table expression. Before learning about queries, it is important for you to have a solid understanding of Wyn analytical expression basics.

Syntax

EVALUATE <table> 
[ORDER BY {<expression> [{ASC | DESC}]}[, …]

Following is the list of statements supported in Wyn Enterprise.

EVALUATE(Required)

At the most basic level, an analytic expression query is an EVALUATE statement containing a table expression.

Syntax

EVALUATE <table>

Arguments

Term	Definition
table	A table or a function that return value is a table.

Examples

EVALUATE 'Product'

This will return all rows and columns from the Product table, as a table.

ORDER BY (optional)

The optional ORDER BY keyword defines one or more expressions used to sort query results. Any expression that can be evaluated for each row of the result is valid.

Syntax

EVALUATE <table> 
[ORDER BY {<expression> [{ASC | DESC}]}[, …]

Arguments

Argument	Description
expression	Any expression that returns a single scalar value.
ASC	Sorts in ascending order. This is the default sort order.
DESC	Sorts in descending order.

Example

EVALUATE
    'Product'
ORDER BY
    'Product'[Product Name]

Returns all rows and columns from the Product table, ordered by Product Name, as a table.