Dynamic Reference Variable on different tables

[kandulek]

Hello all,

What would be the best solution to achieve the following:

1. I have variable X on item that is a Select Box with Question Choices: Business Service; Service Offering; Business Application

2. I need a dynamic variable to display records from different tables depending on the previous selection

• if variable X is "Business Service", then display a Reference variable to table: cmdb_ci_service_business (Condition: "Service Status" is one of=Planned;Productive)
• if variable X is "Service Offering", display a Reference variable to table: service_offering (Condition: "Service Offering Status" is one of=Planned;Productive)
• if variable X is "Business Application", display a Reference variable to table: cmdb_ci_business_app (Condition: "Application Status" is one of=Planned;Productive)

[jcmings · Accepted solution]

I think the easiest way to achieve this would be with a Catalog UI Policy that shows/hides the reference variables (you'll have three total, rather than one "dynamic" one) based on the selection of variable X