What is the difference between "self.filtered" and "self.filtered_domain"?

Question

I have seen both used in the code, and I am wondering what the difference is.

This is what I see in the documentation:
Image [2]

https://www.odoo.com/documentation/17.0/developer/reference/backend/orm.html [1]

[1] https://www.odoo.com/documentation/17.0/developer/reference/backend/orm.html
[2] data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAwQAAAG0CAYAAACMruC+AAAgAElEQVR4XuydDViW5d3/v//pAeV/OFs4e9C1iDpQ20hbJIVKsvDtwTBRmoBTsBSpBHsCV4E9CdWASnAL0QbYBFkoFskjKBMnScPhktjjC8dCekHSJ9yYd492c+j+/995vdx

Ray Carnes (ray) · Accepted Answer

*self.filtered(*/*func*/*)*

*self.filtered_domain(*/*domain*/*)*

Filters a recordset based on a Python function Requires all records to be retrieved from the database so they can be evaluated by the function /Used when filtering can't be done with a domain/ Slower for large datasets, less scalable   Filters a recordset based on an ORM domain Filtering done in PostgreSQL, only returning those records that match the domain Faster for large datasets, more scalable
Use *self.filtered_domain* where

self.filtered(func)	self.filtered_domain(domain)
Filters a recordset based on a Python function Requires all records to be retrieved from the database so they can be evaluated by the function Used when filtering can't be done with a domain Slower for large datasets, less scalable	Filters a recordset based on an ORM domain Filtering done in PostgreSQL, only returning those records that match the domain Faster for large datasets, more scalable

Related Posts	Replies	Views
Odoo 15 - "name 'self' is not defined" in xml domain Solved domain xml self	2 Apr 24	4254
Odoo 17 Pos Js development 17.0	1 Aug 25	1775
How can I make the cost field on products readonly? Solved 17.0	2 Aug 25	371
naked domain set up Solved domain	3 Jul 25	4482
Domain name Request domain	0 May 25	955

This question has been flagged

Enjoying the discussion? Don't just read, join in!