Odoo Addons (MOVED TO GITHUB)

How to search invoices with the same tax_line

Asked by OpenBMS JSC

I want to filter all invoices that share the same taxes rates(tax_line having the same tax_codes). What is the most efficient way to do in ORM as I can see that the number of invoices can be large and looping through each will be slow?

The extension of this is: is it possible to use o2m as filter in search/read function of OSV?

Question information

Language:
English Edit question
Status:
Solved
For:
Odoo Addons (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Solved by:
OpenBMS JSC
Solved:
Last query:
Last reply:
Revision history for this message
OpenBMS JSC (openbmsjsc) said : 		#1

I've found a solution for this with ORM, but I think for large dataset, it might have better performance if using customed SQL statement (although the statement could be quite complicated).