|Available in: Enterprise, Performance, and Unlimited Editions|
You can filter Async SOQL queries on any field, not just EventDate or Id. You can also use all operators, including comparison operators such as <= and =>.
Example: Get Yesterday’s Last 10 Successful Logins
SELECT Application, Browser, EventDate, UniqueKey, LoginUrl, UserId FROM LoginEvent WHERE EventDate>Yesterday LIMIT 10 AND Status=’Success’
There are limits on the number of Async SOQL queries you can run in a given period. For details, see the Async SOQL Guide (Pilot).