Article Details
| Id: | 18936 |
| Product: | finPOWER Connect |
| Type: | NEW |
| Version: | 3.04.04 |
| Opened: | 08/10/2021 |
| Closed: | 08/02/2022 |
| Released: | 09/06/2022 |
| Job: | J027534 |
 High Importance |
|
Range Lookups; now support an option to show/ hide Inactive records
Range Lookups now support an option to show or hide Inactive records.
If this is applicable a new "Show Inactive?" checkbox is shown between the grid and range textbox. The default is unchecked, i.e. inactive records are hidden.
This option is shown if the selection grid includes an "Active" column (normally hidden) and there are inactive records.
NOTE: If a range is entered, e.g. A-D and an inactive record, e.g. B, is within that range it will be included in the filter. Therefore it will be shown in the selection grid regardless of whether "Show Inactive?" is checked or not. In this case you can still exclude the item by adding a not range, e.g. "A-D,!B".