Hi everyone!
Today I tried Salesforce Connector but I’ve an issue with its filter.
I wanted to extract Cases with CreatedDate >= 2022-03-01 and I used this SOQL synthax (it works via developer console in Salesforce):
CreatedDate >= 2022-03-01T00:00:00.000+0000
But I’ve the error in the image below:
It seems that + character were ignored…
Also I would like to ask if it is possible to filter on a child object because I can’t figure out how to do it.
Thanks!
Hi @carlo.nigro !
Regarding ‘+’, thank you for reporting, we will fix it shortly!
As of filtering child objects, if I understand you correctly and you mean nested SELECTs with filters, SOQL like
SELECT Name, ( SELECT LastName FROM Contacts WHERE CreatedBy.Alias = 'x') FROM Account WHERE Industry = 'y'
then you have to use ‘Custom SOQL’ mode in the Import action for this
Hi olysak,
thanks for support!
Meanwhile I found another solution that does not consider the time-zone parameter:
we can write datetime filter like this: 2022-03-21T00:00:00Z
However, I have to report another bug: I saved the filter in a project but this morning the filter disappeared.
About your second answer ok, I will try this road.
it would still be fantastic if after composing the query, there was a section where to have the soql query and be able to modify that, as it happens in Query database section.
Hi Carlo,
Please update to the most recent version from our website. The bug with filter not saved was resolved earlier.
Thank you Dmitry, now it works perfectly!
