问如何为下面给出的查询编写Java CriteriaBuilder

EN

SELECT c FROM UserTransaction c WHERE  c.status in ('M', 'P') AND
instr(c.idNumber,:idNum) > 0 order by c.userI

CriteriaBuilder cb = em.getCriteriaBuilder();
ParameterExpression<String> idnumParameter = cb.parameter(String.class, idNum);
ParameterExpression<Integer> numberParameter = cb.parameter(Integer.class)       

CriteriaQuery<UserTransaction > cq = cb.createQuery(UserTransaction .class);
Root<UsasTransaction> postRoot = cq.from(UserTransaction .class);

Predicate predicateInM    = cb.equal(postRoot.get("status"),"M");
Predicate predicateInP    = cb.equal(postRoot.get("status"),"P");
Predicate predicateStatus = cb.or(predicateInM, predicateInP);

Predicate predicateInstr  = (Predicate) cb.function("INSTR", Boolean.class, postRoot.get("idNumber"), idnumParameter );
Predicate predicateGt     = cb.gt(predicateInstr, 0);