예제 #1
0
        private EntitySchemaQueryColumn AddQueryColumn(JObject columnItem, string columnPath)
        {
            columnPath = DashboardDataUtils.ClearColumnPathSuffix(columnPath);
            string          filterData            = columnItem.Value <string>("serializedFilter");
            string          aggregationType       = columnItem.Value <string>("aggregationType");
            AggregationType columnAggregationType = AggregationType.None;

            if (!string.IsNullOrEmpty(aggregationType))
            {
                columnAggregationType = (AggregationType)Enum.Parse(typeof(AggregationType),
                                                                    aggregationType);
            }
            EntitySchemaQueryColumn column;

            if (columnAggregationType != AggregationType.None && !string.IsNullOrEmpty(filterData))
            {
                EntitySchemaQuery subQuery;
                column = Esq.AddColumn(columnPath, columnAggregationType.ToStrict(), out subQuery);
                var dashboardData = new BaseDashboardItemSelectBuilder(UserConnection, subQuery);
                dashboardData.AddFilterByJson(filterData);
            }
            else
            {
                column = Esq.AddColumn(columnPath);
                if (!string.IsNullOrEmpty(aggregationType))
                {
                    column.SummaryType = columnAggregationType;
                }
            }
            SetColumnOrder(columnItem, column);
            return(column);
        }
예제 #2
0
        private void SetChartFilters(BaseDashboardItemSelectBuilder builder, JToken serieParameters)
        {
            var useEmptyValue = Parameters.Value <string>("useEmptyValue");

            if (useEmptyValue.IsNullOrEmpty() || useEmptyValue.Equals("False"))
            {
                AddUseEmptyValuesFilters(builder, serieParameters);
            }
            string filterData = serieParameters.Value <string>("filterData");

            builder.AddFilterByJson(filterData);
            ApplySectionBindingFilter(builder, serieParameters);
        }