WASM large data load issue
 |
|
[HttpGet]
[Route("getlargedata")]
public async Task<object> GetLargeData(ODataQueryOptions<WeatherForecast> options)
{
ODataQuerySettings settings = new ()
{
PageSize = 100
};
var data = GetData();
IQueryable results = options.ApplyTo(data.AsQueryable(), settings);
var r = new PageResult<WeatherForecast>(
results as IEnumerable<WeatherForecast>,
Request.HttpContext.ODataFeature().NextLink,
data.Count()
);
var data1 = results as IEnumerable<WeatherForecast>;
return new { Items = data1, Count = data1.Count() };
} |
Thanks Monisha, this is extremely helpful.
A few questions on the sample with this method
Column Filters
1 - If you set the filter type to "FilterType.Menu" it works well, but if there's a string column like "Summary" when you type in the "Enter the value" field it pops up a saying "No records found". Is there a way to turn that off because we just want the filter to run based on the input.
2 - If you had an identification column for example "Country" and wanted a selection list I can pre-polulate the datasource if a filtertemplate but how do I bind it so that it still works in the Odata. And can the "Starts With" be removed in this case too.
The below sends the Odata but with NULL in the Country field and throws a 400. If I bind "Value" to c.Country it breaks the control on the UI
<GridColumn Field="@nameof(ou.Country)" Width=100 Type="ColumnType.String">
<FilterTemplate>
@{
var c = context as OrgUnit;
<SfDropDownList DataSource="@Country" TValue="string" TItem="string"></SfDropDownList>
}
</FilterTemplate>
</GridColumn>
Search
If I add Search to the toolbars and test the general search box, the network shows the Odata query is triggering with the search term http://localhost:5076/odata/OrgUnits?$count=true&$search=Ou+96222%20OR%20Ou+5000&$skip=0&$top=50 but the search doesn't apply, is anything else needed to enable it?
Thank you
