GO Loader Aviation 1.2 is here! Take a look at what's new.
Skip to end of metadata
Go to start of metadata

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.

 

Global filter

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.

Local filters

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

Where

The text will be added to the WHERE clause of the SQL filter.

Parameters

Text elements in curly brackets are treated as parameters.

Example

When publishing from GO Publisher Desktop, the value for the parameter is set in the Desktop Settings tab.

When publishing from GO Publisher Workflow, the value for the parameter is set in the publishing job. See Selection by Parameter on the Data Selection page for more details.

Order By

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.

ORDER BY OVERHEIDSCODE DESC NULLS LAST;

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.

Further Reading

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.

For configuring the data output settings, see Desktop Settings Tab. When you're ready to publish your data, see Publish and validate output files.

  • No labels