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

For Amper as String and Amper as Number styles, the method of incorporating the filter will be very similar.

  1. Launch WebFOCUS Developer Studio.
  2. Use Report Painter to develop the procedure.
  3. Click the Where/If button from the toolbar or click Report from the menu bar and select Where/If.
  4. Click the Assist button.
  5. Double-click the field on which you will filter.
  6. Select equals from the Logical Relation column.
  7. Select Parameter from the Compare Type column.
  8. Double-click to edit the Compare Value.
  9. Enter the name of the Filter in the Name field of the Variable Editor.

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

  10. Click OK to return to the Expression Builder.

    An example of a completed expression is shown below.

  11. Click OK to close the Expression Builder.

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

    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.


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. Click the Where/If button from the toolbar or click Report from the menu bar and select Where/If.
  2. Click the If tab.
  3. Click the Assist button.
  4. Double-click the field on which you will filter.
  5. Select equals from the Logical Relation column.
  6. Select Parameter from the Compare Type column.
  7. Double-click to edit the Compare Value.
  8. Enter the name of the Filter in the Name field of the Variable Editor.

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

  9. Click OK to return to the Expression Builder.
  10. Click OK to return to the Report Options panel.

    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:

    to:

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


WebFOCUS