An SQL query can be defined in the initialization query section that will be executed before the actual JobSelect query is run. This can be used e.g. to summarize time-consuming data and to accelerate the actual query. The initialization query gives the user no feedback on the surface.
If the direct search setting is activated, the initialization query will be run once during the first call of report. Otherwise the query will be run when a filter action is executed for the first time.
The initialization query will be run every time if the refresh button of the report is clicked.
If the execute initialization query on any filter action is activated, the initialization request will be additionally executed for every filter action.
You have the possibility to use Placeholder for database and initialization queries of JobSelect.
Please note: Only UPDATE, DELETE FROM...; INSERT INTO statements are allowed in an initialisation query.
Example of an initialisation query:
The data to be displayed in the JobSelect are cumulated values from a table.
Depending on the amount of data, this accumulation can take longer and is separated from the actual query by placing it in the initialisation query:
Initialisation query:
DELETE FROM myFinalTable;
INSERT INTO myFinalTable (total_net_amount, cost_center)
SELECT SUM(net_amount), cost_center
FROM processTableNetAmount
GROUP BY cost_center;
SQL query of the JobSelect:
SELECT total_net_amount, cost_center
FROM myFinalTable
