Service | Customer Service, Contact Center, Fie...

Advanced find - "not equal" to, to exclude all non-matching records

(0) Share

Report

Posted on by simonsnell

119

I am working with Contacts and related Consent records. There are typically multiple consent records related to Contacts, some of which are Active and others Inactive.

I want to build a view which will show me contacts which have only Inactive Consents, and no Active consents.

Clearly if my view is Contacts where they have related consents where status=Inactive, this will not exclude those where status=Active.

However, If I build a view where the Consent status "does not equal" Active, does that mean it will find Contacts where they have:-

a) at least one Inactive Consent and NO active Consents, or

b) at least one inactive Consent and possibly other consents which are also Active?

Thanks!

I'm happy to work in FetchXML if it's easier!

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Amit Katariya007 10,409 Super User 2025 Season 2 on at

Like (0)

Report

Hello,

You can create below views as per the requirement.

1. Create a view on contact entity and add consent entity columns for the reference. The query will be "select contact(status = "Active" if u need active contact) where (from related part select the relationship with consent) consent status = inactive"

<fetch mapping='logical'>

<entity name='contact'>

<condition attribute='statecode' operator='eq' value='1' />

<attribute name='name'/>

<link-entity name='consent' to='contact field name'>

<attribute name='name'/>

<filter type='and'>

<condition attribute='statecode' operator='eq' value='1' />

</filter>

</link-entity>

</entity>

</fetch>

2. you can directly create a view on the consent entity where you can mention a condition "consent = inactive and related contact = active" (if you need active contact with the inactive consent).

<fetch mapping='logical'>

<entity name='consent'>

<condition attribute='statecode' operator='eq' value='1' />

<attribute name='name'/>

<link-entity name='contact' to='consent field name'>

<attribute name='name'/>

<filter type='and'>

<condition attribute='statecode' operator='eq' value='1' />

</filter>

</link-entity>

</entity>

</fetch>

Thank you,

Amit Katariya

Was this reply helpful? Yes No
simonsnell 119 on at

Like (0)

Report

Hi Amit

Thanks for the swift reply.

The issue is that Contacts have Active AND inactive Consents attached to their record.

Thus, the first view will find Contacts with Inactive Consents attached but also those who also have active consents attached. Similarly with the second.

I want a way to show contacts who Only have Inactive Consents and No active Consents attached to their record.

Is there a way to do this?

Thanks,

Was this reply helpful? Yes No
Suggested answer

Amit Katariya007 10,409 Super User 2025 Season 2 on at

Like (0)

Report

Hello,

Can you share the Fetch XML query which you are trying.

Thank you,

Amit Katariya

Was this reply helpful? Yes No

Join the conversation

Community site session details

Advanced find - "not equal" to, to exclude all non-matching records

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

Featured topics

Product updates

Community site session details

Advanced find - "not equal" to, to exclude all non-matching records

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

Featured topics

Product updates