Add support for ALL ROWS

[afawcett]

As per Chatter group discussion...

Hi All! Does anyone happen to know if there's a way to reference “ALL ROWS” in the relationship criteria?

Just ran into an issue with counting the number of tasks and realized that Salesforce archives older activities, including:

Events with a due date greater than 365 days old
Closed tasks with a due date greater than 365 days old
Closed tasks without a due date that were created more than 365 days ago

https://developer.salesforce.com/forums/?id=906F00000008xJqIAI

Someone in the above thread suggested adding “IsDeleted = false LIMIT 1000 ALL ROWS ” to a query to solve the issue; however, I haven't managed to successfully use it in the Relationship Criteria field.

Cheers,
Carolyn

[afawcett]

Another use case...

"First of all, thanks for this wonderful tool !
I'm currently trying rollups on task and event but i can't find a way to include archived activities in the result count (tried ALL ROWS in the relationshipcriteria but it does not work).
Any idea to achieve this ?"

[afawcett]

[afawcett]

Added in v2.4.1.

[cbprice25]

AMAZING! :)