Requests & Data Sources Panel

How to:

A request is a definition of something that can executed. For example, you can execute an embedded procedure, external procedure, HTML page, URL, and more. If a request has parameters, those parameters will be indented and listed under the request name. By default, all parameters are sent to the Reporting Server. However, you can choose to not send a parameter in the request section by using the shortcut menu of the parameter, and clicking Don’t Send. If you choose to not send a parameter, you must verify that your procedure can work without that value. For example, it contains a -DEFAULT value for the parameter.

When creating an external request that uses an existing file, the request inherits the name of that external file. For example, if you create an external request that uses an existing WebFOCUS procedure called Parameter_Report, then your external request will inherit the name Parameter_Report.

Each request displays two folders beneath it, the Columns and Parameters folders. The Columns folder contains the fields used in the request. The Parameters folder contains the parameters used in the request. The Parameters folder is expanded by default, while the Columns folder is collapsed by default.

The Data Sources folder contains all data sources, used for embedded procedures and default control population requests, in the HTML page. Referenced data sources are not displayed in the Requests & Data sources panel. You can add additional data sources to the HTML page by embedding additional requests. You can also add additional data sources by right-clicking on the Data Sources folder, and using the shortcut menu to click Add Data Source.

You can refresh all requests, except empty requests, using the shortcut menu. Right-click a request and click Refresh.

You can also duplicate a request by using the shortcut menu, on the request you want to duplicate, and clicking Clone. When you clone an embedded request, you create a copy of the embedded request with the name, name_1. Name is the name of the original embedded request. For example, if you clone a request named SaleReport, the cloned request would be called SalesReport_1. Cloning an external request does not make a second copy of the referenced procedure.

In the Requests & Data sources panel, each icon next to an item indicates the type of request or parameter. For example, a parameter that was created in the current HTML page has the parameter symbol and an addition sign on it. Another example is how an external URL request has the word URL on it. The Requests & Data sources panel is shown in the following image.

Requests section of Tasks and Animations panel

You can drag, parameters and fields to the Settings panel to configure the selected component or control. You can drag requests from the Tasks & Animations panel to the HTML canvas, to create objects and controls for the request.

Related Information:

New request

Creates a new request. A request is an item that can be executed.

Delete

Deletes a selected request.

Refresh parameters

Refreshes the parameters used in the request.

Requests and Data Sources list

A list of requests and embedded data sources, defined in the HTML page.

Create input controls

Opens the New Parameter dialog box where you can select which input controls to create for parameters that are checked off in the Parameters list box, and if you want those controls chained to the parameter.

Save selection

Saves the parameters you currently have checked off in the Parameters list box. You can choose to send more or less parameters than the procedure in the request requires. If you send less parameters, then you need to make sure the remaining parameters are handled by a -DEFAULT, -SET, or some other construct in the request.

Clear selection

Clears all selected items in the Requests & Data sources panel.


Top of page

x
Procedure: How to Create an Embedded Procedure Request in App Studio
  1. Add an embedded procedure to the Requests & Data source panel. Click the New drop-down arrow, point to Embedded Request, and then click New Report, New Chart, or New Document to create and embed a new procedure. Point to Import Existing to embed an existing procedure file.

    A new request is created in the Requests & Data sources panel. If you are creating a new procedure, the Open File dialog box opens, prompting you to select a Master File. If you are embedding an existing file, the Open File dialog opens, prompting you to select a procedure file.

  2. Select a Master File or procedure file and click OK.

    If you are creating a new procedure, the canvas for that type of procedure opens. Once you are done creating the procedure, save and close the canvas.

  3. In the Requests & Data sources panel, you may drag the request that you created on to the canvas.

    A procedure object is created on the canvas. If the procedure contains parameters, a form control is also added to the canvas. A task is created in the Tasks section of the Tasks & Animations panel. An example of the Requests & Data sources panel and the Tasks & Animations panel for a request is shown in the following image.

    Requests section and Tasks section


WebFOCUS