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 name that is entered here will be specified later during the FEX procedure definition.
An example of a completed expression is shown below.
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.
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 name that is entered 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 |