cmdb_software_product_model and Type Specifications (reference qual: javascript:'Status=In Production')

hm69
Giga Contributor

I have Variable for a Catalog Item that shows a software list in the cmdb_software_product_model table (menu works fine).  However, I'd like to only show software that is In Production.  Retired and Sold should not show up. 

On my Variable, I have a Look up Select Box and under the Type Specifications tab I have the following (see below), but my Reference Qualifier doesn't work.  I've tried a few variations -- does anyone know how I might filter on Status.

Lookup from table: cmdb_software_product_model

Lookup value field: Display name

Reference Qualifier: javascript:'Status=In Production'

 

 

1 ACCEPTED SOLUTION

vkachineni
Kilo Sage
Kilo Sage

Try lowercase

 

status='In Production'

Please mark Correct and click the Thumb up if my answer helps you resolve your issue. Thanks!
Vinod Kumar Kachineni
Community Rising Star 2022

View solution in original post

2 REPLIES 2

vkachineni
Kilo Sage
Kilo Sage

Try lowercase

 

status='In Production'

Please mark Correct and click the Thumb up if my answer helps you resolve your issue. Thanks!
Vinod Kumar Kachineni
Community Rising Star 2022

hm69
Giga Contributor

Brilliant!