Assertion

Type

Double

Since

1.2

Description

With the "Assertion" property, you can implement a traffic-light analysis inside your queries. The assertion-property holds a Doubleexpression which result sets the assertion for each individual cell inside a query (the assertion-expression will be evaluated for each individual cell and might result to different assertions for each cell). Depending on the result a different color is applied to the cell-background:

value <= -1: The assertion generates red cells
-1 < value < 0: The assertion generates yellow cells
value = 0: The assertion generates un-asserted cells
0 < value: The assertion generates green cells
value = NULL: The assertion generates un-asserted cells

The assertion-property is not only used for the visualization of queries but also for some automation-task. E.g. you may want only to send emails with query-result when some exception occurs in you query. Then you can set some assertions in your query and use them in the automation.

Examples

Assertion = "-1"

Generates red assertions

Assertion = "-0.5"

Generates yellow assertions

Assertion = "1"

Generates green assertions

Assertion = "0"

Generates no assertion

Assertion = "NULL"