[14.0] web_advanced_search: Error when filtering account is equal to

[mailenrojasvergel]

When we attempt to use the module through the route: Accounting => journal items => add custom filter => account => is equal to instead of the expected behavior we get an error as shown in the attached video

Module

web_advanced_search

Describe the bug

Instead of expected behavior we get an error

To Reproduce

Accounting => journal items => add custom filter => account => is equal to https://www.awesomescreenshot.com/video/11526777?key=14f0e7459504c3104fd3834ad7b4267d

Affected versions: 14.0

Steps to reproduce the behavior:

1. Accounting => journal items => add custom filter => account => is equal to

Expected behavior The custom filter must be applied on the view

In addition, if I do not try to apply that filter at first, pretendind to use e different record and getting back in it then I do not get the error as shown in this video https://www.awesomescreenshot.com/video/11527169?key=5ce066b1d2e399fef91791c25a0131e1

[pedrobaeza]

Do you have latest module code version?

[mailenrojasvergel]

I did few minutes ago a new copy of the repo for the videos

[pedrobaeza]

Please try on runboat. I see on your environment enterprise things, and this may not be compatible.

[mailenrojasvergel]

I will try, anyway it is only with this case Accounting => journal items => add custom filter => account => is equal to as I explained, if you see the second screenshot with that performance works properly, it is an empty database the one that I used for videos but it works same way on the enviroment that we have seen the issue

[oscars8a]

Hi @pedrobaeza The error is also occurring in the runbot In this video and runbot I replicate de issue

http://oca-web-14-0-ee01676373b7.runboat.odoo-community.org/web?debug=1#action=194&model=account.move.line&view_type=list&cids=1&menu_id=101

https://www.awesomescreenshot.com/video/11527835?key=e194d61a4d0a4406c9d86e5dbe393675

[pedrobaeza]

OK, then this issue is kept opened documenting it.

[sergiocorato]

I have the same issue filtering account.move on invoice_user_id with a equal to or not equal to operator.

A workaround is to select another field and the operator to use, then change the field to invoice_user_id.

Bug is raised here, as field is undefined: https://github.com/OCA/web/blob/9bd63dd24ae7c8f8eb9eefd0078b9e19b55cf0cb/web_advanced_search/static/src/js/relational.js#L38