2012-06-15 07:34:25 |
Yannick Vaucher @ Camptocamp |
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 ignore 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 |
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 |
|