Model field not populating dropdown as per the Model Category selected

Preksha Kapoor
Tera Contributor

Hi Folks,

We are creating a Record Producer for Hardware table and in this we want to populate Model field as per he Model category selected by the user.

 

For example : If user has selected " computer " as the Model category then the Model field should show dropdown related to Computer

 

We have tried Refrence Qualifer but it is showing the whole Model Table data

 

Tables used:

 

Model category: cmdb_model_category

Model : cmdb_model

 

PrekshaKapoor_0-1742369032359.png

 

1 ACCEPTED SOLUTION

Reus
Tera Expert

You could use a lookup select box type variable with following details:

Reus_0-1742371910909.pngReus_1-1742371936450.png

This works for me.

You can use Reference type variables with the reference qualifier as 'javascript&colon; 'cmdb_model_category='+current.variables.<variable_name_of_model_category>;'

 

Please check.

 

View solution in original post

6 REPLIES 6

Shivalika
Mega Sage

Hello @Preksha Kapoor 

 

I have been working on CMDB cleanup these days and declassifying model category and model is one of the tasks. 

 

 

But it's actually like You choose the model and model category will automatically populate 

 

Please refer this servicenow Kb Article for the same - https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0724180

 

Since they both are reference fields so dependency is mutual. 

 

Kindly mark my answer as helpful and accept solution if it helped you in anyway,

 

Regards,

Shivalika 

 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

 

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwN

eEISQCY

Preksha Kapoor
Tera Contributor

Hi @Reus 
This works for me, Thankyou for your help!