Search range properties

A search range consists of two edit boxes that define the lower and upper limits of a search, such as a search that looks for all records with an identification number from the lower limit to the upper limit. When users want to conduct a search, they can enter data in one or both of these edit boxes.

General

Property Description
FromID (advanced) Identification code for the search range’s “From” field.
ToID (advanced) Identification code for the search range’s “To” field.
ID (advanced) Identification code for the search range.

You cannot change the IDs of the out-of-the-box controls.

You can change the IDs that Infor Operations and Regulations generates for agency-defined controls, but we recommend that you use the default values.

Appearance

Property Description
FromLabelText Text of the “From” field’s label.
ToLabelText Text of the “To” field’s label.
Visible (advanced) Indicates whether the search range is visible on the page. The control will be hidden if you set the Visible property to False.

Behavior

Property Description
FromControlOperation SQL operation to perform on the “From” field’s value.
ToControlOperation SQL operation to perform on the “To” field’s value.
HasPopupButton Indicates whether popup buttons are displayed to the right of the search range’s “From” and “To” fields.
Required Indicates whether Infor Operations and Regulations will require the user to enter information in the search range fields.
FollowsAfter (advanced) ID of the control that the search range follows in the page's tab order.
FromTabIndex (advanced) Index number representing the position of the search range’s “From” field within the page’s tabbing order. The tabbing order is the order in which elements receive focus when a user presses the Tab key.
ToTabIndex (advanced) Index number representing the position of the search range’s “To” field within the page’s tabbing order. The tabbing order is the order in which elements receive focus when a user presses the Tab key.

Format

Property Description
DecimalPlaces Number of decimal places to show in the "From" and "To" fields.
FormatType Type of data users can enter in the “From” and “To” fields of the search range. You can select General, Decimal, Integer, Currency, Date, DateandTime, Time, Phone, Mask, or AlphaNumeric. The format type that you select must be compatible with the data type of the property that the search range is bound to.
MaxLength Maximum number of characters that can be entered in the "From" and "To" fields.

Layout

Property Description
Width Width of the search range in pixels. This value specifies the entire width covered by both fields.
Height Height of the search range in pixels.
FromWidth Width, in pixels, of the search range’s “From” field.
ToWidth Width, in pixels, of the search range’s “To” field.
Top (advanced) Position of the left edge of the search range, in pixels.
Left (advanced) Position of the top of the search range, in pixels.
FromLabelOffset (advanced) Amount of space, in pixels, reserved for the “From” field’s label.
ToLabelOffset (advanced) Amount of space, in pixels, reserved for the "To" field’s label.

Rules

Property Description
FromValidaitonRule Formula that will be used to validate the data that is entered in the search range's "From" field.
ToValidationRule Formula that will be used to validate the data that is entered in the search range's "To" field.

Value

Property Description
FromMoniker Moniker of the business object the search range’s “From” field is bound to. The FromMoniker and FromBind properties specify the popup that will be displayed for the “From” field.
FromBind Business object property the “From” field of the search range is bound to.
ToMoniker Moniker of the business object the search range’s “To” field is bound to. The ToMoniker and ToBind properties specify the popup that will be displayed for the “To” field.
ToBind Business object property the “To” field of the search range is bound to.