I need to do rollup values from the standard Task object to my custom Project object. Apparently the Declarative Lookup Rollup Summary doesn’t work with recurring tasks.

So now I’d like to use the Child Relationship multiple times with differing conditions in order to get Task Counts for each scenario. ie. Overdue Tasks, Total Hours Completed (rollup on custom field), etc.

I’d have to make use of a snippet to do anything other than a count, but no big deal.

I’m figuring that this something that isn’t possible with Salesforce SOQL.

I don’t otherwise have a solution, unless I go to custom apex, which I’d clearly like to avoid.

Anybody have an idea?