Odoo Help


How to search float fields in v7 without Advanced Search? [Closed]

on 2/27/13, 2:40 AM 2,836 views

The Question has been closed

on 12/18/2013 09:31:44

I want to search records by some float value.

For example,
I want to search invoices, which have total 10000.00 So how can I search invoices by entering float values?

Please any suggestions appreciated.

You have following options: 1. Add the field into search panel. 2. Use advanced search. 3. Override search() to make your search extensive.

Serpent Consulting Services Pvt. Ltd.
on 4/4/13, 6:13 PM

It is still not working.Even float field is added in search panel it is not showing results only characters field are showing results.It is not proper way to override search method just to add a float field in search panel, in version 6.0 it was easy to add field in search panel, it fetches the proper result accordingly but in v7 it only consider a character field.And I am sorry I want it without using advanced search.

on 4/11/13, 7:27 AM

Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 4/13/13, 8:32 PM

This is a bug.

A fix was supplied on March 28th in revision 3869 of the web branch, but this hasn't yet made it into the core code.

[FIX] web: int/float fields were not offering auto-completion in search views, making *them un-searchable except via advanced search.

Added the missing complete() function and removed the incorrect value_from() override that seemed to be a leftover remnant of the 6.1 search field implementation ofg et_value(), wrongly renamed for 7.0.

I encountered this same problem today, and applying the DIFF resolved it.

I can now add float fields to the search view as we could before and users can now apply their search string to them.

The order of the fields determines the order of the options in the Search X For: dropdown. If TOTAL is the field you want to search by first (by default if the user does not make a selection) then it needs to be the first field in the view.

Ray Carnes
on 4/14/13, 12:26 AM

The fix for this bug was merged at revision 3901 of the 7.0 openerp-web branch. It should be available in nightly build as of tomorrow.

Olivier Dony (odo)
on 4/18/13, 9:22 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 2/27/13, 2:40 AM
Seen: 2836 times
Last updated: 3/16/15, 8:10 AM