We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
|
public string GetData(CaptionTemplateContext args)
{
if (args.Field == nameof(Product.Status))
{
var val = Products.GroupBy(x => x.Status).Where(X => X.Key == args.Key).Select(x => x).ToList();
return $"{args.Field} : {args.Key} - {val.First().Count().ToString()} records ({args.Count} Sub Groups)";
}
else
{
return $"{args.Field} : {args.Key} - {args.Count.ToString()} records ({args.Count} Sub Groups)";
}
} |
 |
 |
I added a 3rd grouping in the results become skewed. The image below shows Sev - High with 2 records; however, there are actually 3 records.
Also, if I add the below lines of codes to GetData. The "Severity High 7 " shows a count of 7 but there are only 3 matching that grouping.
else if (args.Field == nameof(Product.Severity))
{
var val = Products.GroupBy(x => x.Severity).Where(X => X.Key == args.Key).Select(x => x).ToList();
return $"{args.Field} : {args.Key} - {val.First().Count().ToString()} records ({args.Count} Sub Groups)";
}
If I flip-flop Status and Severity grouping, the result are skewed.
I increased the count from 10 to 20 to get more records to work with.
|
<SfGrid DataSource="@Products" AllowGrouping="true" AllowPaging="true">
<GridGroupSettings EnableLazyLoading="true" Columns=@Units>
<CaptionTemplate>
@{
var order = (context as CaptionTemplateContext);
<div>@GetData(order)</div>
}
</CaptionTemplate>
</GridGroupSettings>
<GridColumns>
<GridColumn Field=@nameof(Product.ProductName) HeaderText="Product Name" TextAlign="TextAlign.Right" Width="220"></GridColumn>
. ..
</GridColumns>
</SfGrid>
|
 |
Still getting the same result. The Sub-Group count doesn't match the number of actual sub-groups. For example, The first line should be 'Status: New - 10 records (3 Sub Groups)
After realizing AggregateTemplateContext shared similar properties (i.e. HeaderText, Key, etc...) found in CaptionTemplateContext, I was able to resolve my issue. AggregateTemplateContext contains the counts I wanted and rolls up correctly along with the text I wanted to display.
<GridAggregate>
<GridAggregateColumns>
<GridAggregateColumn Field=@nameof(Product.QuantityPerUnit) Type="AggregateType.Count">
<GroupCaptionTemplate>
@{
var aggregate = (context as AggregateTemplateContext);
<div>@aggregate.HeaderText: @aggregate.Key - @aggregate.Count items</div>
}
</GroupCaptionTemplate>
</GridAggregateColumn>
</GridAggregateColumns>
</GridAggregate>
I hid the default group caption by doing the following...
<GridGroupSettings Columns=@Units>
<CaptionTemplate />
</GridGroupSettings>
