Search range properties
General
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.
| 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. Infor Public Sector automatically generates an identification code for each control you add in the Page Editor. Although you can change these identification codes, 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 Public Sector 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. |