Hierarchy for location field issue

[Anish9515]

In my form department reference field that is referred to custom department field that is u_department 

I'm unable to see hierarchy when i click on department field
In configure dictionary for department field I have added in attributes (tree_picker=true)

Is there any properties are enable to see hierarchy for custom table

Could you please help me on this issue?

[JP - Kyndryl]

Hi Anish,

In your u_department custom table,  did you define a Parent field referencing the u_department table and also having attribute tree_picker=true ?    Did you populate values on every parent records to constitute the hierarchy ?

[Anish9515]

In u_department table parent field refers to cmn_department table
I don't what to changes on parent field 

@Ankur Bawiskar 

[Sandeep Rajput]

@Anish9515 Ideally tree_picker=true should do the trick for you. Also, are you using any reference qualifier on your department field. 

Keep in mind, when utilizing the tree picker on fields that have reference qualifiers, there is a notable pitfall that needs to be avoided. When creating the reference qualifier to only show specific values, you must take care to include all parent values of values you want to include.

Source: https://pathwayscg.com/tree-picker-in-servicenow/

[Anish9515]

For example , I have created on PDI on below screen shot

In Reference refer to hierarchy table I have created new one table (u_hierarchy)
There is no reference qualifier in my configure

added to true_picker==true on attribute tab

In Hierarchy table parent field is referred to cmn_location

In incident form there is location field it's referred to u_hierarchy table
Whenever user clicks on location field hierarchy should visible

Could you help me on this issue 

Note: - In my location field refers to "u_hierarchy" , In hierarchy table parent field refers to "cmn_location"