[6.1] advanced filter on empty fields
Bug #1013528 reported by
Yannick Vaucher @ Camptocamp
This bug affects 2 people
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Odoo Web (MOVED TO GITHUB) |
Fix Released
|
Undecided
|
OpenERP Publisher's Warranty Team | ||
| 6.1 |
Fix Released
|
Undecided
|
Unassigned | ||
Bug Description
Using advanced filters
There is no option to filter on empty fields.
In a list you cannot get all entries with a specific field that have no value defined.
As anything you enter in the text box will be a string it will be as an exemple my_field ILIKE 'False' if you try to seach for False values.
Plus, you cannot make many filters with somethink like my_field NOT ILIKE '%' neither as NULL value are ignored as it cannot be compared with string.
So, we need an option "is empty" in advanced filter contition (with no text field beside as we do not need to specify on)
And this fields need to make a search [('my_field', '=', False)]
Regards,
Yannick
Related branches
lp:~openerp-dev/openerp-web/7.0-filter-empty-fields-xmo
- OpenERP Core Team: Pending requested
-
Diff: 133 lines (+49/-10)1 file modifiedaddons/web/static/src/js/search.js (+49/-10)
| description: | updated |
| Changed in openerp-web: | |
| assignee: | nobody → OpenERP Publisher's Warranty Team (openerp-opw) |
| tags: | added: maintenance |
Revision history for this message
| Xavier (Open ERP) (xmo-deactivatedaccount) wrote | #1 |
| Changed in openerp-web: | |
| status: | New → Fix Released |
To post a comment you must log in.
Issue should be fixed in 6.1 branch as of revision <email address hidden>
Two new operators were added to the list of operators available in advanced search on all fields except boolean (as those are the only operators available for it):
* `is set`, generates a `(field, '!=', False)` domain section
* `is not set`, generates a `(field, '=', False)` domain section
These can not be translated yet as traductions have not been extracted, but we will try to do so shortly.