Problem with filtering when the datasource is refreshed

[Manuel Caballero]

Hello,

When the datasource of the Grid control is refreshed, the options of the Excel filters of the columns are not updated with the new values. I mean, the list of values to filter in a column is not updated with the new values, the filter only show the oldest values to select.

Thanks!

[Vasanthakumar K]

Hi Manuel Caballero,

Greetings from Syncfusion support.

Query: When the data source of the Grid is refreshed, the Excel filter options are not updated with the new values. The filter still displays the older values. How can this issue be resolved?

We tested this scenario based on the information provided. After refreshing the Grid's data source, the Excel filter dialog successfully rendered the updated values from the new data source (first 1000 items by default). This behavior aligns with the expected functionality of the Excel filter. Please refer to the below sample and documentation for your reference.

Sample: Please find the attachment.

Documentations: Ondemand Excel filter default 1000 items rendering behavior and Customize filterChoiceCount Excle filter default 1000 items rendering behavior

Possible Causes of the Issue:

1. Configuration Differences:
   The issue could be caused by differences in your Grid's configuration compared to our tested sample.
2. Custom Data Source Implementation:
   If you're using a custom implementation to provide the data source for the Excel filter dialog, this custom sample dataSource might not be updating correctly. Reference KB
3. Misunderstanding of Default Behavior:
   By default, the Excel filter dialog renders only the first 1000 items from the new data source. This optimization might be mistaken as an issue.

Additional Details Needed for Further Investigation:

To help us identify the exact cause of the issue, please provide the following:

1. Complete Grid Configuration:
   Share the full Grid configuration, including:
• Enabled features (e.g., filtering, sorting, virtualization).
• Column definitions.
• Event handlers.
• Any specific property customizations, especially related to filtering.
2. Data Source Update Method:
   Explain how you are updating the Grid's data source. Are you replacing the data entirely or performing incremental updates?
3. Issue Replication Steps:
   Provide a step-by-step procedure to reproduce the issue, ideally with a video demonstration showing the behavior in your application.
4. Version Confirmation:
   Confirm whether you're using the latest Syncfusion NuGet packages, scripts, and styles(28.1.41). If not, please upgrade and check. Refer to the Syncfusion upgrade guidelines for proper steps.
5. Customized Sample:
   Replicate the issue using our shared sample by applying your specific customizations.

Regards,

Vasanthakumar K

Attachment: 195914mvcexcelfilterolditemgridnewdata_15762795.zip

[Manuel Caballero]

Hello,

The problem is this:

• Misunderstanding of Default Behavior:
  By default, the Excel filter dialog renders only the first 1000 items from the new data source. This optimization might be mistaken as an issue.

I didn't know that optimization.

Thank you!

[Vasanthakumar K]

Hi Manuel Caballero,

We're delighted to know that the clarification on the grid's Excel filter behavior and the references to the filterChoiceCount and On-Demand Excel filtering documentation were helpful in meeting your application requirements.

If you have any further queries or need additional support related to this topic, feel free to contact us. We're always here to assist and ensure your experience is seamless!

Regards,

Vasanthakumar K