Grid duplicating calls to query endpoint for each column visibility change
We have a page that queries data based on a page parameter called 'ViewId'. Because of this we must utilize the OnParametersSetAsync method to regenerate the data. The column visibilities for the view can also change so we must make another call to get the 'true/false' values (the sample below just randomizes them for demo purposes). The problem is that for every column visibility change, a duplicated QUERY call is made to the endpoint "customview/query". In this example, up to 5 additional calls are made each time the 'ViewId' url property changes. Please see the below code/screenshot.
<SfGrid @ref="Grid" TValue="ModelType"
Query="QueryCustomizations" ID="ViewRows"
AllowFiltering="true" AllowSorting="true"
AllowMultiSorting="true" AllowTextWrap="true">
<SfDataManager @ref="DataManager" Adaptor="Adaptors.ODataV4Adaptor" Url="customview/query"/>
<GridColumns>
<GridColumn Field=@nameof(ModelType.Id) IsPrimaryKey="true" Visible="false" />
<GridColumn Field=@nameof(ModelType.Prop1) HeaderText="Prop 1" MinWidth="100" Visible=@PropVisibilities[0] />
<GridColumn Field=@nameof(ModelType.Prop2) HeaderText="Prop 2" MinWidth="140" Visible=@PropVisibilities[1] />
<GridColumn Field=@nameof(ModelType.Prop3) HeaderText="Prop 3" MinWidth="140" Visible=@PropVisibilities[2] />
<GridColumn Field=@nameof(ModelType.Prop4) HeaderText="Prop 4" MinWidth="200" Visible=@PropVisibilities[3] />
<GridColumn Field=@nameof(ModelType.Prop5) HeaderText="Prop 5" MinWidth="200" Visible=@PropVisibilities[4] />
</GridColumns>
</SfGrid>
@code {
[Parameter] public Guid ViewId { get; set; }
bool[] PropVisibilities = new bool[5];
protected override Task OnParametersSetAsync()
{
QueryCustomizations = new Query()
.Sort("AccountNumber", null)
.AddParams("ViewId", ViewId);
PropVisibilities[0] = Random.Shared.Next(2) == 1;
PropVisibilities[1] = Random.Shared.Next(2) == 1;
PropVisibilities[2] = Random.Shared.Next(2) == 1;
PropVisibilities[3] = Random.Shared.Next(2) == 1;
PropVisibilities[4] = Random.Shared.Next(2) == 1;
return Task.CompletedTask;
}
}
So, our question is how can we control the query calls made, OR is this a bug that needs to be addressed? How should this work as this will be an ocurring theme throughout our project.
Our first thought was to see if we can control the query calls manually (instead of Synfusion determining when to make them). However, we do not know how to tell the DataManager to stop making all calls and allow us to make the call manually (especially when the call needs to include an oData syntax for the query url).
