[Vtigercrm-developers] "is empty" criteria for related modules - not working in 7.x?

[Steve Kenow]

Coming back to this, I found a distinguishing factor - when the criteria
field is a picklist, the 'is empty' doesn't work. It does work for other
field types. To get around this, set the operator to 'not equal to' and
then select all the options in the value field.

*[image: RDS Logo]*
*Steve Kenow*
Manager, End-User Services and Support - RDS MN
<https://www.rdspos.com/Minneapolis-Minnesota-Grocery-Point-of-Sale-System>
Direct: (952) 392-2686
Office: (952) 934-4001
Email: skenow at rdspos.com

[image: Icon 1]
<https://mailtrack.io/trace/link/d5e46ac8cfdec7b8ebdc539696dd45306644b800?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGrocery&userId=3091118&signature=18b062316c510b1b>
[image:
Icon 2]
<https://mailtrack.io/trace/link/b0fdfdd837e0d187e174cae0c9479c9b847c4e36?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FQuick-Service%2FPoint-of-Sale-Solutions&userId=3091118&signature=b26cf2b23255a2a2>
[image:
Icon 3]
<https://mailtrack.io/trace/link/9c1116af49d5de3a851b38185dbd7ba07d27def2?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRestaurant%2FPoint-of-Sale-Solutions&userId=3091118&signature=78db9a7d4392c7ed>
[image:
Icon 4]
<https://mailtrack.io/trace/link/c5c6a63b04b163898650fb7e2fdd7312ca923cdf?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGeneral-Retail&userId=3091118&signature=1ec7a1d9db94a0f1>
[image:
Icon 5]
<https://mailtrack.io/trace/link/9d0a121b09b0d5e1ba1c5be04c5c2b8d969b7d2c?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FConvenience-Store%2FNCR-Radiant-Convenience-Store-POS-System&userId=3091118&signature=112f29b42fe5a787>
[image:
Icon 6]
<https://mailtrack.io/trace/link/16b4ffb1c4363203009e09666cb41ce82f3a39c1?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRDS-Payment-Services&userId=3091118&signature=84ffb1248e80fb55>
------------------------------

Support Questions/Issues? Email rdshelp at rdspos.com (non-emergencies) or
call (952) 934-4002 24/7


On Thu, Jun 8, 2023 at 10:38 AM Steve Kenow <skenow at rdspos.com> wrote:

> Finding "orphan" Contacts is not exactly hard. They have a field
>> "Organisation" and if it's empty then the Contact is an Orphan(*).
>>
>
> Well ... only if you include Organizations as a related module in the
> report configuration. If you don't include Organizations as a related
> module, all contacts are returned.
>
> The list filter does work, though.
>
> On Tue, Jun 6, 2023 at 3:34 AM Alan Lord <alanslists at gmail.com> wrote:
>
>> No,
>>
>> I was just wondering why...
>>
>> Finding "orphan" Contacts is not exactly hard. They have a field
>> "Organisation" and if it's empty then the Contact is an Orphan(*).
>>
>> You can simply create a list filter to show these. Ditto with orphan
>> Service Contracts (except "Related To" could be either a Contact or an
>> Organisation)
>>
>> Al
>>
>> * Apart from the n:n relationship in Opportunities - which is a
>> different relationship
>>
>> On 05/06/2023 21:51, Steve Kenow wrote:
>> > Contacts is the primary module and Organizations is set as a related
>> > module. Is that how I'll need to adjust?
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20240514/9e417c37/attachment.html>