1

I need to get the count of Opportunity record for every User in the org where the User has atleast read access on the Opportunity record. I need to store the data obtained per User for every month in a custom object .

6
  • 3
    schedulable class on Opportunity Share, UserRecordAccess object Reporting snapshot Mar 15, 2016 at 12:36
  • What is your sharing model? OWD Private? Apex Sharing? Sharing Rules? Role Hierarchy?
    – Adrian Larson
    Mar 15, 2016 at 12:45
  • OWD is private for Opportunity. Yes, we are using Apex managed Sharing and Sharing setting to share Opportunities with Users in our org. Even Team is also being used. Mar 15, 2016 at 12:55
  • What didn't work about exporting the OpportunityShare/UserRecordAccess records? Those seem like viable strategies. Also why does it need to be a custom object? Is an export of existing data sufficient?
    – Adrian Larson
    Mar 15, 2016 at 13:04
  • I need to actually show a bar graph of opp count vs the current month for every User(who has logged in). This graph must include previous month data also. So i need to store it in a custom object or else i wont get the past data. Mar 16, 2016 at 6:43

0

You must log in to answer this question.