protected virtual IEnumerable translationHistoryRecords() { PXSelectBase <TranslationHistory> cmd; TranslationEnqFilter filter = Filter.Current as TranslationEnqFilter; this.TranslationHistoryRecords.Cache.AllowInsert = false; this.TranslationHistoryRecords.Cache.AllowDelete = false; this.TranslationHistoryRecords.Cache.AllowUpdate = false; TranslationHistoryRecords.Cache.Clear(); cmd = new PXSelectOrderBy <TranslationHistory, OrderBy <Desc <TranslationHistory.finPeriodID, Desc <TranslationHistory.translDefId, Asc <TranslationHistory.referenceNbr> > > > >(this); if (filter.TranslDefId != null) { cmd.WhereAnd <Where <TranslationHistory.translDefId, Equal <Current <TranslationEnqFilter.translDefId> > > >(); } if (filter.FinPeriodID != null) { cmd.WhereAnd <Where <TranslationHistory.finPeriodID, Equal <Current <TranslationEnqFilter.finPeriodID> > > >(); } if (filter.Released == false) { cmd.WhereAnd <Where <TranslationHistory.status, NotEqual <TranslationReleased> > >(); } if (filter.Unreleased == false) { cmd.WhereAnd <Where <TranslationHistory.status, NotEqual <TranslationUnReleased> > >(); } if (filter.Voided == false) { cmd.WhereAnd <Where <TranslationHistory.status, NotEqual <TranslationVoided> > >(); } foreach (PXResult <TranslationHistory> thist in cmd.Select()) { yield return(thist); } }