Controls / RadPivotGrid / Features / QueryableDataProvider

New to Telerik UI for WPF? Download free 30-day trial

QueryableDateTimeGroupDescription

In this article you will learn how to use a QueryableDateTimeGroupDescription with your DateTime and DateTimeOffset data.

QueryableDateTimeGroupDescription

QueryableDateTimeGroupDescription is used when you want to group your data by a property of type DateTime or DateTimeOffset. It has the following properties:

  • PropertyName : defines the name of the property by which the data will be grouped. It is mandatory to set a value.

  • Step : defines the grouping interval. Default value is Year, but you can change it to one of the following: Quarter, Month, Day, Week Hour, Minute, Second (The Week, Hour, Minute and Second steps are available since the 2019.2.729 version).

If you have the following dates: 01-01-2013 and 20-02-2013 and you set Step to Year, the two values will be in one group - 2013. But if you change the step to Month, the values will be in two different groups - January and February.

When you have a property of type DateTime (DateTimeOffset), you can create several QueryableDateTimeGroupDescription with different steps. You may also create a QueryablePropertyGroupDescription - this way the DateTime will be treated as a string and grouped as such. All of them can be used simultaneously. You can add the description in RowGroupDescriptions or ColumnGroupDescriptions collections of QueryableDataSourceProvider.

Example 1: Adding multiple group descriptions in xaml

<pivot:QueryableDataProvider.RowGroupDescriptions> 
    <pivot:QueryableDateTimeGroupDescription PropertyName="Date" Step="Quarter"/> 
    <pivot:QueryableDateTimeGroupDescription PropertyName="Date" Step="Month" /> 
    <pivot:QueryablePropertyGroupDescription PropertyName="Date"/> 
</pivot:LocalDataSourceProvider.RowGroupDescriptions>

Example 2: Adding multiple group descriptions in code

QueryableDateTimeGroupDescription dateTimeGroupDescription1 = new QueryableDateTimeGroupDescription(); 
dateTimeGroupDescription1.PropertyName = "Date"; 
dateTimeGroupDescription1.Step = DateTimeStep.Quarter; 
QueryableDateTimeGroupDescription dateTimeGroupDescription2 = new QueryableDateTimeGroupDescription(); 
dateTimeGroupDescription2.PropertyName = "Date"; 
dateTimeGroupDescription2.Step = DateTimeStep.Month; 
QueryablePropertyGroupDescription propertyGroupDescription = new QueryablePropertyGroupDescription(); 
propertyGroupDescription.PropertyName = "Date"; 
 
var dataProvider = new QueryableDataProvider(); 
dataProvider.RowGroupDescriptions.Add(dateTimeGroupDescription1); 
dataProvider.RowGroupDescriptions.Add(dateTimeGroupDescription2); 
dataProvider.RowGroupDescriptions.Add(propertyGroupDescription);

Modify FieldTree of RadPivotFieldList

By default RadPivotFieldList will show the following steps in its FieldTree for each QueryableDateTimeGroupDescription: Year, Month, Quarter, Day (you will also see one additional item, which will create a QueryablePropertyGroupDescription instead of a QueryableDateTimeGroupDescription).

