GPVSearchInputField

New at 4.1

Each search form in the GPV must have one or more input fields associated with it. Each of these appear as a descriptive text label followed by a text box or dropdown list. Any number of input fields can be specified for a search. The GPV will provide a scroll if there are more than can fit in the panel.

• FieldID - The unique identifier for this input field (not null).
• SearchID - The ID of the GPV search this input field is connected to (not null). Links to GPVLayer.
• DisplayName - The label to appear next to this input field (not null).
• ColumnName - The column to query in the SQL SELECT statement for this input (not null). Can be any valid column expression, including a computation or function.
• FieldType - The type of input field to provide (not null). One of:
  • autocomplete - Provides a text box which shows valid values in a list as the user types.
  • between - Provides two text boxes for searching a range of numeric values.
  • lookup - Provides a dropdown list of valid values.
  • numeric - Provides a text box for entering a numeric value.
  • text - Provides a text box for entering any text value.
• ConnectionID - The database connection for the stored procedure when SearchCriteriaType is autocomplete or lookup. If null, defaults to the configuration database. Links to GPVConnection.
• StoredProc - The name of the autocomplete or lookup stored procedure which handles the valid values for this input field.
• SequenceNo - A number specifying the display order of this input field (not null).
• Active - Specifies whether this input field should be available for use, 1 for yes and 0 for no. If null, defaults to 0 (no).