GO Publisher Desktop SQL Filters Tab
GO Publisher uses a SQL query to fetch data from the database. The SQL filter tab allows you to refine the selection of data from the database tables used to create the output XML.The "WHERE Clause" of this SQL query can be extended by the user.
To do this, you have to enter an SQL expression in the table of the SQL filters tab in the main workspace.
Image of the SQL Filter tab in GO Publisher Desktop
See Use SQL Filters to map selective rows for how to map selective rows using SQL Filters.
If you want to apply the filter to all tables of the project, you have to enter the SQL expression into the All row of the table.
If you want to apply a filter to a certain table of the project, you have to enter the SQL expression into the row with the corresponding table name.
You can open a more extended editor for editing the SQL expression by selecting Edit in the context menu of the table (Right mouse click).
Image of the Edit Table option on the Table context menu.
The edit table option opens the Edit Table Properties dialog.
Image of the Edit Table Properties dialog
The text will be added to the WHERE clause of the SQL filter.
Text elements in curly brackets are treated as parameters.
An additional order of the output results can be realized by entering a SQL fragment into the ORDER BY field of the table or dialog. The SQL string will be inserted into the ORDER BY clause of the generated SQL.
Automatic generation of Oracle hints
In case of large databases performance can become a critical issue. Additional hints in the SQL command can help to optimise performance, especially when a normalised database model is used. A predefined set of hints can be generated automatically for Oracle databases using this tool. By applying this tool, the hints well be generated and stored in the project. The next time data is published, the generated hints will be executed with the other SQL statements.
See the section on SQL Filter Toolbar for further information on the automated generation of Oracle Hints.
Also see the Edit Table Properties section for further information on working with 'Where', 'Oracle Hint' and 'Order by' elements SQL queries of table queries.
Use SQL Filters to map selective rows explains how to use SQL Filters to customise your database to XML mappings.
For information on the SQL Filter tool, see SQL Filter Toolbar.
If you need to edit your database, schema repository, XML content, or geometry settings, see Settings Tab for more information.