Search() returns inactive records too

(empty description)

assigned to @ced

added project + 1 deleted label

Patch : review1741002

added 1 deleted label and removed 1 deleted label

Please don't assign issue!

unassigned @ced

How to reproduce:

1) Install the timesheet module
2) Open "Works" view available with menu "Timesheet -> Configuration -> Works ->
Works"
3) Create two records (fill only name & company, active is enabled by defaut)
4) Using tree view, check there are two records
5) set the first record inactive: edit the first created record, unckeck the
'active' checkbox, save the modification
6) Using tree view, check there is one record -> NOK no one is displayed

Bugs identified by review1741002, work in progress patch in review2251002.

It seems the problem come from that there are two records with identical left
and right values (see Many2One doc:
http://doc.tryton.org/3.0/trytond/doc/ref/models/fields.html?highlight=many2one#trytond.model.fields.Many2One),
so the query with "child_of" operator used in Work.write
(http://hg.tryton.org/modules/timesheet/file/843beb67b34b/work.py#l167) returns
incorrect value.

Left and right values are identical because _rebuild_tree
(http://hg.tryton.org/trytond/file/5832eee069fe/trytond/model/modelsql.py#l1073)
ignore inactive records.

assigned to @pilou_2

added 1 deleted label and removed project + 1 deleted label

Please test this review2401002 that's used plain SQL query.

assigned to @ced and unassigned @pilou_2

added trytond + 1 deleted label and removed 1 deleted label

New changeset 597e24b340da by C?dric Krier in branch 'default':
Fix _rebuild_tree to take in account inactive records
http://hg.tryton.org/trytond/rev/597e24b340da

added 1 deleted label and removed 1 deleted label

closed

mentioned in issue #3554 (closed)