Reference qualifier to show field values of parent record

[sanathk]

Hello Community,

I have variable of type reference which is referencing to pm_project_task table in catalog form view I need to show the number of project task(because without using below attribute I am getting short description of project task default) , so I am using this in variable attributes ref_ac_columns=number,ref_auto_completer=AJAXTableCompleter,ref_ac_columns_search=true, 

now along with number of project task I need to show some fields like customer and environment which are present in parent project form of this project task (project form have fields customer and environment and project record have children project task) so now when I look for project task number by searching if customer and environment values are present in its parent project it should be shown. 
please guide me on this.

Thanks & regards,

Sanath K.

[Ankur Bawiskar · Accepted solution]

@sanathk 

try to add those in variable attributes

give the correct field which refers to project and correct field names for customer and environment

ref_ac_columns=number;parent.u_customer;parent.u_environment,ref_auto_completer=AJAXTableCompleter,ref_ac_columns_search=true,

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

[sanathk]

Hi  @Ankur Bawiskar @Pooja58 Thanks for your help

Actually, number field is from task table, By OOB it is display value is true. but some how it is showing short description when selected, short description is also from task table and its display value is false.

[Ankur Bawiskar · Accepted solution]

@sanathk 

there should be dictionary override for short_description field which is on task table

There should be record like this in dictionary override related list which is Overriding the display value

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

[sanathk]

Hi @Ankur Bawiskar ,

Yes got it , Thankyou
Thanks & regards,

sanath K

[Ankur Bawiskar]

@sanathk 

that's not possible. OOB whichever field is marked as Display=true that will be shown once record is selected

If you want short description then that field needs to be made Display=true at dictionary level and I won't recommend that as it's a platform change

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