Skip to content
  • Register

    • SQL Database Where IN Query

    Unknown
    Unknown
    in Datastructures
    SQL Database Where IN Query

    Comments

    • Unknown
      Unknown

      I'm using a Query in Decisions to retrieve this data, and I have a variable in it for a list of IDs: SELECT * FROM users WHERE id IN (@_ids) when I pass a string to this parameter, like \"1,5,10\

    • Unknown
      Unknown

      It seems like we have no way of handling a string list using the Add Query screen, as the string parameter will always append the opening and closing apostrophes needed for a string value. Ive attached a flow that uses a Raw SQL step to run the query. We first create a list of IDs, then merge the ID list into a single string formatted for the SQL query.

      This will return your expected results.

    Sign In or Register to comment.

    Howdy, Stranger!

    It looks like you're new here. If you want to get involved, click one of these buttons!

    Sign In Register

    Quick Links

    Categories