Location Reference Field Auto Complete

Colin Wilson
Giga Guru

When searching for a location that is in the middle of our location hierarchy, the results returned don't include that middle location reference, only the most base child records. Employing wild cards such as '=' and '%' do not return a middle of the hierarchy location either. How do I make it so the Auto Complete on the location reference field will allow you to select  something in the middle of a location hierarchy?

 

For example: Take a fictional room '10 Colosseum.'

Our location hierarchy is as follows: Building Region > Building Geographical Location > Building > Floor > Room.

The full name of this location would be as follows: 'Italy/Rome/Colosseum/First Floor Colosseum/10 Colosseum', with the name of the record having the value '10 Colosseum'

 

If i wanted to set on a location record the Building record, i'm unable to do so unless i open up the tree picker, or the expanded search magnifying glass (if the tree picker is disabled).

 

'=Colosseum' returns no results in the autocomplete

'Colosseum' returns '10 Colosseum', '11 Colosseum', ' 12 Colosseum' etc, but it only shows all the rooms and not the building (or floors). 

'Colosseum%' returns the same as searching for 'Colosseum' without a wildcard. ( i would have expected this to not show this)

2 REPLIES 2

SanjivMeher
Kilo Patron
Kilo Patron

What do you have in your reference qualifier and variable attribute?


Please mark this response as correct or helpful if it assisted you with your question.

Attribute: no_audit=true,readonly_clickthrough=true,edge_encryption_enabled=true,tree_picker=true
Reference Qualifier: Hierarchy Type  | is one of | Building Region, Building Geographical Location, Building, Floor, Room. 

Hierarchy Type (u_hierarchy_type) is a custom field we added on to cmn_location. It is a choice list containing only those values. All location records we import from our source of truth system have one of those 5 values set on them.