Custom data lookup
-
- UpdatedJan 30, 2025
- 2 minutes to read
- Yokohama
- Now Platform Capabilities
You can create a custom table to store lookup data.
The custom table must extend the Data Lookup Matcher Rules [dl_matcher] table.
For example, you can create a Server Offering Lookups table. It stores information about matcher offerings (bronze, silver, and gold) and associated setter values (memory and disk space) for each matcher offering.
Create a custom data lookup
Creating a catalog data lookup is similar to creating a normal, custom data lookup except when creating the catalog data lookup definition record.
- Create a custom data lookup table. It must extend the Data Lookup Matcher Rules
[dl_matcher]
table. - Add data lookup values to the data lookup table.
- Create a catalog data lookup definition record.
- (Optional) Create a data lookup module.
Troubleshooting
If the custom data lookup definition rules are not behaving as expected, check for certain conditions.
- Ensure that the matcher variable is not read-only. Since users cannot change read-only variables, there cannot be an on form change event for read-only variables.
- Ensure that the data in the matcher table is correct.
- If the lookup requires an exact match, verify that there is a matcher table row for each possible combination (including blank values). The lookup fails if it cannot find a matching value.
- If the variable is an option or check box, it always has a value, so you must select Always replace.
- Verify that you have not created a recursive rule, such as:
If Variable A = 1, then Variable B =2. If Variable B = 2, then Variable A = 2.