query.field(filtersDTO.getName()).equal(value1); break; query.field(filtersDTO.getName()).notEqual(value1); break; query.field(filtersDTO.getName()).containsIgnoreCase(value1.toString()); break; query.field(filtersDTO.getName()).greaterThanOrEq(value1); query.field(filtersDTO.getName()).lessThanOrEq(value2); break; query.field(filtersDTO.getName()).lessThan(value1); break; query.field(filtersDTO.getName()).lessThanOrEq(value1); break; query.field(filtersDTO.getName()).greaterThan(value1); break; query.field(filtersDTO.getName()).greaterThanOrEq(value1); break; query.field(filtersDTO.getName()).exists(); break; query.field(filtersDTO.getName()).doesNotExist();
public <T extends DbBackedBuild> Iterable<T> getCurrentUserBuildsGreaterThan(final DbBackedProject project, final int number) { final List<DbBackedBuild> builds = getQuery(project) .order("-number") .field("pusher").equal(Jenkins.getAuthentication().getName()) .field("number").greaterThan(number) .asList(); for (final DbBackedBuild build : builds) { associateProject(project, build); } return (Iterable<T>) builds; }
public DynamicSubProject getChild(final IdentifableItemGroup<DynamicSubProject> parent, final String name) { final DynamicSubProject subProject = getDatastore().createQuery(DynamicSubProject.class). disableValidation(). field("name").equal(name). field("parentId").exists(). field("parentId").equal(parent.getId()). get(); if (subProject != null) { try { subProject.onLoad(parent, name); } catch (final IOException e) { throw new RuntimeException(e); } } return subProject; }
public DbBackedBuild getPreviousFinishedBuildOfSameBranch(final DbBackedBuild build, final String branch) { final DbBackedProject project = (DbBackedProject) build.getProject(); final Query<DbBackedBuild> query = getQuery(project); if (branch != null) filterExpression(branch, query); final DbBackedBuild previousBuild = query. limit(1). order("-number"). field("state").equal("COMPLETED").field("number").lessThan(build.getNumber()). get(); associateProject(project, previousBuild); return previousBuild; }
switch(date) { case TODAY: { query.field(insertedOnDate).containsIgnoreCase(LocalDate.now().format(DateTimeFormatter.ISO_DATE)); query.field(insertedOnDate).containsIgnoreCase(LocalDate.now().minusDays(1).format(DateTimeFormatter.ISO_DATE)); query.field(insertedOnDate).greaterThanOrEq(week.get("first").format(DateTimeFormatter.ISO_DATE)); query.field(insertedOnDate).lessThanOrEq(week.get("last").format(DateTimeFormatter.ISO_DATE)); break; query.field(insertedOnDate).greaterThanOrEq(week.get("first").format(DateTimeFormatter.ISO_DATE)); query.field(insertedOnDate).lessThanOrEq(week.get("last").format(DateTimeFormatter.ISO_DATE)); break; query.field(insertedOnDate).containsIgnoreCase(CalendarUtils.yearAndMonth(LocalDate.now())); break; query.field(insertedOnDate).containsIgnoreCase(CalendarUtils.yearAndMonth(LocalDate.now().minusMonths(1))); break;
@Override public Long count(List<String> searchFields, String keywords, String where) { Query<?> q = ds().createQuery(clazz); if (keywords != null && !keywords.equals("")) { List<Criteria> cl = new ArrayList<Criteria>(); String[] sa = keywords.split("[\\W]+"); for (String f : fillSearchFieldsIfEmpty_(searchFields)) { for (String s : sa) { cl.add(q.criteria(f).containsIgnoreCase(keywords)); } } q.or(cl.toArray(new Criteria[]{})); } processWhere(q, where); return q.countAll(); }
/** * finds job by date ranges * @param createdBefore date - "Includes the day listed", example: "2016-08-08T18:04:23.514Z" * @param createdAfter date - "Includes the day listed", example: "2016-08-08T18:04:23.514Z" * @return List of LGJob items found */ public List<LGJob> getAllByDateRange(Date createdBefore, Date createdAfter) { Query<LGJob> query; if ((createdBefore != null) && (createdAfter == null) ) { query = getDatastore().createQuery(LGJob.class) .field("createDate").lessThanOrEq(createdBefore); } else if ((createdBefore == null) && (createdAfter != null)) { query = getDatastore().createQuery(LGJob.class) .field("createDate").greaterThanOrEq(createdAfter); } else { query = getDatastore().createQuery(LGJob.class) .filter("createDate <=", createdBefore) .filter("createDate >=", createdAfter); } return query.asList(); }
public <B extends DbBackedBuild<P, B>, P extends DbBackedProject<P, B>> B getNextBuild(final DbBackedProject<P, B> project, final int number) { final DbBackedBuild build = getQuery(project). field("number").greaterThan(number).order("number"). get(); if (build != null) { associateProject(project, build); } return (B) build; } }
public <T extends DbBackedBuild> Iterable<T> getBuildGreaterThan(final DbBackedProject project, final int number, final String branch) { Query<DbBackedBuild> query = getQuery(project).order("number") .field("number").greaterThan(number) .order("-number"); if (branch != null) { query = query.field("actions.causes.branch.branch").equal(branch); } final List<DbBackedBuild> builds = query.asList(); for (final DbBackedBuild build : builds) { associateProject(project, build); } return (Iterable<T>) query.asList(); }
public Iterable<DynamicSubProject> getChildren(final DynamicProject parent) { final List<DynamicSubProject> children = getDatastore().createQuery(DynamicSubProject.class). disableValidation(). field("parentId").exists(). field("parentId").equal(parent.getId()). asList(); for (final DynamicSubProject subProject : children) { try { subProject.onLoad(parent, subProject.getName()); } catch (final IOException e) { throw new RuntimeException(e); } } return children; }
@Override public List<play.db.Model> fetch(int offset, int size, String orderBy, String order, List<String> searchFields, String keywords, String where) { if (orderBy == null) orderBy = keyName(); if ("DESC".equalsIgnoreCase(order)) orderBy = null == orderBy ? null : "-" + orderBy; Query<? extends Model> q = ds().createQuery(clazz).offset(offset) .limit(size); if (null != orderBy) q = q.order(orderBy); if (keywords != null && !keywords.equals("")) { List<Criteria> cl = new ArrayList<Criteria>(); String[] sa = keywords.split("[\\W]+"); for (String f : fillSearchFieldsIfEmpty_(searchFields)) { List<Criteria> cl0 = new ArrayList<Criteria>(); for (String s : sa) { cl0.add(q.criteria(f).containsIgnoreCase(s)); } cl.add(q.and(cl0.toArray(new Criteria[]{}))); } q.or(cl.toArray(new Criteria[]{})); } processWhere(q, where); List<play.db.Model> l = new ArrayList<play.db.Model>(); l.addAll(q.asList()); return l; }
query.criteria("name").containsIgnoreCase(filter.getFilter()), query.criteria("description").containsIgnoreCase(filter.getFilter()) );
private Query<JobPo> addCondition(Query<JobPo> query, String field, Object o) { if (!checkCondition(o)) { return query; } query.field(field).equal(o); return query; }
private Query<JobPo> addCondition(Query<JobPo> query, String field, Object o) { if (!checkCondition(o)) { return query; } query.field(field).equal(o); return query; }