gistfile1.txt

    Calendar cal = Calendar.getInstance();
        cal.add(Calendar.DAY_OF_YEAR, -30);
        Date d = cal.getTime();

        Map<String, Object> params = new HashMap<String, Object>();
        params.put("date", d);

        List<Space> spaceWrapper= queryManager.runSelect("select distinct space"
                + " from com.teamhub.models.action.Action action"
                + " inner join action.spaces space"
                + " where action.actionDate > :date"
                + " group by space"
                + " order by COUNT(DISTINCT action.id) desc ", params, 10);