Error in List Grid when Editable is top/bottom and data is filtered.

[Tech Receptives]

version is : 5.0.15

Method to reproduce a bug :

Go to Financial Management --> Reporting --> Entry Lines,

Here you will find list of all entries, just filter entries based on "Journal", for example. write "sale" in journal and click Filter.

Now edit any of the filterd record, go to Journal column and remove the current data and then try to do a search by clicking on search or pressing F2,

It should popup a list of journals but nothing is popping up, when we traced in backend it was

ProgrammingError: operator does not exist: integer ~~* unknown
LINE 1: ...HERE "name" ilike E'%%'))) AND account_journal.id ilike E'sale'

it's not only for this "journal" field but any M2O field which has been used in filtered and then attempted to change, all haveing same issue.

Web client revision : 2294
server revision : 2152
Addons revision : 2880

[ksh (Axelor) (ksh-axelor)]

Hello
          Hereby attaching patch for the bug, may help you.

[Tech Receptives (techreceptives)]

Hi ksh,

Thanks for the patch, it seems to be working now.

Regards,

[Sananaz (Open ERP) (sma-tiny)]

Hello,

Its fixed in stable with the revision 2947. Please update your code.

Thanks.

[Tech Receptives (techreceptives)]

this fix causes on more bug ... when domain is applied in this manner [('state','in',['draft','open','manual'])].

Please check with this condition.

Regards,
Parthiv

[Tech Receptives (techreceptives)]

Hi,

Please find the attached patch for the bug,

[Sananaz (Open ERP) (sma-tiny)]

Hello,

Now Its working fine. Please update your code.

Revision-info:
2948 <email address hidden>

[Tech Receptives (techreceptives)]

one more bug regretted ... BLUE SCREEN OF DEATH comes when clicking on partner's link in Partner Address List.

[Parthiv Patel (parthiv-patel-deactivatedaccount)]

Hi,

Please find the attached patch.

Regards,
Parthiv

[Somesh Khare (somesh.khare)]

Hello Parthiv,

I have tested your scenario at my end with the latest code but I was unable to meet with the error.

Please update your code and notify us if u face the problem again.

Thanks.