public long getCount() { long result = 0; try { Dao<Promotion, String> dao = this.getController(); QueryBuilder<Promotion, String> ordersQB = dao.queryBuilder(); ordersQB.where().eq("status", 1); result = ordersQB.countOf(); } catch (SQLException e) { e.printStackTrace(); } return result; }