You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Trying to use the Execute SOQL Query action.
In the following SOQL
SELECT Id FROM Case WHERE KS_Keywords__c INCLUDES ('{!varTkeywordValue}') AND CreatedDate = {!varDtargetDate}
From the debug details:
Input: soqlQuery = {!ttSOQLquery} (SELECT Id FROM Case WHERE KS_Keywords__c INCLUDES ('EVA') AND CreatedDate = 08.01.2024, 15:02)
I receive the following error: An Apex error occurred: System.QueryException: unexpected token: .2024
Documentation issues
If your problem stems from wrong, outdated, or unclear documentation, please:
The documentation states the following:
You can make a dynamic date part of your SOQL query, taking the date from upstream in your Flow. Just insert standard mergefield syntax: myquery='[SELECT Account.Name FROM Contact WHERE startdate__c > {!myUpstreamFlowDate}]’ . Important: Note that you do not delimit the mergefield with an additional set of quote marks.
Suggest any changes: Please clarify whether or not date time is supported and if so how can we handle it.
The text was updated successfully, but these errors were encountered:
Good day to SF unofficialSF fans
Trying to use the Execute SOQL Query action.
In the following SOQL
SELECT Id FROM Case WHERE KS_Keywords__c INCLUDES ('{!varTkeywordValue}') AND CreatedDate = {!varDtargetDate}
From the debug details:
Input: soqlQuery = {!ttSOQLquery} (SELECT Id FROM Case WHERE KS_Keywords__c INCLUDES ('EVA') AND CreatedDate = 08.01.2024, 15:02)
I receive the following error: An Apex error occurred: System.QueryException: unexpected token: .2024
Documentation issues
If your problem stems from wrong, outdated, or unclear documentation, please:
https://unofficialsf.com/a-graphical-soql-query-builder-for-flow/
The documentation states the following:
You can make a dynamic date part of your SOQL query, taking the date from upstream in your Flow. Just insert standard mergefield syntax: myquery='[SELECT Account.Name FROM Contact WHERE startdate__c > {!myUpstreamFlowDate}]’ . Important: Note that you do not delimit the mergefield with an additional set of quote marks.
Suggest any changes: Please clarify whether or not date time is supported and if so how can we handle it.
The text was updated successfully, but these errors were encountered: