Reference Qualifier help on catalog Item

[Rob Bushrod]

Hi,

I'm looking for some help with the following please?

I have a variable which is a reference to the Contract (ast_contract) table and I need to try and filter the list displayed to only show the contracts that have a matching Customer.

I have a variable called Customer Name (customer_name) which is a reference to the Company (core_company) table and this is the value that I need to use to check with.

If there are no matches then it needs to return empty so that the user knows they need to select New instead of Existing on a different variable choice.

Many Thanks,

Rob

[Deepak Negi · Accepted solution]

Hi

You can apply the reference qualifier using the "customer_name" variable. On the variable which is a reference to Contract table. You can update reference qualifier as below:

javascript: "customer="+current.variables.customer_name;

[Mark Manders]

If it's more than one contract, you can use the ref qual Deepak shared, otherwise you can use the 'auto populate' function on the variable.