You need to sign in to do that
Don't have an account?
Interfaces Divalto
Event not found via SOQL despite it's displayed on Salesforce
Hello salesforce developpers!
I have an understanding issue with events/activities in Salesforce: I must insert event data in salesforce from an ERP using Talend.
During Talend insertion, I see the processed IDs in the logs. When searching for this ID by typing "https://eu5.salesforce.com/<ID>", I see the corresponding event and all its details. Seems fine.
However, when searching in developper console (SOQL) like this:
... No event found.
Could someone explain to me why I do not see the event in console? is it stored in another table? (i've also searched in Activity table without much success).
Best regards, and thanks in advance!
I have an understanding issue with events/activities in Salesforce: I must insert event data in salesforce from an ERP using Talend.
During Talend insertion, I see the processed IDs in the logs. When searching for this ID by typing "https://eu5.salesforce.com/<ID>", I see the corresponding event and all its details. Seems fine.
However, when searching in developper console (SOQL) like this:
Select Id, Subject from event where Id = '<ID>'
... No event found.
Could someone explain to me why I do not see the event in console? is it stored in another table? (i've also searched in Activity table without much success).
Best regards, and thanks in advance!
After executing your query in Developer Console, please click on 'Refresh Grid' button there.(See screenshot)
Please let me know how this works for you, mark this as Solved if this helps you so that others can view it as a proper solution.
Thanks,
Apoorv
Thanks for your reply.
I have tried to click on 'Refresh Grid' button, however there is still no data. ("Query Results - Total Rows: 0")
For information, the data has been inserted several weeks ago, and is still visible in the Salesforce GUI.
Are the ID in the URL and the ID in the event table not the same maybe?
Regards
Could you please share a screenshot of an Event open in your salesforce instance and SOQL for the same, so that I might be able to resolve this issue.
The one on the GUI where we can see the ID in the URL:
And the one in the dev console:
That's strange. Seems like some kind of a bug.
Try changing filter criteria, something like :
Select id,subject from event where subject like '%A%'
Let me know how it works out for you.
I've some data (95 lines), however the corresponding ID (00U24000009mX38) is not there. Don't know if it helps, but there is some IDs that are similar but the end is different (like 00U24000009mXH9EAM , 00U24000009mXI2EAM ...).
Up!
I'm still stuck on this problem.
Any help to understand why Events IDs are not found in the event table? Am I missing something?
best regards
I was having a similar problem with my Visualforce page. It turns out because the page and controller where using an older API version prior to the release of Lightning repeating Tasks/Events they were not being returned in the query.
Simply updating the API version (e.g to 46) on both the visualforce page and apex controller resolved the issue and now the query is returning the repeating events.
You can increase this time frame limit through support if needed: https://help.salesforce.com/articleView?id=000328570&language=en_US&type=1&mode=1