GPVSearch

Each layer in the GPV can have one or more search forms associated with it. These searches appear in the top dropdown list on the Search function tab. When a search is selected the user is given a form with input fields for specifying the search criteria.

• SearchID - The unique identifier for this search (not null).
• LayerID - The ID of the GPV layer this search is connected to (not null). Links to GPVLayer.
• DisplayName - The name of this search on the interface (not null).
• ConnectionID - The database connection for the stored procedure. If null, defaults to the configuration database. Links to GPVConnection.
• StoredProc - The name of the stored procedure which provides the text of the SQL SELECT statement for this search (not null). The GPV inserts a WHERE clause into this statement when performing the search.
• SequenceNo - A number specifying the display order of this search (not null).
• Active - Specifies whether this search should be available for use, 1 for yes and 0 for no. If null, defaults to 0 (no).

Here is an example of entries in the Search configuration table and an example of a search stored procedure. These are for the host.appgeo.com/encmaster web site.