You need to sign in to do that
Don't have an account?
Babar Hussain 4
Using developer console
how to write query for event object where it storing record in backend in dev console?
Can anyone share the query how we check in developer console
Can anyone share the query how we check in developer console
You can try below SOQL
SELECT Id,WhatId FROM Event WHERE What.Type IN ('Opportunity')
Related: https://salesforce.stackexchange.com/questions/321248/in-a-soql-query-for-event-is-it-possible-to-filter-by-an-field-related-through
If this information helps, please mark the answer as best. Thank you
All Answers
You can try below SOQL
SELECT Id,WhatId FROM Event WHERE What.Type IN ('Opportunity')
Related: https://salesforce.stackexchange.com/questions/321248/in-a-soql-query-for-event-is-it-possible-to-filter-by-an-field-related-through
If this information helps, please mark the answer as best. Thank you
2 conditions u need to set in flow for get records data element
End date = $flow.currentdate
whatid contains '001'
if u could see all account record ids starts with the prefix '001' hence we are using that as our leverage in flow to filter events related to accounts that expires today
Once u get all events, then in flow u have to loop throw and call email action to send reminder email