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.

[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  Thanks a lot, It worked 

can you please suggest me on this.  now I searched with project task number and selected it, but after selection I am getting short description filled in field, I want number to be displayed on selection.

[Ankur Bawiskar]

@sanathk 

Glad to know that it worked.

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

[Pooja58]

Hi @sanathk ,

Make project task number field as display true in dictionary, to show it when selected in reference field.

Mark it as helpful/correct if it solves your issue.

Best Regards,

Pooja