Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Execute SOQL Query - supports date/time #1508

Open
Heartist3 opened this issue Jan 8, 2024 · 0 comments
Open

Execute SOQL Query - supports date/time #1508

Heartist3 opened this issue Jan 8, 2024 · 0 comments

Comments

@Heartist3
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant