0 Replies Latest reply on Mar 27, 2009 11:46 AM by Karin Schellner

    list in WHERE clause using EntityQuery and RESTRICTIONS

    Karin Schellner Newbie


      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!