Reference Qualifier on Catalog item not working.

Mark Brogna
Tera Contributor

I have a client callable script include that returns all product classifications referenced in the cmdb_software_product_model table.

MarkBrogna_1-1742426151363.png

 

 

I call this from a catalog client script to populate a select list variable, labeled ‘Select a function’, with both sys_id and display.

MarkBrogna_2-1742426195350.png

Once a user selects the ‘Select a function’ I want to build a reference qualifier based on the sys_id to populate ONLY records from the cmdb_software_product_model table that are assigned the function selected.

 

MarkBrogna_0-1742425978760.png

 

It appears that a sys_id is being returned from the value select in the function select box. But, the reference qualifier does not appear to be working for the function, 'Action games', as two values should be returned. When I hard code the sys_id in the reference qualifier it returns two results in 'Please select software.'

MarkBrogna_3-1742426323612.png

 

 

6 REPLIES 6

Medi C
Giga Sage

Hi @Mark Brogna,

 

Please use GlideRecord instead of GlideAggregate 


If you found this helpful, please hit the thumbs-up button and mark as correct. That helps others find their solutions.

Mark Brogna
Tera Contributor

the glide aggregate is needed to get a distinct list. But, that was not my question.

Hi @Mark Brogna,

 

Could you please try including the sys_id on your obj on your script include. and use that as the value on your client script? 


If you found this helpful, please hit the thumbs-up button and mark as correct. That helps others find their solutions.

Hi @Mark Brogna,

 

Was this helpful? 


If you found this helpful, please hit the thumbs-up button and mark as correct. That helps others find their solutions.