How to filter contact those parent are in archive stage

Question

Hi All,
I created some contacts with their child contacts.
Image [1]
Now to some of the parent companies are in archive state but their childs are in active state.
I want get the child's those parents are archive state.

[1] data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABM8AAAI9CAYAAAAtnV/mAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAALehSURBVHhe7N17XJV1ou/xL94wTSg0DOUiKoiOJ2IyY4rUMLSZYu/RTeVRy8wyp0Yni2zmJNOewc6UOdloOmaZlekxZXLvjV2UZNTQqGwTblKUBEGEwEuBWaLoOn+s27Me1sNFARE/

Jaideep · Accepted Answer

Use the custom filter Related Company > Active > Not set
[("parent_id.active", "=", False)]
image [1]

[1] /web/image/81689698-a5c66db3/image.png?access_token=795f84f1-ccea-4bba-839b-1dea0aa5d19b

Post correlati	Risposte	Visualizzazioni
Simultaneous search criteria across companies and persons Risolto filter	1 ott 25	632
Extended "shop" controller executes (confirmed by log), but the view ignores the modified "qcontext" (even with request.render) filter	3 ott 25	636
Differentiating subscription invoices from one-shot services Risolto filter	3 set 25	835
Having to manually clear filters in Odoo version 18 on the webstore shop makes us lose customers filter	0 lug 25	1408
Filters in multiple companies Risolto filter	1 mag 25	2170

La domanda è stata contrassegnata

Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!