protected IEnumerable allannouncementsgrid() { return(PXSelectJoinOrderBy <CRAnnouncement, LeftJoin <EPView, On <EPView.noteID, Equal <CRAnnouncement.noteID>, And <EPView.status, Equal <EPViewStatusAttribute.Viewed>, And <EPView.userID, Equal <Current <AccessInfo.userID> > > > > >, OrderBy <Asc <EPView.userID, Desc <EPActivity.createdDateTime> > > > .SelectWindowed(this, 0, 5)); }
protected virtual IEnumerable scenarios() { foreach (PXResult <WZScenario, SiteMap> result in PXSelectJoinOrderBy <WZScenario, LeftJoin <SiteMap, On <WZScenario.nodeID, Equal <SiteMap.nodeID> > >, OrderBy <Asc <WZScenario.scenarioOrder> > > .Select(this)) { WZScenario scenario = result; SiteMap siteMap = result; if (scenario.NodeID != null && siteMap.NodeID == null) { siteMap.NodeID = scenario.NodeID; WZScenario parentScenario = PXSelect <WZScenario, Where <WZScenario.scenarioID, Equal <Required <WZScenario.scenarioID> > > > .Select(this, scenario.NodeID); if (parentScenario != null) { siteMap.Title = parentScenario.Name; } } yield return(new PXResult <WZScenario, SiteMap>(scenario, siteMap));; } }