I have my data in Service Now Tables and I want to filter data and show in catalog forms dynamically. Suppose there are 4 tables and one is dependent on another table based on PK/ FK relationship (lookup type). In catalog form, based on selection from one field, the dependent field should show values... eg - continent, country, state, district etc... if Asia is selected, then only Asian countries should show up. consider that one table has data for continents, one table for countries, one for states etc. I want to create a dynamic configuration and a reusuable function.. so that if the table name changes or any new table is added and we want to have filtering based on logic, that can be re-used. How can I achieve this in Service Now? The function should be parameterized and should be able to take inputs. We can also considering having a common config so that the admin can change the config and accordingly we can have the filters.
