@Override public DateTimeExpression<T> as(String alias) { return as(ExpressionUtils.path(getType(), alias)); }
@Override public DateTimeExpression<T> as(String alias) { return as(ExpressionUtils.path(getType(), alias)); }
@Override public List<? extends JpaNifiFeedProcessorStats> findFeedProcessorStatisticsByProcessorId(String feedName, DateTime start, DateTime end) { QJpaNifiFeedProcessorStats stats = QJpaNifiFeedProcessorStats.jpaNifiFeedProcessorStats; QJpaOpsManagerFeed feed = QJpaOpsManagerFeed.jpaOpsManagerFeed; JPAQuery query = factory.select( Projections.bean(JpaNifiFeedProcessorStats.class, stats.feedName, stats.processorId, stats.processorName, stats.bytesIn.sum().as("bytesIn"), stats.bytesOut.sum().as("bytesOut"), stats.duration.sum().as("duration"), stats.jobsStarted.sum().as("jobsStarted"), stats.jobsFinished.sum().as("jobsFinished"), stats.jobDuration.sum().as("jobDuration"), stats.flowFilesStarted.sum().as("flowFilesStarted"), stats.flowFilesFinished.sum().as("flowFilesFinished"), stats.totalCount.sum().as("totalCount"), stats.maxEventTime.max().as("maxEventTime"), stats.minEventTime.min().as("minEventTime"), stats.jobsFailed.sum().as("jobsFailed"), stats.failedCount.sum().as("failedCount"), stats.count().as("resultSetCount")) ) .from(stats) .innerJoin(feed).on(feed.name.eq(stats.feedName)) .where(stats.feedName.eq(feedName) .and(FeedAclIndexQueryAugmentor.generateExistsExpression(feed.id, accessController.isEntityAccessControlled())) .and(stats.minEventTime.goe(start) .and(stats.maxEventTime.loe(end)))) .groupBy(stats.feedName, stats.processorId, stats.processorName) .orderBy(stats.processorName.asc()); return (List<JpaNifiFeedProcessorStats>) query.fetch(); }
@Override public List<? extends JpaNifiFeedProcessorStats> findFeedProcessorStatisticsByProcessorName(String feedName, DateTime start, DateTime end) { QJpaNifiFeedProcessorStats stats = QJpaNifiFeedProcessorStats.jpaNifiFeedProcessorStats; QJpaOpsManagerFeed feed = QJpaOpsManagerFeed.jpaOpsManagerFeed; JPAQuery query = factory.select( Projections.bean(JpaNifiFeedProcessorStats.class, stats.feedName, stats.processorName, stats.bytesIn.sum().as("bytesIn"), stats.bytesOut.sum().as("bytesOut"), stats.duration.sum().as("duration"), stats.jobsStarted.sum().as("jobsStarted"), stats.jobsFinished.sum().as("jobsFinished"), stats.jobDuration.sum().as("jobDuration"), stats.flowFilesStarted.sum().as("flowFilesStarted"), stats.flowFilesFinished.sum().as("flowFilesFinished"), stats.totalCount.sum().as("totalCount"), stats.maxEventTime.max().as("maxEventTime"), stats.minEventTime.min().as("minEventTime"), stats.jobsFailed.sum().as("jobsFailed"), stats.failedCount.sum().as("failedCount"), stats.count().as("resultSetCount")) ) .from(stats) .innerJoin(feed).on(feed.name.eq(stats.feedName)) .where(stats.feedName.eq(feedName) .and(FeedAclIndexQueryAugmentor.generateExistsExpression(feed.id, accessController.isEntityAccessControlled())) .and(stats.minEventTime.goe(start) .and(stats.maxEventTime.loe(end)))) .groupBy(stats.feedName, stats.processorName) .orderBy(stats.processorName.asc()); return (List<JpaNifiFeedProcessorStats>) query.fetch(); }
.then($.currentFormVersion.inclusionDate) .otherwise($.currentFormDraftVersionEntity.inclusionDate) .as("creationDate")) .addCase($case -> $case .when($.formType.abbreviation.isNull())
.then($.currentFormVersion.inclusionDate) .otherwise($.currentFormDraftVersionEntity.inclusionDate) .as("creationDate")) .addCase($case -> $case .when($.formType.abbreviation.isNull())
.then($.currentFormVersion.inclusionDate) .otherwise($.currentFormDraftVersionEntity.inclusionDate) .as(CREATION_DATE)) .addCaseToSelect($case -> $case .when($.formType.abbreviation.isNull())