Model Name Reference Qualifier

[sarahyelton]

I would like to modify the out-of-the-box reference qualifier for the model field on the alm_asset table.   There is a column on the model_name table (status) where you indicate if the model is "In Production", "Retired", or "Sold".   I only want users to be able to select models that are "In Production" for new asset record entries.   This is the current script for the reference qualifier.   How do I add to it to only display models where the status value is "In Production"?   Thank you for your help.   I'm not well versed in writing scripts.

javascript:new ModelAndCategoryFilters().assetModelRefQual(current)

This is the status column.

[sarahyelton]

This worked perfectly!   Thank you!!

[Michael Ritchie]

Awesome glad this worked for you.   Can you please mark this post as answered so others viewing can benefit?

[sarahyelton]

For whatever reason, it won't allow me to mark it correct.   I will try and figure out why.   Thanks again.

[AaronO]

That's a really nice Michael Ritchie.  This should have been marked as the correct solution.  I didn't know you could do what you just did.  Great outcome.  It worked for me. Thank you.