Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
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 .
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.
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?
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.
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?