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 BuildWhere(SelectQuery query, string queryText, List <MappedSearchRequestFilter> filters, MappedSearchRequest request) { StatsQueryHelpers.AddDateFilters(query, _statsTableAlias, request.TemporalAggregation, request.DateRangeType, _constants.StatsDateDbField, request.DateStart, request.DateEnd); }