Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Unanswered

Forum: Get Reply Count

Posted on by 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!

  • Brandon O Profile Picture
    Brandon O 10 on at
    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

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans