nutz groupby怎么用?

qq_412bd180

积分: 3010

这家伙很懒，什么个性签名都没有留下。

@At
	@Ok("json")
	//String sql="select distinct type from t_dict";
	public NutMap getFaultTypes() {
		List<FaultDict> list = dao.query(FaultDict.class, Cnd.where("isDeleted", "=", false).groupBy("type"));
		System.out.println();
		return NutMap.NEW().addv("typeList", list);
		
		/*Sql sql = Sqls.create("select distinct type from t_dict");
		dao.execute(sql);
		System.out.println("sql.getList(String.class):"+sql.getList(String.class));
		return NutMap.NEW().addv("typeList", sql.getList(String.class));*/
	}

提示语句不对

wendal

1楼•2701天前

https://nutz.cn/yvr/t/sfocudh31oj34ojrm40c0lqfq8

qq_412bd180 2楼•2701天前

这样写

List<Record> cmsList = dao.query("t_dict", Cnd.where("isDeleted","=","false").groupBy("type"), null, "type");

报错

qq_412bd180 3楼•2701天前

想达到这样的效果

select type from t_dict group by type;

wendal

4楼•2701天前

没有聚合函数

qq_412bd180 5楼•2701天前

这样写OK

@At
	@Ok("json")
	//String sql="select distinct type from t_dict";
	public NutMap getFaultTypes() {
		FieldFilter ff = FieldFilter.create(FaultDict.class, "^type$");
		List<FaultDict> list = Daos.ext(dao, ff).query(FaultDict.class,Cnd.where("isDeleted","=",false).groupBy("type"));
		return NutMap.NEW().addv("typeList", list);

我要是需要Id来排序呢

@At
	@Ok("json")
	//String sql="select distinct type from t_dict";
	public NutMap getFaultTypes() {
		FieldFilter ff = FieldFilter.create(FaultDict.class, "^type|id$");
		List<FaultDict> list = Daos.ext(dao, ff).query(FaultDict.class,Cnd.where("isDeleted","=",false).groupBy("type").asc("id"));
		return NutMap.NEW().addv("typeList", list);

这么写报错

wendal

6楼•2701天前

select的字段里面要有聚合函数，例如count，sum

请先登陆