Reference qualifier to display only two fields for a table

[Arindam Bose]

Hello All,

We have two fields called "u_name" and "u_expiry_date" in the "ast_contract" table. This table is user in a Catalog Item variable. There is a field which is referencing the ast_contract table in one of the questions of the Ctalog item. I want to display the fields  "u_name" and "u_expiry_date" over there and not the default number field which is being shown.

Please see attached screenshots for the same.

[Dubz]

You need to put that string into the attributes field on the dictionary entry for the reference field, this will add an additional field into the drop down suggestions when you start writing in the reference field but it won't override the display value, i don't think there's a way to do that.

[Ankur Bawiskar]

Hi Arindam,

add the u_name and u_expiry_date field in this attribute and it should show you those 3 column data while typing into

ref_ac_columns=u_name,u_expiry_date

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Arindam Bose]

Hello,

Thank you for your help. But this is not working.

[Ankur Bawiskar]

Hi Arindam,

can you share screenshot of the dictionary attribute

Regards

Ankur