/** * This method should only be used in unit tests. It loads all the gl_sf_balances_t rows in memory into a collection. This won't * sace for production. * * @return a Collection of all sufficient funds records in the database */ public Collection testingGetAllEntries() { LOG.debug("testingGetAllEntries() started"); Criteria criteria = new Criteria(); QueryByCriteria qbc = QueryFactory.newQuery(SufficientFundBalances.class, criteria); qbc.addOrderBy(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, true); qbc.addOrderBy(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, true); qbc.addOrderBy(KFSPropertyConstants.ACCOUNT_NUMBER, true); qbc.addOrderBy(KFSPropertyConstants.FINANCIAL_OBJECT_CODE, true); return getPersistenceBrokerTemplate().getCollectionByQuery(qbc); } }
/** * Get list of all ElectronicInvoiceItemMappings */ public List getAll() { LOG.debug("getAll() started"); QueryByCriteria qbc = new QueryByCriteria(ElectronicInvoiceItemMapping.class); qbc.addOrderBy("id", true); List l = (List) getPersistenceBrokerTemplate().getCollectionByQuery(qbc); return l; }
query.addOrderBy(mysqlPrefix + orderByColumnName, false); query.addOrderBy(orderByColumnName, ascending);
/** * @see org.kuali.kfs.pdp.dataaccess.PaymentDetailDao#getDisbursementNumberRanges(java.lang.String) */ public List<DisbursementNumberRange> getDisbursementNumberRanges(String campus) { LOG.debug("getDisbursementNumberRanges() started"); Date now = new Date(); Timestamp nowTs = new Timestamp(now.getTime()); Criteria criteria = new Criteria(); criteria.addLessOrEqualThan(PdpPropertyConstants.DISBURSEMENT_NUMBER_RANGE_START_DATE, nowTs); criteria.addEqualTo(PdpPropertyConstants.PHYS_CAMPUS_PROC_CODE, campus); criteria.addEqualTo(KFSPropertyConstants.ACTIVE, true); QueryByCriteria qbc = new QueryByCriteria(DisbursementNumberRange.class, criteria); qbc.addOrderBy(KFSPropertyConstants.BANK_CODE, true); return (List<DisbursementNumberRange>) getPersistenceBrokerTemplate().getCollectionByQuery(qbc); }
for (OrderByField orderByField : criteria.getOrderByFields()) { if (OrderDirection.ASCENDING.equals(orderByField.getOrderDirection())) { ojbQuery.addOrderBy(orderByField.getFieldName(), true); } else if (OrderDirection.DESCENDING.equals(orderByField.getOrderDirection())) { ojbQuery.addOrderBy(orderByField.getFieldName(), false);