I am unable to search with multiple values for Location reference field on Incident form

[Bhupathi Reddy]

I have Location reference field, when i wanted to search with multiple colmns of Location on the Location field on Incident form it is not given results.
My requirement is like, when i entered some information in the location field then it needs to display all the matches(Ex: If Location search list is displayed with Pin code, State, District then if i enter any value of these then it needs to display all the matches) found on Location table

Here Location field dictionary attributes are (ref_ac_columns=roles;type;manager;name,ref_ac_columns_search=true,ref_auto_completer=AJAXTableCompleter) but it is not working on my PDI, please anyone help me on that to get this sorted.

[Brad Bowman · Accepted solution]

The Location field exists on the Task table, so you need to check the Dictionary Overrides related list on the Dictionary Entry to see if there is a record for the Incident table with the Override attributes box checked.  It sounds like there is since the ref_ac_columns given in your Location field dictionary attributes don't match your example of location fields that are displayed and what you want to search on.  Make sure the Attributes in the override contains the correct ref_ac_column field names that you want to have displayed, and includes ref_ac_columns=true.  Also be sure you are using an asterisk (*) when searching, for example *goa to return location records that have a district of goa.  

[Bhupathi Reddy]

Hi Brad,

I have updated the Override dictionary then it is working for all the fields but if I reverted back then it is working only for a few fields. In the below code if i reverted back(tree_picker=false) then it is only working for the u_site_reference;name;street but not for the ZIP that is the post cade name

edge_encryption_enabled=true,encode_utf8=false,ref_ac_columns=zip;u_site_reference;name;street,ref_ac_columns_search=true,ref_auto_completer=AJAXTableCompleter,tree_picker=true