Aggregate query in which there will be two-level of grouping Account and Status also applying the filter of date. Consider them as Open Task: - ‘In progress’, ‘Not Started’, ‘Waiting on someone else’. For Completed Task: - ‘Completed’. Other Task maybe:- ‘Deferred’. “ On Account Object: - Create new fields: - Open Task, Completed Task,
In this assignment you have to use the Aggregate query in which there will be
two-level of grouping Account and Status also applying the filter of date.
Consider them as Open Task: - ‘In progress’, ‘Not Started’, ‘Waiting on someone else’.
For Completed Task: - ‘Completed’.
Other Task maybe:- ‘Deferred’. “
On Account Object: -
Create new fields: - Open Task, Completed Task, Total Task [All fields are Number Types].
Create Apex Class Named: ‘RollupSummary‘.
Method Details are:-
Name: ‘rollUpTaskInformations’
Method contains two Arguments: - List<Account>, Date
Argument related Info:-
List<Account>:- It will hold the account records on those we need to do the processing.
Date: - ‘DueDate’ (Field Name) of the task should be less than (<) to the passed date in the argument.
This argument is used for filtering the records.
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)