Pass a Parameter to the Bursting Query

You can pass the value for an element of your bursting XML using a parameter defined in the data model.

For example, if you want to be able to select the template at the time of submission, you can define a parameter in the data model and use the :parameter_name syntax in your query. The following example demonstrates this use case of a parameter in a bursting query.

Assume your report definition includes three layouts: layout1, layout2, and layout3. At submission time you want to select the layout (or TEMPLATE, as defined in the bursting query) to use.

To pass a parameter to the bursting query:

1. In your data model, define a list of values with the layout names.
   
   

   
   Description of the illustration xdo11g_dme_burstparm_a.gif

   
   
2. Create a menu type parameter. Enter P1 as the name and and select List of Layouts from List of Values.
3. In the bursting query, pass the parameter value to the TEMPLATE field using :P1 as shown in the following figure:
   
   

   
   Description of the illustration xdo11g_dme_burstparm3a.gif