Example usage for org.springframework.data.mongodb.core.query Query sort

Introduction

In this page you can find the example usage for org.springframework.data.mongodb.core.query Query sort.

Prototype

Sort sort

To view the source code for org.springframework.data.mongodb.core.query Query sort.

Click Source Link

Usage

From source file:net.cit.tetrad.utility.QueryUtils.java

public static Query setGroupname(String groupnm) {
    Query query = new Query();
    if (!Utility.isNull(groupnm).equals(""))
        query.addCriteria(Criteria.where("groupname").is(groupnm));
    query.sort().on("groupname", Order.ASCENDING);
    return query;
}

---

From source file:net.cit.tetrad.utility.QueryUtils.java

/**
 * date, alarm, confirm?  sort? //from  w w  w  . j  av a 2  s  .  com
 */
public static Query setAlarmSort(CommonDto dto) {
    Query query = new Query();
    if (dto.getAlarm() != 0)
        query.addCriteria(Criteria.where("alarm").is(dto.getAlarm()));
    query.addCriteria(Criteria.where("confirm").is(0));
    query.sort().on("confirm", Order.ASCENDING);
    query.sort().on("alarm", Order.ASCENDING);
    query.sort().on("up_date", Order.DESCENDING);
    query.sort().on("up_time", Order.DESCENDING);
    return query;
}

---

From source file:net.cit.tetrad.utility.QueryUtils.java

public static Query sortDate(int auth, int userCode, String tablenm) {
    Query query = new Query();
    if (tablenm.equals("user")) {
        Criteria c = new Criteria();
        c.orOperator(Criteria.where("idx").is(userCode), Criteria.where("authority").lt(auth));
        query.addCriteria(c);//from   ww  w  .  ja  va2s .co m
        query.sort().on("authority", Order.DESCENDING);
    }
    query.sort().on("reg_date", Order.DESCENDING);
    query.sort().on("groupCode", Order.ASCENDING);
    query.sort().on("deviceCode", Order.ASCENDING);
    query.sort().on("reg_date", Order.DESCENDING);
    return query;
}

---

From source file:net.cit.tetrad.utility.QueryUtils.java

public static Query setGroupCode(CommonDto dto) {
    Query query = new Query();
    if (dto.getGroupCode() != 0)
        query.addCriteria(Criteria.where("groupCode").is(dto.getGroupCode()));
    if (!Utility.isNull(dto.getType()).equals(""))
        query.addCriteria(Criteria.where("type").is(dto.getType()));

    if (!Utility.isNull(dto.getSort()).equals("")) {
        if (Utility.isNull(dto.getSort()).equals("asc")) {
            query.sort().on(dto.getSortItem(), Order.ASCENDING);
        } else if (Utility.isNull(dto.getSort()).equals("desc")) {
            query.sort().on(dto.getSortItem(), Order.DESCENDING);
        }// ww  w.  j a  va  2 s  . c om
    }
    return query;
}

---

From source file:net.cit.tetrad.utility.QueryUtils.java

public static Query setAlarmSearch(CommonDto dto) {
    Query query = new Query();
    if (!Utility.isNull(dto.getSdate()).equals("") && !Utility.isNull(dto.getEdate()).equals(""))
        query.addCriteria(Criteria.where("up_date").gte(dto.getSdate()).lte(dto.getEdate()));
    if (dto.getAlarm() != 4)
        query.addCriteria(Criteria.where("alarm").is(dto.getAlarm()));
    if (dto.getDeviceCode() != 0)
        query.addCriteria(Criteria.where("deviceCode").is(dto.getDeviceCode()));
    if (dto.getGroupCode() != 0)
        query.addCriteria(Criteria.where("groupCode").is(dto.getGroupCode()));
    if (!Utility.isNull(dto.getType()).equals(""))
        query.addCriteria(Criteria.where("type").is(dto.getType()));
    if (dto.getConfirm() != 2)
        query.addCriteria(Criteria.where("confirm").is(dto.getConfirm()));
    query.sort().on("confirm", Order.ASCENDING);
    query.sort().on("alarm", Order.ASCENDING);
    query.sort().on("up_date", Order.DESCENDING);
    query.sort().on("up_time", Order.DESCENDING);
    return query;
}

---

From source file:com.skymobi.monitor.model.LogQueryTest.java

public void test_query() throws Exception {

    assertEquals("{ }", query.toQuery().toString());
    query.setStart("2012-06-08 10:00:00");

    assertEquals("{ \"timestamp\" : { \"$gt\" : { \"$date\" : \"2012-06-08T02:00:00.000Z\"}}}",
            query.toQuery().toString());
    query.setEnd("2012-06-08 11:00:00");
    query.setLevel("ERROR");
    query.setKeyWord("111");
    System.out.println(query.toQuery().toString());

    Query bquery = new BasicQuery(query.toQuery());
    bquery.limit(100);/*  w ww.  ja v a 2 s .co  m*/

    bquery.sort().on("$timestamp", Order.DESCENDING);
    System.out.println(bquery.getQueryObject());
    System.out.println(bquery.getFieldsObject());
    System.out.println(bquery.getSortObject());
    //        assertEquals("{ \"timestamp\" : { \"$gt\" : { \"$date\" : \"1970-01-01T00:01:40.000Z\"}} , \"$where\" : \"this.message && this.message.match('hello')\"}",query.toQuery().toString());
}

---

From source file:org.shredzone.flufftron.repository.PersonDao.java

/**
 * Returns all {@link Person}./* w  w  w.j a v  a 2s . com*/
 *
 * @return List of all {@link Person}
 */
public List<Person> findAll() {
    Query q = new Query();
    q.sort().on("name", Order.ASCENDING);
    return mongoOperations.find(q, Person.class);
}

---

From source file:com.skymobi.monitor.service.LogsService.java

public DBCursor findLogs(String projectName, LogQuery logQuery, int max) throws ParseException {
    Project project = projectService.findProject(projectName);
    MongoTemplate template = project.fetchMongoTemplate();

    Query query = new BasicQuery(logQuery.toQuery());
    query.limit(max);/* www  .j a va 2 s . c om*/

    query.sort().on("timestamp", Order.DESCENDING);
    logger.debug("find logs from {}  by query {} by sort {}",
            new Object[] { project.getLogCollection(), query.getQueryObject(), query.getSortObject() });
    DBCursor cursor = template.getCollection(project.getLogCollection()).find(query.getQueryObject())
            .sort(query.getSortObject()).limit(max);
    return cursor;
}

---

From source file:com.skymobi.monitor.service.ProjectService.java

public List<Project> findProjects() {
    Query query = new Query();
    query.sort().on("name", Order.ASCENDING);
    List<Project> projects = mongoTemplate.find(query, Project.class, collectionName);
    return projects;
}

---

From source file:com.skymobi.monitor.service.AlertService.java

public List<Alert> findAlerts(String projectName) {
    Query query = Query.query(Criteria.where("projectName").is(projectName)).limit(50);
    query.sort().on("createTime", Order.DESCENDING);
    return mongoTemplate.find(query, Alert.class, collectionName);
}

---

• «
• 1
• 2
• 3
• 4
• »