title: JPA SELECT from a list
body: <p>I am not seem to be able to run this simple query. I have a list of ids and I want to retrieve all the rows with this id from db.</p>
  
  <pre><code> List&lt;String&gt; uniqueIds is my list.
  </code></pre>
  
  <p>I have tried <code>String q = "SELECT item FROM Tenant item WHERE item.id IN (:"+uniqueIds+")";</code></p>
  
  <p>I have also tried this without : and (). Non of them worked. What am I doing wrong. I also tried for (String uniqueId : uniqueIds) {
          in += uniqueId + ",";
      }</p>
  
  <p>and used "in" as well!</p>
  
  <p>Thanks.</p>