Passing Multiple Parameters in a Query-Based Auto-Drill

The prior examples (Example 1: Passing column values in a drill and Example 2: Passing query-based values in drill) described how to use auto-drilldowns to pass a single parameter to a specified report or web page. It is also possible to pass multiple parameters in an auto-drill.

The procedure for creating multiple-parameter drills is the same as described in the previous sections. If the query specified in Steps 110 of Example 2: Passing query-based values in drill returns more than one column, all of the returned columns will be available for selection in the 'Value' pane of the 'Auto Drill' page (Steps 910).

For example, if a query called 'getProductInfo' accepts a parameter and returns the two columns 'PRODUCT_ID', and 'SUPPLIER_ID,' then when you specify the 'getProductInfo' query in the 'Auto Drill' window, these two columns will be shown in the 'Value' pane. Each of the multiple attributes listed in the 'Value' panel can then be selected and mapped to a parameter name.

 

As in the previous examples, if the auto-drill is targeting a report, the parameter names specified in the 'Auto Drill' window must match the corresponding parameter names specified in the report. If the auto-drill is targeting a web page, the parameter names specified in the 'Auto Drill' window will be the names used in the hyperlink URL, with parameter-value pairs separated by the ampersand (&) symbol. For the 'Auto Drill' settings shown above, the resulting hyperlinks will have the form

http://remotehost?param1={value1}&param2={value2}

where param1, param2 are the parameter names specified in the 'Auto Drill' window, and {value1}, {value2} are the values returned by the query for the user's particular hyperlink click.

If an auto-drill query returns multiple rows, the user is prompted to select one of the possible parameter combinations. For example, consider a case where the user clicks on a 'State' field to see a list of orders for a customer. If there is only one customer in a given State, the drill-down goes directly to the detail report. However, if there are multiple customers in the selected state, the user is first prompted with a list of these customers. After they submit their selection, the detail report returns data for the chosen customer.

<< Example 2: Passing query-based values in drill © 1996-2013 InetSoft Technology Corporation (v11.4) Adding Auto-Drilldown to a Query >>