Re: Orm Query for this type of situation

2019-06-07 Thread Devender Kumar
Hi, On this question only I took some step deep and able to find out one part and need your help on the second half. This requires a good understanding of Django annotation and subquery features If you have this thank for reading and helping me in advance I am facing problem to filter calls on acco

Re: Orm Query for this type of situation

2019-06-06 Thread Devender Kumar
Account /Lead Model account_name contact m2m realtion contact Model name phone No calls Model caller no # person phone no who is calling agent no # person who is picking the call (CRM user) status timestamp duration calls model is populated with so

Re: Orm Query for this type of situation

2019-06-06 Thread Chetan Ganji
Right now its an open ended question. If you post code for your models here, someone can help you. On Thu, Jun 6, 2019, 4:38 PM Devender Kumar wrote: > Hi, > I am working on CRM project and stuck with REPORTING part. > > I have Accounts , Lead , contact, Calls ,Concern modules > account/Lead ca

Orm Query for this type of situation

2019-06-06 Thread Devender Kumar
Hi, I am working on CRM project and stuck with REPORTING part. I have Accounts , Lead , contact, Calls ,Concern modules account/Lead can have multiple contacts contacts have multiple calls and concerns calls have different status like Incoming outgoing missed call etc Question I need to create