Application management : Configuration : Self-Service : Web configuration : Configuring generic features : Adding additional SQL statements for filtering
Adding additional SQL statements for filtering
You can add additional SQL statements for filtering content. This SQL statement can be added to a Fixed filter on a list block.
Procedure
1. Select a web definition.
2. Expand its hierarchical page structure in the details panel.
3. Select List block.
4. Click the Additional SQL tab.
5. Type the additional SQL statement.
6. For example, AND MAIN_TABLE.SYSMELDER IN (SELECT SYSCODE FROM PERS WHERE CODE = '100001')
7. Click Save.
You have added an additional SQL statement to the fixed filter.