How to: |
The WebFOCUS GIS Adapter interface allows the developer to select from multiple parameter passing styles.
The three styles offered are:
If the field in the database you will be accessing is alphanumeric, you should choose this. The Filter will be comprised of each of the selected values enclosed in single quotes and separated by "OR," for example, 'AK' OR 'AL' OR 'AR' OR 'AZ.'
If the field in the database you will be accessing is numeric, you should choose this. The Filter will be comprised of each of the selected values separated by "OR," for example, 10001 OR 10002 OR 10003 OR 10004.
If the values selected from the map will be extensive this would be the best option. The values will be placed in a sequential file within the WebFOCUS temporary disk space.
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.
The Expression Builder dialog box opens.
The Expression Builder dialog box opens.
The name that is displayed here will be specified later during the FEX procedure definition.
An example of a completed expression, in App Studio, is shown below.
If the field you are filtering against is alphanumeric, the Expression Builder dialog box 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.
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.
The Expression Builder dialog box opens.
The Expression Builder dialog box opens.
The name that is displayed here will be specified later during the FEX procedure definition.
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 |