Changing first day of week and setting Filter type in datetime column filter's dropdown menu

[Lukasz Grosicki]

Hi,

Is it possible to change first day of  week in datetime column filter's dropdown menu?

I know that in normal datetime picker there is an option for that:

     MonthCalendar.FirstDayOfWeek = DayOfWeek.Monday

But I don't see how to do it inside filter pop up.

Second question,

Is it possible to set default filter types?

For example I'd like to set all date columns to default like this:

Regards,

[Mohanram Anbukkarasu]

Hi Lukasz, 

Thanks for the update.  

We are currently working on this. We will update with further details on April 16, 2021. We appreciate your patience until then.  

Regards, 

Mohanram A. 

[Mohanram Anbukkarasu]

Hi Lukasz, 

Thanks for your patience.  

Query	Solution
Is it possible to change first day of  week in datetime column filter's dropdown menu?  I know that in normal datetime picker there is an option for that:       MonthCalendar.FirstDayOfWeek = DayOfWeek.Monday	You can achieve this requirement by using SfDataGrid.FilterPopupShowing event as shown below.   this.sfDataGrid1.FilterPopupShowing += SfDataGrid1_FilterPopupShowing;    private void SfDataGrid1_FilterPopupShowing(object sender, Syncfusion.WinForms.DataGrid.Events.FilterPopupShowingEventArgs e)  {      if (e.Column is GridDateTimeColumn)      {          e.Control.DatePicker.FirstDayOfWeek = DayOfWeek.Wednesday;      }  }
Is it possible to set default filter types?	We are still working on this. We will update with further details on April 20, 2021. We appreciate your patience and understanding.

Regards, 

Mohanram A. 

[Mohanram Anbukkarasu]

Hi Lukasz, 

 

We regret for the inconvenience.  

 

We are still working on this. We will update with further details on April 22, 2021. We appreciate your patience and understanding.   

 

Regards, 

Mohanram A. 

[Mohanram Anbukkarasu]

Hi Lukasz, 

We regret for the inconvenience.  

We are still working on this. We will update with further details on April 26, 2021. We appreciate your patience and understanding.  

Regards, 

Mohanram A. 

[Mohanram Anbukkarasu]

Hi Lukasz, 

Thanks for your patience.  

We have analyzed in our source. We are unable to change the value of the combo boxes within the FilterPopupShowing event. It is confirmed as a defect. We have logged a bug report on this regard.  

Feedback link : https://www.syncfusion.com/feedback/24714/firstconditioncombobox-and-secondconditioncombobox-value-cannot-be-changed-in  

We will fix the issue and include the fix for this issue in our NuGet package which is planned to be released on May 11, 2021. We will let you know once it is release with the fix. We appreciate your patience until then.  

Regards, 

Mohanram A. 

[Mohanram Anbukkarasu]

Hi Lukasz, 

We regret for the inconvenience.  

Due to our 2021 Volume 1 Service Pack release is planned this week, our NuGet package planned to be release today is not release as planned. We will include the fix for the reported issue in our next NuGet package which will be release after our 2021 Vol1 SP release. We will let you know once it is released with the fix. We appreciate your patience and understanding. 

Regards, 

Mohanram A. 

[Mohanram Anbukkarasu]

Hi Lukasz, 

  

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 ins our upcoming NuGet which is planned to be released on June 15, 2021. We appreciate your patience and understanding.  

  

Regards,  

Mohanram A.  

[Mohanram Anbukkarasu]

Hi Lukasz, 

We regret for the inconvenience.  

We are unable to include the fix for this issue in our NuGet package which is release today as promised. Our 2021 Volume 2 main release is scheduled on next week. Due to this we don’t have NuGet release for next week. So we will make effort to include the fix for the issue in our upcoming 2021 Volume 2 main release. Otherwise we will provide custom assemblies for the fix on June 23, 2021. We appreciate your patience and understanding.  

Regards, 

Mohanram A. 

[Vijayarasan Sivanandham]

Hi Lukasz,

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 SfDataGrid1_FilterPopupShown(object sender, Syncfusion.WinForms.DataGrid.Events.FilterPopupShownEventArgs e) 

{ 

       if (e.Column is GridDateTimeColumn && e.Column.FilterPredicates != null && e.Column.FilterPredicates.Count < 0) 

      { 

          e.Control.FirstConditionComboBox.SelectedIndex = 5; 

          e.Control.FirstConditionComboBox.Text = "After or Equal"; 

          e.Control.SecondConditionComboBox.SelectedIndex = 3; 

          e.Control.SecondConditionComboBox.Text = "Before or Equal"; 

     } 

} 

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