Your description of what you’re trying to do seems like it should work. Do you have an example of how your model is set up that could be referenced to be sure it is set up correctly? Other than an error with setting up the subquery, the only other thing I could think of that could cause this is the user running the query doesn’t have appropriate permissions.

SELECT Id FROM Account WHERE (Id in (SELECT WhatId FROM Event WHERE (((StartDateTime = THIS_QUARTER))))) LIMIT 21 Error:Entity ‘Event’ is not supported for semi join inner selects

There’s another way to do this though. Stay tuned.

K… can’t think of way to do this without using DLRS and formula fields. Somewhat janky.

1. Create a DLRS rollup from Event to Account set to Max and Aggregate by your Date.


2. Then use this date field in your Account model condition.

What is DLRS?  I cannot use a standard Rollup Summary Field as I need my date range to be dynamic and roll from quarter to quarter.  Now I could update the rollup summary fields each quarter I suppose.  I’ll give that a try, but if I am missing something else, please let me know.  Thanks so much for the response!

Declarative Lookup Rollup Summary. Great Add-on package that enables rollups on lookups. Really slick must have in every org.

https://github.com/afawcett/declarative-lookup-rollup-summaries

https://login.salesforce.com/packaging/installPackage.apexp?p0=04tb0000000MXkF

Thanks so much for the suggestion.  However, the app above has now been deprecated.  Any other ideas?

Michael - here’s the most recent package URL: https://login.salesforce.com/packaging/installPackage.apexp?p0=04t0N000000IyYr

You can find updates on the github page: https://github.com/afawcett/declarative-lookup-rollup-summaries