0 Replies Latest reply on Mar 27, 2009 11:46 AM by kashia.karin.schellner.lixto.com

    list in WHERE clause using EntityQuery and RESTRICTIONS

    kashia.karin.schellner.lixto.com

      Hi,


      how could I achieve an SQL WHERE something IN (1,3,6) with Seam EntityQuery and RESTRICTIONS.
      Trying to do it the following way was not successful:



      private static final Expressions.ValueExpression[] RESTRICTIONS =
      {
          Expressions.instance().createValueExpression("job.jobstatus IN (#{jobFilterCriteria.jobStatusListAsIds})")    
      };




      (the method jobStatusListAsIds returns a List of type Integer)


      I would appreciate any help!


      thanks,
      karin