Invalid field chain when Edit Filter

[zalei-odoo]

Greetings, using odoo16 I can’t use the filter for the spreadsheet.dashboard model in any way - please clarify - is this a bug or a limitation that requires the purchase of Enterprice version of odoo 16?
odoo16 version:
commit d84d41d7559b94f5195fb9b888149b8f30616172 (grafted, HEAD -> 16.0, origin/HEAD, origin/16.0)
Author: Rmi Rahir (rar) [email protected]
Date: Fri Jun 2 10:15:39 2023 +0000
spreadsheet version:
commit db8bcbe (HEAD -> 16.0, origin/HEAD, origin/16.0)
Author: Sandrine (ACSONE) [email protected]
Date: Thu May 25 09:49:15 2023 +0000

When selecting a field from the pop-up list and saving the parameters, it is possible to select filter values, but they are not applied to the spreadsheet table.

If this is not a limitation or a bug, please explain how to get around this error?

P.S. I apologize for the drawings, but I think I can explain it more clearly.

[etobella]

It works properly on runboat and locally, I am unable to see how you created the bug.

[zalei-odoo]

I don't started runbot (I have never used it and I doubt that runbot caters for this situation), Locally:

1. Create new database with Demo data.
2. Activate Purchase module.
   
3. Activate Spreadsheet Oca module.
   
4. Create spreadsheet from menu "Spreadsheets" by clicking "New" button (type "test1" in field name and click "Save manually").
   Now I have empty spreadsheet with name "test1".
5. In purchase.order pivot view click button "Add to spreadsheet" and select created spreadsheet with name "test1".
   
   Then I can't apply filter by selecting "File - Filters" and clicking some button "Add date", "Add relation" or "Add text" - this situation I describe in my first comment. I see an error triangle with an exclamation point "Invalid field chain".

Probably I do something wrong, help me please, if so...

[zalei-odoo]

etobella - Thank you for Pull request #14. I already tried to test it's changes - the "Invalid field chain" error really disappeared, but when changing the filter values (date, relation or text), the data in the spreadsheet still does not filtered.

One more moment - when, after saving the filter, again click on the gear to edit the properties - the selected earlier field in the filter is empty again.

[zalei-odoo]

@etobella Thank you!

[vuongdz247]

etobella - Thank you for Pull request #14. I already tried to test it's changes - the "Invalid field chain" error really disappeared, but when changing the filter values (date, relation or text), the data in the spreadsheet still does not filtered.

One more moment - when, after saving the filter, again click on the gear to edit the properties - the selected earlier field in the filter is empty again.

It's not working for me. Please help me ....

[vuongdz247]

etobella - Thank you for Pull request #14. I already tried to test it's changes - the "Invalid field chain" error really disappeared, but when changing the filter values (date, relation or text), the data in the spreadsheet still does not filtered.
One more moment - when, after saving the filter, again click on the gear to edit the properties - the selected earlier field in the filter is empty again.

It's not working for me. Please help me ....

@zalei-odoo ,
@etobella

[etobella]

It does not work in which way ? @vuongdz247

[etobella]

Try again with the new changes...