That said, you can set four more steps in code or xaml - Week, Hour, Minute, Second(Those 4 steps were added with the 2019.2.729 version). In order to add them to the FieldTree of RadPivotFieldList you have two options:

  • Handle the GetDescriptionsDataAsyncCompleted of the FieldDescriptionsProvider.

    Examples 3 and 4 below demonstrate how the GetDescriptionsDataAsyncCompleted event can be handled in xaml and code respectively. Example 5 demonstrate a sample implementation of the event handler that shows the Week, Hour, Minute and Second steps for a property named "Date".

    Example 3: Handling the GetDescriptionsDataAsyncCompleted event in xaml

        <pivot:QueryableDataProvider> 
            <pivot:QueryableDataProvider.FieldDescriptionsProvider> 
                <pivot:QueryableFieldDescriptionsProvider GetDescriptionsDataAsyncCompleted="FieldDescriptionsProvider_GetDescriptionsDataAsyncCompleted" /> 
            </pivot:QueryableDataProvider.FieldDescriptionsProvider> 
    </pivot:QueryableDataProvider>

    Example 4: Handling the GetDescriptionsDataAsyncCompleted event in code

        (this.PivotGrid.DataProvider as QueryableDataProvider).FieldDescriptionsProvider.GetDescriptionsDataAsyncCompleted += FieldDescriptionsProvider_GetDescriptionsDataAsyncCompleted;

    Example 5: Showing the additional steps

        private void FieldDescriptionsProvider_GetDescriptionsDataAsyncCompleted(object sender, Telerik.Pivot.Core.Fields.GetDescriptionsDataCompletedEventArgs e) 
        { 
            // The code below assumes that there is a DateTime property called "Date" 
            var dateTimeNodes = e.DescriptionsData.RootFieldInfo.Children.Where(n => n.Caption == "Date").FirstOrDefault().Children; 
 
            foreach (var dateTimeNode in dateTimeNodes) 
            { 
                var fieldInfoNode = dateTimeNode as FieldInfoNode; 
 
                if (fieldInfoNode.FieldInfo.DisplayName == "Date - Week") 
                { 
                    (fieldInfoNode.FieldInfo as PropertyFieldInfo).AutoGenerateField = true; 
                } 
                if(fieldInfoNode.FieldInfo.DisplayName == "Date - Hour") 
                { 
                    (fieldInfoNode.FieldInfo as PropertyFieldInfo).AutoGenerateField = true; 
                } 
                if (fieldInfoNode.FieldInfo.DisplayName == "Date - Minute") 
                { 
                    (fieldInfoNode.FieldInfo as PropertyFieldInfo).AutoGenerateField = true; 
                } 
                if (fieldInfoNode.FieldInfo.DisplayName == "Date - Second") 
                { 
                    (fieldInfoNode.FieldInfo as PropertyFieldInfo).AutoGenerateField = true; 
                } 
            } 
        }

  • Create a custom QueryableFieldDescriptionsProvider.

    Example 6 demonstrates how to create a custom QueryableFieldDescriptionsProvider and ovveride its GetFieldDescriptionHierarchy method in order to show the additional steps. Examples 7 and 8 demonstrate how to use the created class by setting it to the FieldDescriptionsProvider property of the QueryableDataProvider.

    Example 6: Custom QueryableFieldDescriptionsProvider

        public class CustomQueryableFieldDescriptionsProvider : QueryableFieldDescriptionsProvider 
    { 
        protected override ContainerNode GetFieldDescriptionHierarchy(IEnumerable<IPivotFieldInfo> fieldInfos) 
        { 
            var hierarchy = base.GetFieldDescriptionHierarchy(fieldInfos); 
            // The code below assumes that there is a DateTime property called "Date" 
            var dateTimeNodes = hierarchy.Children.Where(n => n.Caption == "Date").FirstOrDefault().Children; 
 
            foreach (var dateTimeNode in dateTimeNodes) 
            { 
                var fieldInfoNode = dateTimeNode as FieldInfoNode; 
 
                if (fieldInfoNode.FieldInfo.DisplayName == "Date - Week") 
                { 
                    (fieldInfoNode.FieldInfo as PropertyFieldInfo).AutoGenerateField = true; 
                } 
                if (fieldInfoNode.FieldInfo.DisplayName == "Date - Hour") 
                { 
                    (fieldInfoNode.FieldInfo as PropertyFieldInfo).AutoGenerateField = true; 
                } 
                if (fieldInfoNode.FieldInfo.DisplayName == "Date - Minute") 
                { 
                    (fieldInfoNode.FieldInfo as PropertyFieldInfo).AutoGenerateField = true; 
                } 
                if (fieldInfoNode.FieldInfo.DisplayName == "Date - Second") 
                { 
                    (fieldInfoNode.FieldInfo as PropertyFieldInfo).AutoGenerateField = true; 
                } 
            } 
 
            return hierarchy; 
        } 
    }

    Example 7: Using the CustomQueryableFieldDescriptionsProvider in xaml

        <pivot:QueryableDataProvider> 
        <pivot:QueryableDataProvider.FieldDescriptionsProvider> 
            <local:CustomQueryableFieldDescriptionsProvider/> 
        </pivot:QueryableDataProvider.FieldDescriptionsProvider> 
    </pivot:QueryableDataProvider>

    Example 8: Using the CustomQueryableFieldDescriptionsProvider in code

        (this.PivotGrid.DataProvider as QueryableDataProvider).FieldDescriptionsProvider = new CustomQueryableFieldDescriptionsProvider();
In this article
Related articles
Not finding the help you need? Improve this article