Find contacts where user has not created a note using advanced find

(0) Share

Report

Posted on by KVa

293

Dear community,

I am trying to find all contacts where a specific user has not created a note. I am able to find contact where Notes generally exist or not exist, but I cannot find contacts where notes exist and a user did not create one of them.

Any chance to make that work with Advanced Find?

I have the same question (0)

All responses (7)

Answers (1)

Oana Cozma on at

Like (0)

Report

Hi Kiril,

Have you tried the following filters yet:

I have tested this in a vanilla and was able to bring up Contacts that Notes were created but not by a specific user.

Please let me know if this is the query you are using.

Regards,

Oana

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Kiril,

I'm afraid it's not doable using Advanced Find but you can work around it. In order to achieve your goal do following:

1. Create a Marketing List with "Contact" type.

2. Use "Add Contacts based on Query" to add contacts there based on advanced find query "Contacts with existing notes".

3. Use "Remove Contacts based on Query" to remove contacts based on advanced find query "Contacts with notes created by a particular user".

Once 3 steps are completed your marketing list will contain contacts that you're looking for.

Was this reply helpful? Yes No
Verified answer

scr1pt 130 on at

Like (1)

Report
You can use custom FetchXML:

See the example below. It show contacts, which have notes created by specific user, but not having the note with subject note2

Was this reply helpful? Yes No
KVa 293 on at

Like (0)

Report
[quote user="scr1pt"]
You can use custom FetchXML:

See the example below. It show contacts, which have notes created by specific user, but not having the note with subject note2

Fullscreen
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true" >
<entity name="contact" >
<attribute name="fullname" />
<attribute name="emailaddress1" />
<attribute name="statecode" />
<attribute name="mobilephone" />
<attribute name="birthdate" />
<attribute name="contactid" />
<filter type="and" >
<condition entityname="ae" attribute="annotationid" operator="null" />
</filter>
<link-entity name="annotation" from="objectid" to="contactid" link-type="outer" alias="ae" >
<filter type="and" >
<condition attribute="createdby" operator="eq" value="{E97D3BF3-C7B4-E811-A957-000D3AB49645}" uiname="First, CrmUser" uitype="systemuser" />
<condition attribute="subject" operator="like" value="%note2%" />
</filter>
</link-entity>
<link-entity name="annotation" from="objectid" to="contactid" link-type="inner" >
<filter type="and" >
<condition attribute="createdby" operator="eq" value="e97d3bf3-c7b4-e811-a957-000d3ab49645" uiname="First, CrmUser" uitype="systemuser" />
</filter>
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true" > <entity name="contact" > <attribute name="fullname" /> <attribute name="emailaddress1" /> <attribute name="statecode" /> <attribute name="mobilephone" /> <attribute name="birthdate" /> <attribute name="contactid" /> <filter type="and" > <condition entityname="ae" attribute="annotationid" operator="null" /> </filter> <link-entity name="annotation" from="objectid" to="contactid" link-type="outer" alias="ae" > <filter type="and" > <condition attribute="createdby" operator="eq" value="{E97D3BF3-C7B4-E811-A957-000D3AB49645}" uiname="First, CrmUser" uitype="systemuser" /> <condition attribute="subject" operator="like" value="%note2%" /> </filter> </link-entity> <link-entity name="annotation" from="objectid" to="contactid" link-type="inner" > <filter type="and" > <condition attribute="createdby" operator="eq" value="e97d3bf3-c7b4-e811-a957-000d3ab49645" uiname="First, CrmUser" uitype="systemuser" /> </filter> </link-entity> </entity> </fetch>
[/quote]
Thank you. Is it possible to create a System view using FetchXML, and show it in Dynamics?

Was this reply helpful? Yes No
KVa 293 on at

Like (0)

Report

[quote user="Oana Cozma"]
Hi Kiril,

Have you tried the following filters yet:

I have tested this in a vanilla and was able to bring up Contacts that Notes were created but not by a specific user.

Please let me know if this is the query you are using.

Regards,

Oana
[/quote]
Unfortunately, this will leave out Contacts without Notes.

Was this reply helpful? Yes No
scr1pt 130 on at

Like (0)

Report

Yes, you can create this view with View Designer + FetchXMLBuilder plugins for XRMToolbox.

But you will not be able to edit this view from Advanced find or solutions designer.

Was this reply helpful? Yes No
KVa 293 on at

Like (0)

Report

Thanks, will give it a try.

Was this reply helpful? Yes No