Home > Tools > Information Designer > Tips and Examples > Examples of Generated SQL > SQL – Filters

SQL – Filters 


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

id_sql_filters.png

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