Incorporating the GIS Filter

How to:

The WebFOCUS GIS Adapter interface allows the developer to select from multiple parameter passing styles.

The three styles offered are:


Top of page

x
Procedure: How to Incorporate the GIS Filter for Amper as String and Amper as Number Styles in a WebFOCUS Desktop Product

For Amper as String and Amper as Number styles, the method of incorporating the filter will be very similar. The steps to access the Expression Builder dialog box to create your Amper variables are different in each WebFOCUS desktop product, but the process to create the variable is the same. The following steps provide information for both WebFOCUS desktop products, App Studio and Developer Studio.

  1. If you are using WebFOCUS App Studio, do the following:
    1. Launch WebFOCUS App Studio.
    2. Use the Report canvas to develop the procedure.
    3. On the Report tab, in the Filter group, click Filter, and then click Where.

      The Expression Builder dialog box opens.

  2. If you are using WebFOCUS Developer Studio, do the following:
    1. Launch WebFOCUS Developer Studio.
    2. Use Report Painter to develop the procedure.
    3. Click the Where/If button from the toolbar, and select Where.

      The Expression Builder dialog box opens.

  3. Double-click the field on which you will filter.
  4. Select equals from the Logical Relation column.
  5. Select Parameter from the Compare Type column.
  6. Double-click to edit the Compare Value.
  7. Ensure that the name of the Filter in the Name field of the Variable Editor dialog box is the one you want for this variable.

    The name that is displayed here will be specified later during the FEX procedure definition.

  8. Click OK to return to the Expression Builder dialog box.

    An example of a completed expression, in App Studio, is shown below.

  9. Select the Advanced check box.

    If the field you are filtering against is alphanumeric, the Expression Builder dialog box will enclose the Compare Value name in single quotes.

    Editing the Variable

    Since the value string being passed to the procedure will already have single quotes around each of the values you must remove them in the editor. Change the expression to resemble the example.

    Editing the Variable

  10. Click OK to close the Expression Builder dialog box.

Top of page

x
Procedure: How to Incorporate the GIS Filter for the Data in File Style

When the list of map features that will be selected would extend past the limit of a parameterized WHERE clause, it is necessary to refer to the filter list as a sequential file. This requires one slight difference in the way the filter is specified.

Perform the following steps to incorporate the GIS filter for the Data in File style.

  1. If you are using WebFOCUS App Studio, do the following:
    1. Launch WebFOCUS App Studio.
    2. Use the Report canvas to develop the procedure.
    3. On the Report tab, in the Filter group, click Filter, and then click If.

      The Expression Builder dialog box opens.

  2. If you are using WebFOCUS Developer Studio, do the following:
    1. Launch WebFOCUS Developer Studio.
    2. Use Report Painter to develop the procedure.
    3. Click the Where/If button from the toolbar, and select If.

      The Expression Builder dialog box opens.

  3. Double-click the field on which you will filter.
  4. Select equals from the Logical Relation column.
  5. Select Parameter from the Compare Type column.
  6. Double-click to edit the Compare Value.
  7. Ensure that the name of the Filter in the Name field of the Variable Editor is the one you want for this variable.

    The name that is displayed here will be specified later during the FEX procedure definition.

  8. Click OK to return to the Expression Builder dialog box.
  9. Select the Advanced check box.

    The variable name will need to be enclosed in parentheses to refer to the sequential file the GIS Adapter will create.

    Change the following expression:

    Editing Expression

    to:

    Editing Expression

    For more information on filtering your request with a sequential file of values, see your WebFOCUS documentation.

  10. Click OK to close the Expression Builder dialog box.

WebFOCUS