System Table TB_POSITION_FINDER

The system table TB_POSITION_FINDER resides in the industry model.

Attributes of TB_POSITION_FINDER	Description
Base attributes
NAME	Specifies the name or header of the search that will be displayed in the Feature Search group box.
GUITYPE	Specifies the search type: 1 = sequential (Default) 2 = flat 3 = PlugIn
PRIORITY	Defines the order of the entries. Default = 0.
Sequential search	The following four attributes are needed to define a sequential search.
STMT_TITLE_*	Stores the title and short explanation that will be returned with the n th query.
SELECT_STMT_*	Stores the search query. This is a standard SQL statement. Note: The first search query has no placeholders.
GEOM_STMT_*	Stores the geometry query. Always optional, except when it is the last query. select geom from <table> where fid = {x}.
INPUTTYPE_*	Stores the input type for the results in the n th query: 1 =select list (Default); 2 = text box 3 = text box with auto complete
NOT_FOUND_MSG_*	Defines an optional message to be used as a prompt if the search query returns no rows.
Flat Search	The following attributes are needed for flat search: With these attributes, the select statement is composed as follows: select <pk_column>, <input_colums> from <table_name> where upper(<input_column>) like upper(<param>) order by <order_column>
TABLE_NAME	Stores the name of table or view containing the data.
PK_COLUMN	Stores the name of the attribute containing the primary key. This is the key attribute.
GEOM_COLUMN	Specifies the attribute containing the geometries. This is the geometry attribute.
ORDER_COLUMN	Specifies the order of the query results. May contain more than one attribute (comma separated). Optional.
INPUT_COLUMN_*	Stores the input attributes (1-5) that will be used for the WHERE Clauses.
STMT_TITLE_*	Stores a short explanation of the corresponding input column_* of the data table.
NOT_FOUND_MSG_1	Stores the message to be used as a prompt if the search query returns no rows. All other ‘NotFound Messages’ (2-4) will be ignored.
Assembly Name Namespace Class Name	Stores the properties used in a Plug-In search.