How can I display a hierarchical locations in one field?

salmezy
Giga Contributor

I would like to create a location field in the incident form where people can select the location of the issue. I have populated the location table utilizing the chilled-parent location relationship in the following hierarchy "Cite > Building > Floor > Room"

find_real_file.png

However, if I do it this way selecting Room will only show room in the location field and the not the full hierarchy. I'm trying to achieve this as we need to have the full location information in the incident form to export it as PDF.

find_real_file.png

 

Is there a way to concatenate the full locations based on the heretical relation. Disabling tree picker still does not help.

The following is the final output of what we are trying to achieve. 

find_real_file.png

 

1 ACCEPTED SOLUTION

Tushar Sharma2
Kilo Guru

Hello salmezy,

Try with below approach its working at my end.

step1 : Navigate to system definition->Dictionary
step2 : In the list view open the record whose Table = "cmn_location" and Column name = "full_name".
step3 : check dispaly field and save the record.

Let me know if still location field on the incident is not showing the parent-child name.

find_real_file.png

View solution in original post

2 REPLIES 2

Tushar Sharma2
Kilo Guru

Hello salmezy,

Try with below approach its working at my end.

step1 : Navigate to system definition->Dictionary
step2 : In the list view open the record whose Table = "cmn_location" and Column name = "full_name".
step3 : check dispaly field and save the record.

Let me know if still location field on the incident is not showing the parent-child name.

find_real_file.png

Worked like charm thank you!

Out put looks like:

find_real_file.png