QueryBuilder<MerchantService, String> queryBuilder = dao.queryBuilder(); queryBuilder.orderBy(MerchantService.PURCHASE_DATE_FIELD_NAME, orderAscending); Where<MerchantService, String> where = queryBuilder.where();// search for paid or non-paid onlyif(paid !=null) { where.and( where.eq(Merchan...