How can I display # of opportunities owned by each user on a VF page?

Question

Hello,

I would like to create a table for one of my visualforce pages that would show the number of opportunities owned by each user.

I know how to list them, is there a simple way of counting them?

I apologize for the broad, general question - but I am staring from scratch here.

Thanks,

John

Jeff Stevens (JeffreyDStevens.com) · Accepted Answer

Use aggregrateResult and count.

List<aggregateResult> opptysAR = [SELECT ownerId oid, COUNT(id) opptyCount FROM Opportunity ORDER BY ownerId GROUP BY ownerId];
For (AggregateResult ar :opptysAR) {
    system.debug('OwnerId, count= ' + ar.get('oid') + ' ' + ar.get('opptyCount'); 
}

Not sure if that's correct on the syntax - but it would be close.

John Neff · Answer

thanks Jeff!  I was able to make it work!

How can I display # of opportunities owned by each user on a VF page?

Visualforce

相关学习

更多帮助