DateTime in FilterSettings for Excel, filter AutoComplete not closing

[Andrzej]

Hello, I have problems with filtering the SfGrid.

1. One column in my SfGrid contains DateTime and Format="dd.MM.yyyy HH:mm". The date+time is displayed correctly.

I define a filter to 17.09.2018 16:09:00.

The field  FilterSettings.Columns[0].Value contains proper value 17.09.2018 16:09:00

Then I invoke following code: 

            ExportProperties = new ExcelExportProperties();

            ExportProperties.ExportType = ExportType.AllPages;

            await DefaultGrid.ExcelExport(ExportProperties);

After that, the field  FilterSettings.Columns[0].Value contains modified value 17.09.2018 00:00:00

Why the time is cleared after ExcelExport?

2. I use data adapter to get the list of items from database into a variable selectedRecordsCount.Items. 

Then I invoke following code:

                ExportProperties = new ExcelExportProperties();

                ExportProperties.DataSource = selectedRecordsCount.Items;

                await DefaultGrid.ExcelExport(ExportProperties);

It seems that ExcelExport ignores my DataSource and tries to get data by it's own using my data adapter and also modified time value (00:00:00).

3. When the reading from a big database takes a few seconds in my data adapter, then sometimes, after pressing Esc, the AutoComplete list for a filter remains on the screen permanently  even when switching pages.

It happens when I type in the filter value quicker than the adapter responds and at some moment I press Esc. It doesn't happen every time but happens quite often. Is it a known issue?

Best regards

[Renjith Singh Rajendran]

Hi Andrzej, 

Greetings from Syncfusion support. 

Query 1 : FilterSettings.Columns[0].Value contains modified value 17.09.2018 00:00:00. 

We have confirmed it as a bug and logged the defect report “ExcelExport is updating the FilterSettings datatime column value” for the same. Thank you for taking the time to report this issue and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technological feasibility and Product Development Life Cycle) and including the defect fix in our weekly release which is expected to be rolled out by the mid of July, 2021.  

       

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.       

Feedback : https://www.syncfusion.com/feedback/25968/excelexport-is-updating-the-filtersettings-datatime-column-value 

 

Query 2 : It seems that ExcelExport ignores my DataSource and tries to get data by it's own using my data adapter 

We have confirmed it as a bug and logged the defect report “Problem with custom datasource exporting when bind data using SfDataManager to Grid” for the same. Thank you for taking the time to report this issue and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technological feasibility and Product Development Life Cycle) and including the defect fix in our weekly release which is expected to be rolled out by the mid of July, 2021.  

       

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.       

Feedback :https://www.syncfusion.com/feedback/26001/problem-with-custom-datasource-exporting-when-bind-data-using-sfdatamanager-to 

 

Query 3 : the AutoComplete list for a filter remains on the screen permanently  even when switching pages. 

We are not clear about the exact scenario you are facing this problem. Kindy share with us the following details to proceed further. 

 

1. Share a video demo showing the replication of the problem you are facing.
2. Share a simple issue reproducing sample for us to validate based on your scenario.
3. Share the exact scenario you are facing this problem.
4. Share the complete grid rendering codes.

 

The provided information will help us analyze the problem, and provide you a solution as early as possible. 

Regards, 

Renjith R 

[Andrzej]

Hello,

so far I am not able to prepare an exact sample showing the behavior of Query 3. It happens rather seldom and for big database only.

Do you know when problems Query 1 and Query 2 could be fixed?

Best regards,
Andrzej

[Renjith Singh Rajendran]

Hi Andrzej, 

Thanks for your update. 

Query : Do you know when problems Query 1 and Query 2 could be fixed? 

As informed in our previous update, the fix for these two issues is expected to be rolled out in our upcoming bi-weekly releases which is expected by the mid of July 2021. We request you to follow up on the corresponding feedback links for future updates regarding these issues. 

https://www.syncfusion.com/feedback/25968/excelexport-is-updating-the-filtersettings-datatime-column-value 

https://www.syncfusion.com/feedback/26001/problem-with-custom-datasource-exporting-when-bind-data-using-sfdatamanager-to 

Query : so far I am not able to prepare an exact sample showing the behavior of Query 3 

As we are not certain about this issue and exact scenario, kindly get back to us with the requested details from our previous update if you need further assistance. 

Regards, 

Renjith R 

[Andrzej]

Hello, I cannot prepare a simple example for Query 3. The error appears only when the server is not fast, and a database must be quite big. However the problem still exists. I prepared a video showing how to get there and a link to the server where it happens. Could I send it in private mode?

[Renjith Singh Rajendran]

Hi Andrzej, 

We have created a new incident under your Direct trac account to follow up with this query. We suggest you follow up with the incident for further updates. Please log in using the below link.    

   

https://www.syncfusion.com/account/login 

 

Regards, 

Renjith R