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);
}
