GPVSearchInputField

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.

Columns

• 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 GPVSearch.
• 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.
  • date - Provides a text box and popup calendar for entering a date value.
  • daterange - Provides two text boxes and popup calendars for searching a range of date values.
  • list - Provides a dropdown list of valid values.
  • number - Provides a text box for entering a numeric value.
  • numberrange - Provides two text boxes for searching a range of numeric values.
  • text - Provides a box to search for text exactly matching the entered value.
  • textcontains - Provides a box to search for text containing the entered value.
  • textstarts - Provides a box to search for text starting with the entered value.
• ConnectionID - The database connection for the stored procedure when FieldType is autocomplete or list. If null, defaults to the configuration database. Links to GPVConnection.
• StoredProc - The name of the autocomplete or list 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).