本文整理汇总了Java中org.apache.ojb.broker.query.Criteria.addNotIn方法的典型用法代码示例。如果您正苦于以下问题:Java Criteria.addNotIn方法的具体用法?Java Criteria.addNotIn怎么用?Java Criteria.addNotIn使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.ojb.broker.query.Criteria
的用法示例。
在下文中一共展示了Criteria.addNotIn方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: buildNegativeCriteria
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* This method will build out criteria in the key-value paradigm (attribute-value).
*
* @param negativeFieldValues
* @return
*/
private Criteria buildNegativeCriteria(Map<String, ?> negativeFieldValues) {
Criteria criteria = new Criteria();
for (Iterator i = negativeFieldValues.entrySet().iterator(); i.hasNext();) {
Map.Entry<String, Object> e = (Map.Entry<String, Object>) i.next();
String key = e.getKey();
Object value = e.getValue();
if (value instanceof Collection) {
criteria.addNotIn(key, (Collection) value);
}
else {
criteria.addNotEqualTo(key, value);
}
}
return criteria;
}
示例2: criteriaBuilderHelper
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* This method provides the implementation for the conveniences methods criteriaBuilder & negatedCriteriaBuilder
*
* @param criteria - the criteria that might have a criterion appended
* @param name - name of the attribute
* @param collection - the collection to inspect
* @param negate - the criterion will be negated (NOT EQUALS, NOT IN) when this is true
*/
protected void criteriaBuilderHelper(Criteria criteria, String name, Collection collection, boolean negate) {
if (collection != null) {
int size = collection.size();
if (size == 1) {
if (negate) {
criteria.addNotEqualTo(name, collection.iterator().next());
}
else {
criteria.addEqualTo(name, collection.iterator().next());
}
}
if (size > 1) {
if (negate) {
criteria.addNotIn(name, collection);
}
else {
criteria.addIn(name, collection);
}
}
}
}
示例3: criteriaBuilderHelper
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* This method provides the implementation for the conveniences methods criteriaBuilder & negatedCriteriaBuilder
*
* @param criteria - the criteria that might have a criterion appended
* @param name - name of the attribute
* @param collection - the collection to inspect
* @param negate - the criterion will be negated (NOT EQUALS, NOT IN) when this is true
*/
protected void criteriaBuilderHelper(Criteria criteria, String name, Collection collection, boolean negate) {
if (collection != null) {
int size = collection.size();
if (size == 1) {
if (negate) {
criteria.addNotEqualTo(name, collection.iterator().next());
}
else {
criteria.addEqualTo(name, collection.iterator().next());
}
}
if (size > 1) {
if (negate) {
criteria.addNotIn(name, collection);
}
else {
criteria.addIn(name, collection);
}
}
}
}
示例4: findCreditMemoAccountRevisions
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* @see org.kuali.kfs.module.cab.batch.dataaccess.ExtractDao#findCreditMemoAccountHistory(org.kuali.kfs.module.cab.businessobject.BatchParameters)
*/
@Override
public Collection<CreditMemoAccountRevision> findCreditMemoAccountRevisions(BatchParameters batchParameters) {
Criteria criteria = new Criteria();
criteria.addGreaterThan(CabPropertyConstants.CreditMemoAccountRevision.ACCOUNT_REVISION_TIMESTAMP, batchParameters.getLastRunTime());
if (!batchParameters.getExcludedChartCodes().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.CreditMemoAccountRevision.CHART_OF_ACCOUNTS_CODE, batchParameters.getExcludedChartCodes());
}
if (!batchParameters.getExcludedSubFundCodes().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.CreditMemoAccountRevision.ACCOUNT_SUB_FUND_GROUP_CODE, batchParameters.getExcludedSubFundCodes());
}
if (!batchParameters.getIncludedFinancialObjectSubTypeCodes().isEmpty()) {
criteria.addIn(CabPropertyConstants.CreditMemoAccountRevision.FINANCIAL_OBJECT_FINANCIAL_OBJECT_SUB_TYPE_CODE, batchParameters.getIncludedFinancialObjectSubTypeCodes());
}
QueryByCriteria query = new QueryByCriteria(CreditMemoAccountRevision.class, criteria);
query.addOrderByAscending(CabPropertyConstants.CreditMemoAccountRevision.ACCOUNT_REVISION_TIMESTAMP);
Collection<CreditMemoAccountRevision> historyRecs = getPersistenceBrokerTemplate().getCollectionByQuery(query);
return historyRecs;
}
示例5: findPaymentRequestAccountRevisions
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* @see org.kuali.kfs.module.cab.batch.dataaccess.ExtractDao#findPaymentRequestAccountHistory(org.kuali.kfs.module.cab.businessobject.BatchParameters)
*/
@Override
public Collection<PaymentRequestAccountRevision> findPaymentRequestAccountRevisions(BatchParameters batchParameters) {
Criteria criteria = new Criteria();
criteria.addGreaterThan(CabPropertyConstants.PaymentRequestAccountRevision.ACCOUNT_REVISION_TIMESTAMP, batchParameters.getLastRunTime());
if (!batchParameters.getExcludedChartCodes().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.PaymentRequestAccountRevision.CHART_OF_ACCOUNTS_CODE, batchParameters.getExcludedChartCodes());
}
if (!batchParameters.getExcludedSubFundCodes().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.PaymentRequestAccountRevision.ACCOUNT_SUB_FUND_GROUP_CODE, batchParameters.getExcludedSubFundCodes());
}
if (!batchParameters.getIncludedFinancialObjectSubTypeCodes().isEmpty()) {
criteria.addIn(CabPropertyConstants.PaymentRequestAccountRevision.FINANCIAL_OBJECT_FINANCIAL_OBJECT_SUB_TYPE_CODE, batchParameters.getIncludedFinancialObjectSubTypeCodes());
}
QueryByCriteria query = new QueryByCriteria(PaymentRequestAccountRevision.class, criteria);
query.addOrderByAscending(CabPropertyConstants.PaymentRequestAccountRevision.ACCOUNT_REVISION_TIMESTAMP);
Collection<PaymentRequestAccountRevision> historyRecs = getPersistenceBrokerTemplate().getCollectionByQuery(query);
return historyRecs;
}
示例6: addInactivateableFromToCurrentCriteria
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* Translates criteria for current status to criteria on the active from field
*
* @param example - business object being queried on
* @param currentSearchValue - value for the current search field, should convert to boolean
* @param criteria - Criteria object being built
*/
protected void addInactivateableFromToCurrentCriteria(Object example, String currentSearchValue, Criteria criteria, Map searchValues) {
Criteria maxBeginDateCriteria = new Criteria();
Timestamp activeTimestamp = LookupUtils.getActiveDateTimestampForCriteria(searchValues);
maxBeginDateCriteria.addLessOrEqualThan(KRADPropertyConstants.ACTIVE_FROM_DATE, activeTimestamp);
List<String> groupByFieldList = dataDictionaryService.getGroupByAttributesForEffectiveDating(example
.getClass());
if (groupByFieldList == null) {
return;
}
// join back to main query with the group by fields
String[] groupBy = new String[groupByFieldList.size()];
for (int i = 0; i < groupByFieldList.size(); i++) {
String groupByField = groupByFieldList.get(i);
groupBy[i] = groupByField;
maxBeginDateCriteria.addEqualToField(groupByField, Criteria.PARENT_QUERY_PREFIX + groupByField);
}
String[] columns = new String[1];
columns[0] = "max(" + KRADPropertyConstants.ACTIVE_FROM_DATE + ")";
QueryByCriteria query = QueryFactory.newReportQuery(example.getClass(), columns, maxBeginDateCriteria, true);
query.addGroupBy(groupBy);
String currentBooleanStr = (String) (new OjbCharBooleanConversion()).javaToSql(currentSearchValue);
if (OjbCharBooleanConversion.DATABASE_BOOLEAN_TRUE_STRING_REPRESENTATION.equals(currentBooleanStr)) {
criteria.addIn(KRADPropertyConstants.ACTIVE_FROM_DATE, query);
} else if (OjbCharBooleanConversion.DATABASE_BOOLEAN_FALSE_STRING_REPRESENTATION.equals(currentBooleanStr)) {
criteria.addNotIn(KRADPropertyConstants.ACTIVE_FROM_DATE, query);
}
}
示例7: testSubQuery2
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* test Subquery get all product groups without articles
* <p/>
* test may fail if db does not support sub queries
*/
public void testSubQuery2()
{
Collection results = null;
String stamp = "" + System.currentTimeMillis();
int loops = 10;
// create ProductGroups without article
broker.beginTransaction();
for(int i = 0; i < loops; i++)
{
ProductGroup pg = new ProductGroup();
pg.setGroupName("test group " + stamp);
pg.setDescription("build by QueryTest#testSubQuery2");
broker.store(pg);
}
broker.commitTransaction();
ReportQueryByCriteria subQuery;
Criteria subCrit = new Criteria();
Criteria crit = new Criteria();
subQuery = QueryFactory.newReportQuery(Article.class, subCrit);
subQuery.setAttributes(new String[]{"productGroupId"});
subQuery.setDistinct(true);
crit.addEqualTo("groupName", "test group " + stamp);
crit.addNotIn("groupId", subQuery);
Query q = QueryFactory.newQuery(ProductGroup.class, crit);
results = broker.getCollectionByQuery(q);
assertNotNull(results);
assertEquals("Result of the query with sub-query does not match", loops, results.size());
}
示例8: findTravelAuthorizationByTraveler
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
public List<TravelAuthorizationDocument> findTravelAuthorizationByTraveler(Integer temProfileId) {
final Criteria criteria = new Criteria();
criteria.addEqualTo(TemPropertyConstants.TEM_PROFILE_ID, temProfileId);
criteria.addNotIn(KFSPropertyConstants.DOCUMENT_HEADER+"."+KFSPropertyConstants.FINANCIAL_DOCUMENT_STATUS_CODE, Arrays.asList(DocumentStatusCodes.INITIATED));
return (List<TravelAuthorizationDocument>) getPersistenceBrokerTemplate().getCollectionByQuery(new QueryByCriteria(TravelAuthorizationDocument.class, criteria));
}
示例9: buildFinancialSystemDocumentHeaderCriteria
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* @return the criteria which will be used to variously find all remaining-to-be-processed FinancialSystemDocumentHeader records
*/
protected Criteria buildFinancialSystemDocumentHeaderCriteria() {
Criteria c = new Criteria();
c.addIsNull(KFSPropertyConstants.INITIATOR_PRINCIPAL_ID);
c.addNotIn(KFSPropertyConstants.DOCUMENT_NUMBER, buildFinancialSystemDocumentHeadersWithNoWorkflowHeadersSubQuery());
return c;
}
示例10: findMatchingGLEntries
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* @see org.kuali.kfs.module.cab.batch.dataaccess.ExtractDao#findMatchingGLEntries(org.kuali.kfs.module.cab.businessobject.BatchParameters)
*/
@Override
public Collection<Entry> findMatchingGLEntries(BatchParameters batchParameters) {
Criteria criteria = new Criteria();
criteria.addGreaterThan(CabPropertyConstants.Entry.TRANSACTION_DATE_TIME_STAMP, batchParameters.getLastRunTime());
if (!batchParameters.getExcludedChartCodes().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.Entry.CHART_OF_ACCOUNTS_CODE, batchParameters.getExcludedChartCodes());
}
if (!batchParameters.getExcludedSubFundCodes().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.Entry.ACCOUNT_SUB_FUND_GROUP_CODE, batchParameters.getExcludedSubFundCodes());
}
if (!batchParameters.getIncludedFinancialBalanceTypeCodes().isEmpty()) {
criteria.addIn(CabPropertyConstants.Entry.FINANCIAL_BALANCE_TYPE_CODE, batchParameters.getIncludedFinancialBalanceTypeCodes());
}
if (!batchParameters.getIncludedFinancialObjectSubTypeCodes().isEmpty()) {
criteria.addIn(CabPropertyConstants.Entry.FINANCIAL_OBJECT_FINANCIAL_OBJECT_SUB_TYPE_CODE, batchParameters.getIncludedFinancialObjectSubTypeCodes());
}
if (!batchParameters.getExcludedFiscalPeriods().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.Entry.UNIVERSITY_FISCAL_PERIOD_CODE, batchParameters.getExcludedFiscalPeriods());
}
if (!batchParameters.getExcludedDocTypeCodes().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.Entry.FINANCIAL_DOCUMENT_TYPE_CODE, batchParameters.getExcludedDocTypeCodes());
}
QueryByCriteria query = new QueryByCriteria(Entry.class, criteria);
query.addOrderByAscending(CabPropertyConstants.Entry.DOCUMENT_NUMBER);
query.addOrderByAscending(CabPropertyConstants.Entry.TRANSACTION_DATE_TIME_STAMP);
return getPersistenceBrokerTemplate().getCollectionByQuery(query);
}
示例11: findPreTaggablePOAccounts
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* @see org.kuali.kfs.module.cab.batch.dataaccess.ExtractDao#findPreTaggablePOAccounts(org.kuali.kfs.module.cab.businessobject.BatchParameters, java.util.List)
*/
@Override
public Collection<PurchaseOrderAccount> findPreTaggablePOAccounts(BatchParameters batchParameters, List<String> docNumbersAwaitingPurchaseOrderStatus) {
Criteria statusCodeCond1 = new Criteria();
statusCodeCond1.addEqualTo(CabPropertyConstants.PreTagExtract.PURAP_CAPITAL_ASSET_SYSTEM_STATE_CODE, CabConstants.CAPITAL_ASSET_SYSTEM_STATE_CODE_NEW);
Criteria statusCodeOrCond = new Criteria();
statusCodeOrCond.addIsNull(CabPropertyConstants.PreTagExtract.PURAP_CAPITAL_ASSET_SYSTEM_STATE_CODE);
statusCodeOrCond.addOrCriteria(statusCodeCond1);
Criteria criteria = new Criteria();
Timestamp lastRunTimestamp = new Timestamp(((java.util.Date) batchParameters.getLastRunDate()).getTime());
criteria.addGreaterThan(CabPropertyConstants.PreTagExtract.PO_INITIAL_OPEN_TIMESTAMP, lastRunTimestamp);
criteria.addAndCriteria(statusCodeOrCond);
criteria.addGreaterOrEqualThan(CabPropertyConstants.PreTagExtract.PURAP_ITEM_UNIT_PRICE, batchParameters.getCapitalizationLimitAmount());
if (!batchParameters.getExcludedChartCodes().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.PreTagExtract.CHART_OF_ACCOUNTS_CODE, batchParameters.getExcludedChartCodes());
}
if (!batchParameters.getExcludedSubFundCodes().isEmpty()) {
criteria.addNotIn(CabPropertyConstants.PreTagExtract.ACCOUNT_SUB_FUND_GROUP_CODE, batchParameters.getExcludedSubFundCodes());
}
if (!batchParameters.getIncludedFinancialObjectSubTypeCodes().isEmpty()) {
criteria.addIn(CabPropertyConstants.PreTagExtract.FINANCIAL_OBJECT_SUB_TYPE_CODE, batchParameters.getIncludedFinancialObjectSubTypeCodes());
}
QueryByCriteria query = new QueryByCriteria(PurchaseOrderAccount.class, criteria);
Collection<PurchaseOrderAccount> purchaseOrderAccounts = getPersistenceBrokerTemplate().getCollectionByQuery(query);
Collection<PurchaseOrderAccount> purchaseOrderAcctsAwaitingPOOpenStatus = new ArrayList<PurchaseOrderAccount>();
for (PurchaseOrderAccount purchaseOrderAccount : purchaseOrderAccounts) {
if (docNumbersAwaitingPurchaseOrderStatus.contains(purchaseOrderAccount.getDocumentNumber())) {
purchaseOrderAcctsAwaitingPOOpenStatus.add(purchaseOrderAccount);
}
}
return purchaseOrderAcctsAwaitingPOOpenStatus;
}
示例12: findOrganizationReversionBalancesForFiscalYear
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* Returns a list of balances to return for the Organization Reversion year end job to process
*
* @param the university fiscal year to find balances for
* @param endOfYear if true, use current year accounts, otherwise use prior year accounts
* @return an Iterator of Balances to process
* @see org.kuali.ole.gl.dataaccess.BalanceDao#findOrganizationReversionBalancesForFiscalYear(Integer, boolean, SystemOptions)
*/
public Iterator<Balance> findOrganizationReversionBalancesForFiscalYear(Integer year, boolean endOfYear, SystemOptions options, List<ParameterEvaluator> parameterEvaluators) {
LOG.debug("findOrganizationReversionBalancesForFiscalYear() started");
Criteria c = new Criteria();
c.addEqualTo(OLEPropertyConstants.UNIVERSITY_FISCAL_YEAR, year);
for (ParameterEvaluator parameterEvaluator : parameterEvaluators) {
String currentRule = parameterEvaluator.getValue();
if (endOfYear) {
currentRule = currentRule.replaceAll("account\\.", "priorYearAccount.");
}
if (StringUtils.isNotBlank(currentRule)) {
String propertyName = StringUtils.substringBefore(currentRule, "=");
List<String> ruleValues = Arrays.asList(StringUtils.substringAfter(currentRule, "=").split(";"));
if (propertyName != null && propertyName.length() > 0 && ruleValues.size() > 0 && !StringUtils.isBlank(ruleValues.get(0))) {
if (parameterEvaluator.constraintIsAllow()) {
c.addIn(propertyName, ruleValues);
}
else {
c.addNotIn(propertyName, ruleValues);
}
}
}
}
// we only ever calculate on CB, AC, and encumbrance types, so let's only select those
List organizationReversionBalancesToSelect = new ArrayList();
organizationReversionBalancesToSelect.add(options.getActualFinancialBalanceTypeCd());
organizationReversionBalancesToSelect.add(options.getFinObjTypeExpenditureexpCd());
organizationReversionBalancesToSelect.add(options.getCostShareEncumbranceBalanceTypeCd());
organizationReversionBalancesToSelect.add(options.getIntrnlEncumFinBalanceTypCd());
organizationReversionBalancesToSelect.add(OLEConstants.BALANCE_TYPE_CURRENT_BUDGET);
c.addIn(OLEPropertyConstants.BALANCE_TYPE_CODE, organizationReversionBalancesToSelect);
QueryByCriteria query = QueryFactory.newQuery(Balance.class, c);
query.addOrderByAscending(OLEPropertyConstants.CHART_OF_ACCOUNTS_CODE);
query.addOrderByAscending(OLEPropertyConstants.ACCOUNT_NUMBER);
query.addOrderByAscending(OLEPropertyConstants.SUB_ACCOUNT_NUMBER);
query.addOrderByAscending(OLEPropertyConstants.OBJECT_CODE);
query.addOrderByAscending(OLEPropertyConstants.SUB_OBJECT_CODE);
query.addOrderByAscending(OLEPropertyConstants.BALANCE_TYPE_CODE);
query.addOrderByAscending(OLEPropertyConstants.OBJECT_TYPE_CODE);
return getPersistenceBrokerTemplate().getIteratorByQuery(query);
}
示例13: inExpr
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
public final void inExpr(
Criteria criteria
) throws RecognitionException, TokenStreamException {
Token id = null;
try { // for error handling
boolean negative = false;
Collection coll;
id = LT(1);
match(Identifier);
{
if ((LA(1)==LITERAL_not)) {
match(LITERAL_not);
negative = true;
}
else if ((LA(1)==LITERAL_in)) {
}
else {
throw new NoViableAltException(LT(1), getFilename());
}
}
match(LITERAL_in);
{
if ((LA(1)==LITERAL_list)) {
match(LITERAL_list);
}
else if ((LA(1)==TOK_LPAREN)) {
}
else {
throw new NoViableAltException(LT(1), getFilename());
}
}
coll=argList();
if (negative) {
criteria.addNotIn(id.getText(), coll);
} else {
criteria.addIn(id.getText(), coll);
}
}
catch (RecognitionException ex) {
reportError(ex);
recover(ex,_tokenSet_7);
}
}
示例14: findMatchingTrips
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
@Override
public Collection<? extends TEMReimbursementDocument> findMatchingTrips (Integer temProfileId ,Timestamp tripBegin, Timestamp tripEnd) {
final Criteria criteria = new Criteria();
final Criteria orEndDateCriteria = new Criteria();
criteria.addEqualTo(TemPropertyConstants.TEM_PROFILE_ID, temProfileId);
criteria.addEqualTo(TemPropertyConstants.TRIP_BEGIN_DT, tripBegin);
orEndDateCriteria.addEqualTo(TemPropertyConstants.TRIP_END_DT, tripEnd);
criteria.addOrCriteria(orEndDateCriteria);
criteria.addNotIn("documentHeader.financialDocumentStatusCode", Arrays.asList(DocumentStatusCodes.INITIATED));
return getPersistenceBrokerTemplate().getCollectionByQuery(new QueryByCriteria(TravelReimbursementDocument.class, criteria));
}
示例15: findOrganizationReversionBalancesForFiscalYear
import org.apache.ojb.broker.query.Criteria; //导入方法依赖的package包/类
/**
* Returns a list of balances to return for the Organization Reversion year end job to process
*
* @param the university fiscal year to find balances for
* @param endOfYear if true, use current year accounts, otherwise use prior year accounts
* @return an Iterator of Balances to process
* @see org.kuali.kfs.gl.dataaccess.BalanceDao#findOrganizationReversionBalancesForFiscalYear(Integer, boolean, SystemOptions)
*/
@Override
public Iterator<Balance> findOrganizationReversionBalancesForFiscalYear(Integer year, boolean endOfYear, SystemOptions options, List<ParameterEvaluator> parameterEvaluators) {
LOG.debug("findOrganizationReversionBalancesForFiscalYear() started");
Criteria c = new Criteria();
c.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, year);
for (ParameterEvaluator parameterEvaluator : parameterEvaluators) {
String currentRule = parameterEvaluator.getValue();
if (endOfYear) {
currentRule = currentRule.replaceAll("account\\.", "priorYearAccount.");
}
if (StringUtils.isNotBlank(currentRule)) {
String propertyName = StringUtils.substringBefore(currentRule, "=");
List<String> ruleValues = Arrays.asList(StringUtils.substringAfter(currentRule, "=").split(";"));
if (propertyName != null && propertyName.length() > 0 && ruleValues.size() > 0 && !StringUtils.isBlank(ruleValues.get(0))) {
if (parameterEvaluator.constraintIsAllow()) {
c.addIn(propertyName, ruleValues);
}
else {
c.addNotIn(propertyName, ruleValues);
}
}
}
}
// we only ever calculate on CB, AC, and encumbrance types, so let's only select those
List organizationReversionBalancesToSelect = new ArrayList();
organizationReversionBalancesToSelect.add(options.getActualFinancialBalanceTypeCd());
organizationReversionBalancesToSelect.add(options.getFinObjTypeExpenditureexpCd());
organizationReversionBalancesToSelect.add(options.getCostShareEncumbranceBalanceTypeCd());
organizationReversionBalancesToSelect.add(options.getIntrnlEncumFinBalanceTypCd());
organizationReversionBalancesToSelect.add(KFSConstants.BALANCE_TYPE_CURRENT_BUDGET);
c.addIn(KFSPropertyConstants.BALANCE_TYPE_CODE, organizationReversionBalancesToSelect);
QueryByCriteria query = QueryFactory.newQuery(Balance.class, c);
query.addOrderByAscending(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE);
query.addOrderByAscending(KFSPropertyConstants.ACCOUNT_NUMBER);
query.addOrderByAscending(KFSPropertyConstants.SUB_ACCOUNT_NUMBER);
query.addOrderByAscending(KFSPropertyConstants.OBJECT_CODE);
query.addOrderByAscending(KFSPropertyConstants.SUB_OBJECT_CODE);
query.addOrderByAscending(KFSPropertyConstants.BALANCE_TYPE_CODE);
query.addOrderByAscending(KFSPropertyConstants.OBJECT_TYPE_CODE);
return getPersistenceBrokerTemplate().getIteratorByQuery(query);
}