Reference Qaulifer to Limit potential choices based on Incident Category

[Gregory Gribben]

Hey guys,

I would appreciate some guidance. I have added a product field (customer field u_product) referencing "cmdb_application_product_model" to my incident form, I then have a record producer, that creates an incident based on a form available on our Portal. Our cmdb_application_product_model contains about 55 possible choices. I am hoping to filter the selection of choices based on a category that is set on the incident. 

The category of Incident via Record Producer is Demo

Possible choices should be (instead of the full list of 55+ choices):

a

b

c

I am still very new to reference qualifiers and the potential of using a script include, which I believe would then be used on the variable within the record producer.

[Najmuddin Mohd]

Hi @Gregory Gribben ,

Where the dependency is stored, that a, b, c belongs to Demo Category ?

Regards,
Najmuddin

[Gregory Gribben]

I created a custom field on the cmdb_ci_application_product_model table `u_used_for` my thought is I can use this field to reference applications that belong to the Demo Category 

[Najmuddin Mohd]

Yeah, so u_used_for will be one of the many category of the Incident. i.e., It is associated to one category.

Now, write an Advance reference qualifier on the u_product field of the incident, calling a script include by passing the current category of the incident.

In the script include, GlideRecord the cmdb_ci_application_product_model table and query those records with the current category and return the records.

If this information helps you, kindly mark it as Helpful and Accept the solution.

Regards,
Najmuddin.


I