LightningFlowComponents
LightningFlowComponents copied to clipboard
Execute SOQL Query - supports date/time
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.