I have developped a Google Apps module to generate follow up report, for specific business case.
Typically, it fetches data and organize it as per the specific business case, and it works.
However, I'd like to optimize the process, typically by reducing number of calls, and simplifying/reducing the Google Apps Script code/processing.
A practical example:
I want to display list of Purchase Orders and for each display list of associated Stock Pickings.
What I currently do:
search_read, with desired domain,
create domain based on ids received from point 1.
new search_read, with domain from point 2.
What I want:
A single query that would simulate an SQL INNER JOIN, or different kind of join.
Found some references, in PHP using ripcord (https://stackoverflow.com/questions/45877105/how-to-join-model-in-xmlrpc-using-ripcord).
Building the module inside Odoo is also an option, but not applicable in this specific setup.
Thanks in advance.