Skip to Content
Menu
This question has been flagged
1 Reply
15104 Views

When I start typing in the search box of my contact list OpenERP suggests me companies that contain the letters I have already typed. How can add other fields like for e.g. city to this autocomplete functionality?

I already created the following inherited view

<?xml version="1.0"?>
<filter string="Country" position="after">
<filter string="City" context="{'group_by': 'city'}"/>
<field name="street" filter_domain="[('street','ilike',self)]"/>
<field name="zip" filter_domain="[('zip','ilike',self)]"/>
<field name="city" filter_domain="[('city','ilike',self)]"/>
<field name="comment" filter_domain="[('comment','ilike',self)]"/>
</filter>

This allows to search the fields street, zip, city and comment. But you have to select manually that you want to search in this field. It not automatically suggests you content from this fields. For example when I type in "Brux" I can selext to search for "Brux" in the city field but it does not suggest me "Bruxelles". If I would have a company in the database with the name "Bruxelles Best S.A." it would automatically suggest me this company.

Avatar
Discard
Author

image description

Here is an example. I type "Bru" in the search view and it suggest me two companies that contain "bru". I want the same suggestion for the city.

Note that it's not suggesting "Companies", it's suggesting "Related Companies" (parent_id many2one field). You would have the same effect for "City" if it were a many2one instead of a text box. You can confirm this by adding the "country_id" field to the Search View: since it's a many2one, it will show expanded descriptions.

Best Answer

That's defined on the Search View. Activate de Developer Mode, go to Sales » Customers and then:

  • In the "Debug View combobox, select "Edit Search View". This will bring you a dialog window with the Search's XML structure.r
  • After <field name="name" ... add new line with: <field name="city"/>

Save, and that's it: you just made the "City" field searchable. Reload the Customers view and try it.

Avatar
Discard
Author

Thanks for the quick answer. I have already created an inherited view that allows to search the fields (see update of my question). This allows to search the fields street, zip, city and comment. But you have to select manually that you want to search in this field. It not automatically suggests you content from this fields. For example when I type in "Brux" I can selext to search for "Brux" in the city field but it does not suggest me "Bruxelles". If I would have a company in the database with the name "Bruxelles Best S.A." it would automatically suggest me this company.

I don't see the point for that behaviour in the search box. Maybe you mean the search feature on a form field, such as the "Customer" field on "Opportunity" form ? You want that to suggest results also based on other Customer fields?

Author

I added a screenshoot to explain my point. Please see comment below.

Related Posts Replies Views Activity
1
Feb 25
668
0
Sep 23
1769
2
Jun 23
3441
1
Aug 22
12062
4
Nov 20
5726