[Vtigercrm-developers] Reports logic structure

[Phasaphon Kwanrutai]

> Does Lead have related record or not... Not show me Lead but without
specific record.

Tony is right, it should be like filtering related list. Now is not like
that.
If Parent record dont have related record with conditions in place, report
should not show parent record. Before was trying to get it working
but without success. Client took 3rd party extension for that...



On Wed, Jan 8, 2020 at 12:32 PM Tony Sandman <tonysandman999 at gmail.com>
wrote:

> 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/
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200113/1eabdc64/attachment.html>