I inserted my pivot report in odoo spreadsheet, but it is not updating automatically. And when i click data -> Refresh all data, not updating.
Diese Frage wurde gekennzeichnet
5
Antworten
5421
Ansichten
I found a solution to this issue.
**Root cause**: When inserting a list into a spreadsheet, Odoo hardcodes the IDs of the records present at the time of insertion into the list domain (e.g. `[('id', 'in', [1, 2])]`). This means that refreshing or re-inserting the list will always return the same records, regardless of any new ones matching your original filter. This is in my opinion a bug.
**Solution**: Manually fix the domain in the list properties.
1. Open your spreadsheet
2. Go to **Data → Spreadsheet properties** (or click on the list, then open its properties)
3. Find the **Domain** field of your list — you will see the hardcoded IDs
4. Delete that domain entirely
5. Recreate the correct filter manually
6. Save and refresh
After this, refreshing the spreadsheet will correctly return all records matching your filter, including newly created ones.
Hope this helps!
It seems like quite a few people make this mistake!
I have the same issue. Did you find any solution?
I inserted a CRM pivot table into a spreadsheet to add it to the dashboard, but some values inside the table are not refreshing. I also tried to do a manual refresh, but it didn't help. The only thing that helped was inserting a new pivot table into spreadsheets, but it doesn't make any sense when it should be automatic.
I'm curious how there is still this bug after 5 months. Does nobody use dashboards in Odoo?
Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!
Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!
Registrieren| Verknüpfte Beiträge | Antworten | Ansichten | Aktivität | |
|---|---|---|---|---|
|
0
März 26
|
2 | ||
|
2
März 26
|
5302 |
