Skip to main content
April 1, 2025
Question

How to pass multiple values using IN operator in salesforce SOQL Query

  • April 1, 2025
  • 3 replies
  • 0 views

Hi team ,

In SFDC integration , we are using SOQL query in operation to fetch some data for a given financial id , need to understand how to write the query to fetch data for multiple values involved.

Current implementation - concat("select Id, Name, Reference_Type__c, System__c, Seq__c from SRS_Service_Request_Related_Order__c where RO_Service_Request__c " ,"='",ri!serviceRequestNo,"'");

How to write above for fetching data for multiple financial id's involved , ri!serviceRequestNo will be of multiple type of string . Tried to replace above = with IN operator in where clause, it shows malformed SQL as integration error.

Thanks

    3 replies

    stefanhelzle0001
    April 1, 2025

    I copied your question into Google Gemini Deep Research and got great looking answers. That approach might get you started.

    stefanhelzle0001
    April 1, 2025

    I copied your question into Google Gemini Deep Research and got great looking answers. That approach might get you started.

    csteward
    April 1, 2025

    Additionally, as noted in a very similar thread, have you tried the solution which is used for the same situation in the Query DB node?

    SELECT...WHERE INSTR(ac!EmployeeIDList, ',' || empID || ',') > 0

    The Data Input for ac!EmployeeIDList is:

    ="," & joinarray(pv!employeeID, ",") & ","