Location Reference Field Auto Complete

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-09-2024 10:30 AM
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)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-09-2024 11:29 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-09-2024 11:46 AM - edited ‎07-09-2024 11:46 AM
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.