function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

reg aggregate result limitation

i need to get the aggreagted result of opportunity records where there is not conitional pick up... it may go lakhs in future...but my applicaiton is running on platform......any one can help me how to pick up the records in bulk mode......

salesforce expertsalesforce expert



you can create a custom object which would populate the aggregate values for the fields which you want to aggregate. then you can query the custom object and get your data. in this way you can avoid hitting governor limits. as your new object will always contains the aggregate results.


please remember you need to use a trigger on opportunity to populate this new custom object.


am i explained to you correctly? let me know!




hope you dont get my point....I am using a vf page where i need to show the aggregated data based on one field...but there no where condition in that.. trigger will never serve me in this situtation...