Reference qualifier to show field values of parent record

sanathk
Tera Expert

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.

 

2 ACCEPTED SOLUTIONS

Ankur Bawiskar
Tera Patron
Tera Patron

@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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

@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

AnkurBawiskar_1-1739951668857.png

 

 

AnkurBawiskar_0-1739951636824.png

 

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

8 REPLIES 8

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.

@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

AnkurBawiskar_1-1739951668857.png

 

 

AnkurBawiskar_0-1739951636824.png

 

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi @Ankur Bawiskar ,

Yes got it , Thankyou
Thanks & regards,

sanath K

@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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader