refrence qualifier condition is not working

[mani55]

refrence qualifier condition is not working in catalog variable so please let me know the mistake

[Rajesh Chopade1]

Hi @mani55 

Try bellow reference qualifier once

'u_catalog_item.short_descriptionLIKEdsk045^u_name=' + current.variables.model_item + '^u_availability=true';

I hope my answer helps you to resolve your issue, if yes please mark my answer helpful and correct.

thank you

rajesh.

[mani55]

i tried these but no LUCK

[Brad Bowman]

Hard to say given the custom table.  Make sure your table has a field named u_catalog_item that is a reference, and that all of the field names used are exactly correct.  Start with a list view on the custom table and filter it with a hard-coded name to copy the query as a starting point to check this.  Next try removing one condition at a time, name first, to see when it starts working.  I'm not sure you can use getDisplayValue() in a reference qualifier, so try to dot-walk this to the Name or DisplayValue field you are after.

[Rohit99 · Accepted solution]

Hi @mani55 ,

I tried on PDI and its working.

You may try with the following ref qualifier :

javascript:'u_short_descriptionLIKEdsk045^u_availability=true^u_name='+current.variables.model_item.getDisplayValue()

Can you please check the backend field name of short description as everywhere you used u_field_name.

Please mark my response as correct and helpful if it helped solved your question.

Thanks,

Rohit Suryawanshi