Excel Filter Menu - Filters Search Item List - Datasource Binding

[Anbazhagan Annadurai]

Hi,

Appreciate for your response/support.

I have another question.

In your examples, even if there is no datasource has been provided for the , I still see there is lot of data’s shown in the Excel Filter Menu.

How is this been achieved?

I have successfully achieved the Grid and the Filter but unfortunately, this default content is not loading in my scenario.

It will save my day.

[Anbazhagan Annadurai]

Hi,

Appreciate for your response/support.

I have another question.

In your examples, even if there is no datasource has been provided for the , I still see there is lot of data’s shown in the Excel Filter Menu.

How is this been achieved?

I have successfully achieved the Grid and the Filter but unfortunately, this default content is not loading in my scenario.

It will save my day.

Hi, 

Appreciate for your response/support.

I have one more question.

Date Picker is not showing in the Filter Menu - Advance Filter - Date Field.

Thanks,

Anbu A.

[Ramdhas Ueikattan]

Hi Anbazhagan, 

Thanks for contacting syncfusion supports. 

Query1:  if there is no datasource has been provided for the , I still see there is lot of data’s shown in the Excel Filter Menu. 

We are analyzing your requirements and we need some details regarding the query. Please share the following details 

1. Please share the issue reproducing scenario.
2. Please share the grid version you have used.
3. If possible, please share the grid code.
4. Do you used any default query in Grid?
5. If possible, please reproduce the issue in below sample.

Query2: ‘Date Picker is not showing in the Filter Menu - Advance Filter - Date Field. 

We have checked the image and we suspect that the DOB column has string date value. By default the filter UI will load based on the type of the column. So the menu filter opens the string filter options. Please ensure the value of DOB property as JavaScript Date object.  

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/EJ2-dotnet-core2105731009.zip  

Please let us know if you have any concerns. 

Regards, 

Ramdhas  Ueikattan 

[Anbazhagan Annadurai]

Hi,

Thanks for your quick response.

I have given below my comments on your questions.

Query1:  if there is no datasource has been provided for the , I still see there is lot of data’s shown in the Excel Filter Menu. 

• Please share the issue reproducing scenario.
• Grid -> FilterMenu -> Select Checkbox option -> Click icon then you can see Search textbox with Options, In my case Options list is not showing.
• Expected Result:
• 
• The issue is Options is not showing even though, The column has values.
• 
  

     Please share the grid version you have used, I have given below attached image.

     

     

     If possible, please share the grid code.

          

     Do you used any default query in Grid?

     Answer: No, We are loading the data as JSON Array and used dataStateChange event to load the data.

 

Query2: ‘Date Picker is not showing in the Filter Menu - Advance Filter - Date Field. 

Answer: The issues has been resolved.

[Dhivya Rajendran]

Hi Anbazhagan , 

Thanks for your update, 

Currently the excel filter doesn’t have support to work with async pipe. We have logged “Need to provide support to bind excel filter data using async pipe” as a feature improvement. This feature is estimated to be available in our Essential JavaScript Volume 2, 2018 release. 

 

Regards,
R.Dhivya 

[Anbazhagan Annadurai]

Hi Team,

Thanks for supporting us very well.

When I will get Essential JavaScript Volume 2, 2018 release?

I would appreciate more if provide the release date since this issue is making us a development blocker issue.

Thanks,

Anbu A.

[Dhivya Rajendran]

Hi Anbazhagan, 

Thanks for your update, 

We have planned to roll out our Essential Studio Volume 2, 2018 release on end of May. Until then we appreciate your patience. 

Regards, 

R.Dhivya