Pivot Domain does not allow "uid" to be used as a value

[ASBaj]

Module

spreadsheet_oca

Describe the bug

In Odoo Enterprise, when you insert a pivot table into a spreadsheet this is filtered by "user_id = uid", this works and is reflected in the pivot's domain. It does not appear to work here.

To Reproduce

Affected versions:

Steps to reproduce the behavior:

1. Navigate to a module that allows you to filter by "My", e.g. "My Tickets"
2. Insert that Pivot view into the spreadsheet
3. The pivot for the domain will show "Assigned User" is set to your actual user ID, instead of "uid", and as such, the number won't be dynamic.

Expected behavior
The pivot domain should be set to "uid", and the number reflected should change depending on the user.

Additional context
Add any other context about the problem here. (e.g. OS, Python version, ...)

[pedrobaeza]

Odoo version?

[ASBaj]

Odoo 18.

[ASBaj]

I guess more generically, the spreadsheet domains don't allow expressions to be used. For example, in Odoo Enterprise, I could do:

["&", "&", ("write_date", "<", (context_today() - datetime.timedelta(days = 2)).strftime("%Y-%m-%d")), ("stage_id.fold", "=", False), ("stage_id", "not in", [8, 3, 4, 7, 5, 6])]

for my domain, and the spreadsheet would reflect the data. It does not appear the domains in spreadsheet_oca support these expressions.

[CarlosRoca13]

Hi @ASBaj I have added a PR to solve this: #97

[ASBaj]

That's amazing, thank you! I'll give it a test when I get a chance and let you know how it goes.

[ASBaj]

Pulled #97 and tested it. It works! For anyone else wanting to use this functionality, I did find I had to set the domain on a user-defined filter rather than on the Window Action, and to do that, I did have to edit the DB directly and paste my non-literal domain in (the write_date one I mentioned above). But once I did that, the domain came across to the spreadsheet nicely. Thanks again @CarlosRoca13 and @pedrobaeza !

[CarlosRoca13]

You can approve the PR then 😄

To merge it faster