[Python] ODOO 17 Obtain sorted query result for a customized report

In a crm.lead model I have 2 more attributes (columns) let's call col1 and col2.

How do I obtain 2 recordsets for each user like "select * from crm_records col1 desc limit 5" and the second "select * from crm_records col1 desc limit 5" in the same.

For the beginning I was trying to modify _where_calcin a an abstract where I put:

query.order = f"{self._table}.{top_field} DESC"
query.limit = top_limit


to append to the original query that comes with

query = super()._where_calc(*args, **kwargs)


but:

1. I receive all queries I put in the domain
2. It is not ordered like the way I want (only if i put sort in the filter)

Thank you in advance Claudiu

Continue reading...