Skip to Content
Menu
This question has been flagged
2 Replies
2210 Views

Hello everyone 🖐🏻 

I am currently working on building a dashboard that is fed by the opportunities hosted in the CRM. I am retrieving the information through the API, obtaining the data from the crm.leads table. However, I was surprised that missed opportunities do not appear in that table. As I found on the internet, it is possible that the information of the lost opportunities is stored in the crm.leads.lost table, but I couldn’t find them in the table file either. 

Can someone help me, indicating how I could find the information of the lost leads?

 I will appreciate your help 🙏

Avatar
Discard
Best Answer

you can see in filters >>archived section

Avatar
Discard
Best Answer

Hi,

Please try the below code to get the lost leadsmodel = self.env['crm.lead'].search(
            [('type', '=', 'opportunity'), ('active', '=', False), ('probability', '=', 0)])


Hope it helps

Avatar
Discard
Related Posts Replies Views Activity
2
Sep 24
2173
0
Nov 23
2039
1
Oct 20
6714
0
Dec 23
1117
1
Jul 23
3304