SQL – Filters 


In this example we will define a column element with a filter. The column should only return sales transactions above 10000.

Save the column element with the name High Sales.

The column element defined above will result in the following SQL when executed as part of an information link:

SELECT

   S1."Sales" AS "HIGHSALES"

FROM

   "Sales"."dbo"."SalesandCost" S1

WHERE

   (S1."Sales" > 10000)

   AND <conditions>

See also:

Filter Elements Overview

Creating a Filter Element

Understanding Filters