I’m trying to set up two Data Lookups according to the instructions here: https://www.youtube.com/watch?v=YAAOAN9KTJs&t=1432s.
In both cases I want to populate a Reference column on my Import Set table (x_acso_spencer_imp_spencer_data) when a particular String field is set. The source table is the same for Cases 1 and 2. One mapping works, while the other does nothing.
Both data lookup definitions have Run on form change checked so I can test them in the front end.
Case 1 Part ID to Model (works as expected)
Here I want to populate [Source table].u_model, a reference to Product Model (cmdb_model), when u_part_id, a String, is populated.
Source table | x_acso_spencer_imp_spencer_data |
Matcher table | x_acso_spencer_imp_spencer_inventory_rule |
The matcher table is like so. This extends dl_matcher:
The Data Lookup Definition (under System Policy | Rules | Data Lookup Definitions):
I have one row in my dl_matcher table:
Testing this matcher
When I open a new row in the source table and fill in part id and tab out, the Model is populated.
This is the expected result.
Case 2 Part Group to Model Category (not working)
Here I want to populate [Source table].u_model_category, a reference to Model Category (cmdb_model_category), when u_part_group, a String, is populated.
Source table | x_acso_spencer_imp_spencer_data |
Matcher table | x_acso_spencer_imp_inventorystagingmodelcategory |
The matcher table is like so. This extends dl_matcher:
The Data Lookup Definition (under System Policy | Rules | Data Lookup Definitions):
I have one row in my dl_matcher table:
Testing this matcher
When I open a new row in the source table and fill in part group and tab out, I expect Model Category to be populated.
But nothing happens. There is no error in the console etc. The Model Category field itself behaves as expected, shows its value list etc.
Can anyone spot a problem here?
