Hello,

I'm using a COQL query to retrieve the Deal_Name from the Deals module where it matches a particular Account Id and has 1 of 4 ids in a lookup field.  I've created a list variable with the ids I'm wanting to match the lookup field to, but am failing at writing that part of the where statement.  Basically, something like this:

(the lookup field is not really called lookupfield just being generic for simplicity)

acctId = 5555;
idList = {1234,2345,3456,4567};

queryMap = ("select_query","select Deal_Name, lookupfield from Deals where (Account_Name = ' " + acctId + " ')  and (lookupfield in ' " + idList + " ') " );

The error I get is:

{"code":"INVALID_QUERY","details":{"column_name":"lookupfield"},"message":"value given seems to be invalid for the column","status":"error"}

If I remove the and (lookupfield in ' " + idList + " ') from the query, I get all of the information, including the id that is in the lookup field.