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
Hi
You could download the XrmToolBox from this link : [View:https://www.xrmtoolbox.com/:750:50]
Use the FetchXMLBuilder to run the above query
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>
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
HR-09070029-0 2
ED-30091530-0 1
