Output Format Select “XML” as the output format. To use the concurrent manager to execute your data template, you must register a Concurrent Program, using the define Concurrent Programs form:Įxecutable Name Enter the XML Publisher data engine executable: XDODTEXE After that you attached the RTF template to that data definition.Ĭalling a Data Template from the Concurrent Manager: There are two methods for calling the data engine to process your data template:īefore you can use either of these methods, you must first register your data template in the Template Manager as a Data Definition. You can specify all the columns within each group and break the order of those columns you can use summaries, and placeholders to further customize within the groups. The complete group hierarchy is available for output. In the data structure section you define what the XML output will be and how it will be structured. Name: The event name to fire this trigger.The element has a set of related attributes. Using the conditional processing capabilities of PL/SQL for these triggers, you can do things such as perform initialization tasks and access the database.ĭata triggers are optional, and you can have as many elements as necessary. 3] Using Data Triggers:ĭata triggers execute PL/SQL functions at specific times during the execution and generation of XML output. Use these attributes to specify the required link information. The following example shows a query link using a bind variable: In the data template, there are two methods for linking queries: using bind variables or using the element to define the link between queries. If you have multiple queries, you must link them to create the appropriate data output.
#Bi publisher add parameters sql query example how to#
WHERE glb.period_name BETWEEN :P_PERIOD_FROM AND :P_PERIOD_TO’ How to Define a Data Link between Queries: In the function xxfin_test_pkg.beforeReport, you can design your query at runtime as below: Create your query containing lexical references.The data engine uses these values to replace the lexical parameters. Before creating your query, define a parameter in the PL/SQL default package for each lexical reference in the query.Use a lexical reference when you want the parameter to replace multiple values at runtime.Ĭreate a lexical reference using the following syntax:ĭefine the lexical parameters as follows: You can use lexical references to replace the clauses appearing after SELECT, FROM, WHERE, GROUP BY, ORDER BY, or HAVING. The query is entered in the CDATA section. The element has a related attribute, name. The element is placed between the open and close dataQuery tags. The section of the data template is required. WHERE glb.period_name BETWEEN :P_PERIOD_FROM AND :P_PERIOD_TO 2] Data Query Section: To pass parameters, (for example, to restrict the query), use bind variables in your query. However, the Parameters section of the data template is optional. Parameters are especially useful for modifying SELECT statements and setting PL/SQL variables at runtime. The data template is an XML document that consists of four basic sections:Ī parameter is a variable whose value you can set at runtime. It is an XML document whose elements collectively define how the data engine will process the template to generate the XML. The data template is the method by which you communicate your request for data to the data engine. The XML Publisher data engine enables you to rapidly generate any kind of XML data structure against any database in a scalable, efficient manner which you can easily use in your templates. The data templates are useful when you need to create a XML Publisher report without using the RDF.