function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Babar Hussain 4Babar 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
Best Answer chosen by Babar Hussain 4
SwethaSwetha (Salesforce Developers) 
HI Babar,
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

SwethaSwetha (Salesforce Developers) 
HI Babar,
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
This was selected as the best answer
Babar Hussain 4Babar Hussain 4
use that as one of the conditions in flow filter to get all events pertaining to account

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 emailAccording to that 2 conditions , which fields do I need to select