LightningFlowComponents icon indicating copy to clipboard operation
LightningFlowComponents copied to clipboard

Execute SOQL Query - supports date/time

Open Heartist3 opened this issue 1 year ago • 0 comments

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:

  1. https://unofficialsf.com/a-graphical-soql-query-builder-for-flow/

  2. 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.

  3. Suggest any changes: Please clarify whether or not date time is supported and if so how can we handle it.

Heartist3 avatar Jan 08 '24 15:01 Heartist3