News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Forum: Get Reply Count

Customer experience | Sales, Customer Insights,...

Unanswered

Forum: Get Reply Count

(0) Share

Report

Report

Posted on by Brandon O

10

I have created four entities for the board of my company to vote: Board Thread, Board Vote Options, Board Thread Vote, and Board Thread Reply. I have gotten the vote count by joining Board Thread and Board Thread Vote and incrementing through the results to add up the counts. Obviously this is far from efficient especially since I have to add the Reply count as well. Would anyone have a better solution to this? Something similar to SQL join having Count(*).

I am using C# and Microsoft.Xrm.Tooling.Connector.CrmServiceClient to query the CRM. Any suggestions would be greatly appreciated!

All responses Img

All responses (1)

Answers Img

Answers (0)

Brandon O 10 on at

Like (0)

Report

RE: Forum: Get Reply Count

I should mention the Board Thread is the main entity that everything is connected from. Board Vote Options and Board Thread Vote are also connected but nothing else is connected.

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

Holly Huffman 103

#2

Muhammad Shahzad Sh... 96 Most Valuable Professional

#3

Gerardo Rentería Ga... 51 Most Valuable Professional

Last month Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans