[Vtigercrm-developers] Reports logic structure

[Tony Sandman]

No Uma, I checking Leads. Lead is the parent record. I want to extract
Leads which dont have emails with subject test123 :-)
Not show all leads and all their emails but without those with mentioned
subject (even their exists)
The real state of relation needs visualization: Does Lead have related
record or not... Not show me Lead but without specific record.


T






On Tue, Jan 7, 2020 at 12:18 PM Uma S <uma.s at vtiger.com> wrote:

> Hi Tony,
>
> The response is right, As your checking for email with subject that not
> contains "test321". So it's listing CompanyX with email "test123".
>
> Please let me know your thoughts on this working model?
>
> On Tue, Jan 7, 2020 at 4:01 AM Tony Sandman <tonysandman999 at gmail.com>
> wrote:
>
>> Conditions on related module showing ONLY records of related module
>> without respecting parent module.
>> So if I have organization X to where I send only one email with subject:
>> test123
>> Applying condition does not contain "test321" will show anyway company X
>> and its email: test123
>>
>> Logically it shouldn't show in such report company X, as there is no
>> email with subject "test321"
>> Am I right?
>>
>>
>> T
>>
>> On Mon, Jan 6, 2020 at 3:09 PM Uma S <uma.s at vtiger.com> wrote:
>>
>>> Hi Tony,
>>>
>>> Applying the condition on Related Emails module Subject field with "does
>>> not contain" filter will list down the results right?
>>>
>>> On Sun, Jan 5, 2020 at 7:29 AM Tony Sandman <tonysandman999 at gmail.com>
>>> wrote:
>>>
>>>> Wandering around reports and cannot get basic config to extract as
>>>> follows:
>>>> Find all LEADS which have NO related EMAIL with certain SUBJECT
>>>>
>>>> The point is whatever module is set primary, the conditions itself
>>>> determining what will be shown.
>>>> Anyone meet such an issue?
>>>> By the way what is the reasonable alternative to native Reports, where
>>>> I can get "clickable" results?
>>>>
>>>> T.
>>>> _______________________________________________
>>>> http://www.vtiger.com/
>>>
>>>
>>>
>>> --
>>> With
>>> Best Regards
>>> Uma.S
>>> Vtiger Team
>>> _______________________________________________
>>> http://www.vtiger.com/
>>
>> _______________________________________________
>> http://www.vtiger.com/
>
>
>
> --
> With
> Best Regards
> Uma.S
> Vtiger Team
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200108/52821035/attachment.html>