How to apply Filter condition on Fields in Catalog Item

[venkatanathansp]

In catalog item, i have one fields one is Vendor which is referenced to core_company table and i have another field Contract number which is referenced from the ast_contract table. My requirement is when the user selects any company from the Vendor field , then the contract number should be filtered based on the company vendor which is selected by the user. In ast_contract table we have the vendor field, so that when the user selects the company name in vendor field then the contract number should be filtered based on the company which selected by the user. Give me the solution for this one.

[fathahhkf]

Hi @venkatanathansp,

You can write a filter it in advance reference qualifier. Please find below sample.

javascript:'vendor='+current.variables.company.value

Regards,

Abdul Fathah

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@venkatanathansp 

you can use advanced ref qualifier on Contract number variable

something like this

// give the correct field name on ast_contract table

javascript:'vendor='+ current.variables.vendorVariable;

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@venkatanathansp 

Thank you for marking my response as helpful.

As per new community feature you can mark multiple responses as correct.

If my response helped please mark it correct as well so that it benefits future readers.

[Brad Bowman · Accepted solution]

In this case you don't need to call a Script Include, you can use a reference qualifier that looks like this:

where 'v_vendor' is the name of your Vendor variable.