Location Reference Field Auto Complete

[Colin Wilson]

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)

[SanjivMeher]

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

[Colin Wilson]

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.