wh += getStringPredicate("ji.APPLICATION", query.getInstanceApplication(), prms);
wh += getStringPredicate("ji.MODULE", query.getInstanceModule(), prms);
wh += getStringPredicate("ji.KEYWORD1", query.getInstanceKeyword1(), prms);
wh += getStringPredicate("ji.KEYWORD2", query.getInstanceKeyword2(), prms);
wh += getStringPredicate("ji.KEYWORD3", query.getInstanceKeyword3(), prms);
wh += getStringPredicate("ji.USERNAME", query.getUser(), prms);
wh += getStringPredicate("ji.SESSION_KEY", query.getSessionId(), prms);
wh += getStatusPredicate("ji.STATUS", query.getStatus(), prms);
wh += getStringPredicate("jd.JD_KEY", query.getApplicationName(), prms);
wh += getStringPredicate("jd.APPLICATION", query.getJobDefApplication(), prms);
wh += getStringPredicate("jd.MODULE", query.getJobDefModule(), prms);
wh += getStringPredicate("jd.KEYWORD1", query.getJobDefKeyword1(), prms);
wh += getStringPredicate("jd.KEYWORD2", query.getJobDefKeyword2(), prms);
wh += getStringPredicate("jd.KEYWORD3", query.getJobDefKeyword3(), prms);
wh += getStringPredicate("n.NAME", query.getNodeName(), prms);
wh += getStringPredicate("q.NAME", query.getQueueName(), prms);
wh += getIntPredicate("q.ID", query.getQueueId() == null ? null : query.getQueueId(), prms);
wh += getStringPredicate("INSTANCE_APPLICATION", query.getInstanceApplication(), prms);
wh += getStringPredicate("INSTANCE_MODULE", query.getInstanceModule(), prms);
wh += getStringPredicate("INSTANCE_KEYWORD1", query.getInstanceKeyword1(), prms);
wh += getStringPredicate("INSTANCE_KEYWORD2", query.getInstanceKeyword2(), prms);
wh += getStringPredicate("INSTANCE_KEYWORD3", query.getInstanceKeyword3(), prms);
wh += getStringPredicate("USERNAME", query.getUser(), prms);
wh += getStringPredicate("SESSION_KEY", query.getSessionId(), prms);
wh += getStatusPredicate("STATUS", query.getStatus(), prms);