String sSubQuery = "SELECT SUM(om.originalSize), MAX(om.lastModified) "+ "FROM "+ "ObjectMetadata om "+ "WHERE om.informationStoreId = :informationStoreDefinitionID "+ "GROUP BY om.path, om.originalSize"; Query q = getEm().createQuery(sQuery); q.addParameter("informationStoreDefinitionID",22);
... List<WorkflowTask> workflowTasks=Arrays.asList({WorkflowTask.CONFIRMATION, WorkflowTask.PAYMENT WorkflowTask.ISSUING }); ... Query q = em.createQuery(buffer.toString()); q.addParameter("workflowTasks", workflowTasks);
/** * Gets the first repetition for <b>parameter</b> (Set of query parameters with values), * creating it if it does not already exist. * * <p> * <b>Definition:</b> * * </p> */ public ExtensionDt getParameterFirstRep() { if (getParameter().isEmpty()) { return addParameter(); } return getParameter().get(0); }