25
Is it possible to count how many "Knows" connections a contact has using the Advance Find function? I'd like to report how many contacts only have 1 connection.
*This post is locked for comments
Thanks for your response - I dont know how to start a new FETCH query?
You could use FETCH query to get the count, see the example below
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true" aggregate="true" >
<entity name="connection" >
<attribute name="connectionid" aggregate="countcolumn" alias="countConnections" distinct="true" />
<filter type="and" >
<condition attribute="record1roleid" operator="eq" uiname="connetion role" uitype="connectionrole" value="{8899231D-1514-423C-A06B-BF269558200A}" />
</filter>
<link-entity name="contact" from="contactid" to="record1id" link-type="inner" alias="aa" >
<filter type="and" >
<condition attribute="contactid" operator="eq" uiname="contact name" uitype="contact" value="{25A17064-1AE7-E611-80F4-E0071B661F01}" />
</filter>
</link-entity>
</entity>
</fetch>
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...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (