protected void applySelect(CriteriaQuery query, String select) { if (Strings.equals("*", select)) { return; } EntityMapping em = query.getEntityMapping(); String[] names = Strings.split(select, ','); List<String> fields = new ArrayList<>(); for (String name : names) { FieldMapping p = em.tryGetFieldMapping(name); if (null == p) { throw new BadRequestException("Property '" + name + "' not exists, check the 'select' query param"); } fields.add(p.getFieldName()); } if (null != excludedFields) { for (String name : excludedFields) { fields.remove(name); } } query.select(fields.toArray(new String[fields.size()])); }
query.select(fields.toArray(new String[fields.size()]));
protected Record queryOneRemoteTarget(Object id, QueryOptionsBase options) { String[] fields = Arrays.stream(rm.getJoinFields()) .map(joinField -> joinField.getLocalFieldName()) .toArray(String[]::new); Record record = dao.createCriteriaQuery(em).select(fields).whereById(id).firstOrNull(); if (null == record) { throw new BadRequestException("Record " + em.getEntityName() + "(" + id + ") not found"); } Object targetId = CrudUtils.getSingleOrMap(record, fields); if (null == targetId) { return null; } return iqe.queryOne(targetId, options).record; }
protected QueryListResult queryListEmbedded(Object id, QueryOptions options) { Record record = dao.createCriteriaQuery(em).whereById(id).select(rm.getEmbeddedFileName()).firstOrNull(); if (null == record) { throw new BadRequestException("Record " + em.getEntityName() + "(" + id + ") not found"); } Set<Object> embeddedIds = new HashSet<>(); iqe.calcIdsByEmbeddedField(embeddedIds, record, rm.getEmbeddedFileName()); if (embeddedIds.isEmpty()) { return QueryListResult.EMPTY; } return iqe.queryListByIds(embeddedIds, options); }
query.select(fields.toArray(new String[fields.size()]));
query.select(select.toArray(new String[select.size()]));
expandQuery.select("*", Strings.format("_jt_.{0} as {1}", referredFieldName, referredFieldAlias)); } else { referredFieldAlias = referredFieldName;
protected void init() { log.info("Finding the max value of field '{}' at entity '{}'...", fm.getFieldName(), em.getEntityName()); Object maxValue = dao.createCriteriaQuery(em) .select(fm.getFieldName()) .limit(1) .orderBy(fm.getFieldName() + " desc") .scalarValueOrNull(); log.info("Max value : {}", maxValue); if(null != maxValue) { this.maxValue = maxValue; } changesQuery = dao.createCriteriaQuery(em, resultClass) .where(fm.getFieldName() + " > :maxValue") .limit(limit) .orderBy(fm.getFieldName() + " asc"); }