Setting Filter option to "AND" on DateTime column type

[John Kelly]

Hello,

When a user filters a column with a datetime type, we want the default option in the filter window to be AND instead of OR. I have attached a ZIP with the screen. I am trying this code but am unsuccessful:

sfDataGrid1.FilterPopupShowing += SfDataGrid1_FilterPopupShowing;

        private void SfDataGrid1_FilterPopupShowing(object sender, Syncfusion.WinForms.DataGrid.Events.FilterPopupShowingEventArgs e)
        {
            if (e.Column is GridDateTimeColumn)
            {
                e.Control.OrRadioButton.Checked = false;
                e.Control.AndRadioButton.Checked = true;
            }
        }

Can you please help?

Attachment: Filter_b498afde.zip

[Vijayarasan Sivanandham]

Hi John Kelly,

Thank you for contacting Syncfusion support.

We could be able to reproduce your reported issue “Setting Filter option to "AND" on DateTime column type but not reflected in GridFilter in SfDataGrid” from our end. We will validate and update you details on or before May 19, 2021.  

We appreciate your patience until then.

Regards,
Vijayarasan S 

[Vijayarasan Sivanandham]

Hi John Kelly,

Thank you for your patience. 

We have created bug report for the reported issue “GridFilterControl appearance customized by using FilterPopupShowing event is not reflected”. We will fix this issue and include in our Jun 08th ,2021 NuGet release.

You can track the status of this report through the following feedback link,

Feedback link:  https://www.syncfusion.com/feedback/24714/gridfiltercontrol-appearance-customized-by-using-filterpopupshowing-event-is-not 

Note: The provided feedback link is private, and you need to login to view this feedback.

We appreciate your patience until then.

Regards,
Vijayarasan S 

[Vijayarasan Sivanandham]

Hi John Kelly,

We regret for the inconvenience.

We are unable to include the fix for this issue in our NuGet package which is release today. We will include the fix for this in our upcoming NuGet which is planned to be released on June 15, 2021.

We appreciate your patience and understanding.   

Regards,
Vijayarasan S 

[Vijayarasan Sivanandham]

Hi John Kelly,

Sorry for the inconvenience caused.

We are facing difficulties while fixing this issue “GridFilterControl appearance customized by using FilterPopupShowing event is not reflected”. We are working on this with high priority. And unfortunately, we did not include this fix in this weekly NuGet. So, this fix we will be included in our Essential Studio 2021 Volume 2 release which is expected to be rolled out in the end of June 2021 or We will provide the custom assembly for reported problem on June 23, 2021.

We appreciate your patience until then.

Regards,
Vijayarasan S

[Vijayarasan Sivanandham]

Hi John Kelly,

Thank you for your patience.

While we are fixing this issue “GridFilterControl appearance customized by using FilterPopupShowing event is not reflected”, This breaks the existing behavior in SfDataGrid. We are currently working on this implementation. On analysis, we have found that we are able to provide support to achieve your requirement using FilterPopupShown event without Filter applied case.  The pseudo code of the FilterPopupShown workaround is given below.  

 

private void SfDataGrid_FilterPopupShown(object sender, Syncfusion.WinForms.DataGrid.Events.FilterPopupShownEventArgs e)
{
      if (e.Column.FilterPredicates != null || e.Column.FilterPredicates.Count > 0)
            return; 

     //Enable the AND operatio in the advancefilter
     e.Control.OrRadioButton.Checked = false;
     e.Control.AndRadioButton.Checked = true; 

} 

However, we need make changes in source level to use this workaround. Kindly confirm whether you are able to use such workaround to achieve this or not. We will proceed to implement this only based on your confirmation. Kindly revert to us if you have any concerns in this. 

Regards,
Vijayarasan S 

[John Kelly]

Yes I would be able to use the code you suggested. Please let me know when the workaround is implemented and I can confirm on my end. Thank you.

[Vijayarasan Sivanandham]

Hi John Kelly,

Thanks for the update.

Based on confirmation we will implement this workaround and include in our July 06th ,2021 NuGet release. We will let you know once it is released.

We appreciate your patience until then.

Regards,
Vijayarasan S

[Vijayarasan Sivanandham]

Hi John Kelly,

Thank you for your patience.

We are glad to announce that our latest weekly NuGet package update version 19.2.0.46 has been is rolled out with the “GridFilterControl appearance customized by using FilterPopupShowing event is not reflected” and is available for download. 

Feedback link: https://www.syncfusion.com/feedback/24714/gridfiltercontrol-appearance-customized-by-using-filterpopupshowing-event-is-not 

Your requirement can be achieved by customizing the FilterPopupShown event SfDataGrid. Please refer the below code snippet, 

sfDataGrid.FilterPopupShown += SfDataGrid_FilterPopupShown; 

private void SfDataGrid_FilterPopupShown(object sender, Syncfusion.WinForms.DataGrid.Events.FilterPopupShownEventArgs e) 

{ 

            if (e.Column is GridDateTimeColumn) 

            { 

                //Enable the AND operatio in the advancefilter 

                e.Control.OrRadioButton.Checked = false; 

                e.Control.AndRadioButton.Checked = true; 

            }            

}     

Sample Link: https://www.syncfusion.com/downloads/support/forum/165478/ze/DateTimeSample1794678104 

Please let us know if you have any concerns in this.

Regards,
Vijayarasan S