protected override void BuildGroupBy(SelectQuery query, ReportColumnMapping groupByColumn, MappedSearchRequest request)
{
var actionSpecIdColumn = QueryHelpers.GetColumnMapping(_transposeKeyColumnId);
query.GroupBy(_transposeStatsTableAlias, groupByColumn.FieldName)
.GroupBy(_transposeStatsTableAlias, actionSpecIdColumn.FieldName);
StatsQueryHelpers.AddTemporalAggregationGroupBy(query, request.TemporalAggregation, _constants.StatsDateDbField);
}
protected override void BuildWhere(SelectQuery query, string queryText, List <MappedSearchRequestFilter> filters, MappedSearchRequest request)
{
var allTransposeStatsColumns = _dataSourceComponents.StatsQueryBuilder.GetAllTransposeStatsColumns(request);
var transposeKeyColumn = QueryHelpers.GetColumnMapping(_transposeKeyColumnId);
var selectedTransposeKeyValues = allTransposeStatsColumns.Select(x => x.ActionSpecId).Distinct().Select(x => x.ToString()).ToList();
query.WhereColumnIn(_transposeStatsTableAlias, transposeKeyColumn.FieldName, selectedTransposeKeyValues, DbType.Int32, _transposeStatsKeyFieldAlias);
StatsQueryHelpers.AddDateFilters(query, _transposeStatsTableAlias, request.TemporalAggregation, request.DateRangeType, _constants.StatsDateDbField, request.DateStart, request.DateEnd);
}
protected override void AddTemporalAggregationGroupBy(SelectQuery query, TemporalAggregation temporalAggregation)
{
StatsQueryHelpers.AddTemporalAggregationGroupBy(query, temporalAggregation, _constants.StatsDateDbField);
}
protected override void BuildWhere(SelectQuery query, string queryText, List <MappedSearchRequestFilter> filters, MappedSearchRequest request)
{
StatsQueryHelpers.AddDateFilters(query, _statsTableAlias, request.TemporalAggregation, request.DateRangeType, _constants.StatsDateDbField, request.DateStart, request.DateEnd);
}