433
Hi,
Is it possible to use Advanced Find to locate contacts who just have 1 Opportunity attached?
I am testing out some anonymization software here and I need to pinpoint contacts who have only 1 Opportunity with a certain status attached to the contact so that I can anonymize them. Obviously if they have several Opportunities attached, the other opportunites may have different statuses and would not require anonymization.
Thanks as always,
Ted
Hi,
I use fetchXml Builder available on XrmToolBox to replay your scenario, this is my query:
Share
Report
All responses (
Answers (
I count "In Progress" contact's opportunity.
I copy/past the result to excel with "Copy with headers" ticked. Then, I used a filter:
Hope this helps,
Hi, you could create a roll up field on the Account or Contact that rolls up everytime an opportunity is created that match your criteria, then you will be able to query that in advanced find.
Regards
Paul
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,252
Super User 2024 Season 2
#2
Martin Dráb
228,089
Most Valuable Professional
#3
nmaenpaa
101,148