Viewing the Raw SQL
If there’s a need to examine the raw SQL generated by the filter (which is not normally required), it can be viewed or copied using the SQL section.
<Insert Raw SQL Screenshot here>
If a filter includes another filter using the Filter- Filter Element, or by connecting to the results of another filter using the Connection Filter Element, the hierarchy of dependencies between filters can be viewed using the Dependencies section. This section lists the filters the current filter includes, and the filters that include the current filter going as many levels deep as required.
The filters listed in the dependencies can be opens by double clicking on the filter in the dependencies section.
<Insert Dependencies Screenshot here>
Every design and refresh action for a filter is logged in the SysLog and can be viewed by Admin users in the syslog. But every user can view the Filter’s log entries by clicking the Log section.
<Insert Filter Log Screenshot here>
As each filter is created, a SQL Server View is automatically created that will select all the objects currently found by the filter. This lets SQL programmers include the filter in SQL queries.
- The view is read-only.
- It is created in the filter schema.
- Any spaces are removed from the filter’s name.
For example, a Filter called My First Filter could be used in the following SQL statement:
SELECT * FROM filter.MyFirstFilter
<Insert Relational Query View Screenshot here>