Excel Like Filter in Gantt Chart

[Rodrigo]

Hi, is it possible to set the Excel Like Filter in Gantt Chart columns. Only Menu Like Filter in the documentation

https://ej2.syncfusion.com/aspnetmvc/documentation/gantt/filtering/

Thank you

[Monisha Sivanthilingam]

Hi Rodrigo, 

 

Greetings from Syncfusion support. 

 

We can set the type of the filter as Excel in the load event. The following code snippets demonstrate the solution. 

 

Index.cshtml 

 

<script> 

function load(args) { 

  var ganttObj = document.getElementById("Gantt").ej2_instances[0]; 

   ganttObj.treeGrid.filterSettings.type = "Excel"; 

} 

</script> 

 

 

We have prepared a sample for your reference. 

 

Please contact us if you require any further assistance. 

 

Regards, 

Monisha. 

[Rodrigo]

Thank you! Works Great!

[Rodrigo]

Hi Monisha, the solution provided works perfectly. I have the following issue: if i add a button to refresh the data, after update shows an error. 

The code for update is this one:

var ganttObj = document.getElementById("sfGantt").ej2_instances[0];
ganttObj.refresh();

Shows the following error:

Thanks for your help

Regards

[Monisha Sivanthilingam]

Hi Rodrigo, 

  

We have analyzed your query, however, we were unable to replicate the reported issue. Can you please share more details about the issue you faced, such as: 

  

1. What are the use cases in which the issue occurred ?
2. What are the steps to be taken to replicate the issue ?
3. If possible, please share an issue reproducible sample or modify the below attached sample to replicate your issue.

  

Sample: https://www.syncfusion.com/downloads/support/forum/168503/ze/F1685031047172754 

  

Regards, 

Monisha. 

[Rodrigo]

Hi Monisha, i'm attaching the project. If you filter any column, an error is display. I'm attaching the sequence:

Thank for your help.

Regards,

Attachment: project_refresh_1a482014.zip

[Monisha Sivanthilingam]

Hi Rodrigo, 

 

Thank you for sharing the additional details. 

 

We were able to replicate the issue. We will validate it and provide you with further details within one business day(November 26, 2021). 

 

We appreciate your patience until then. 

 

Regards, 

Monisha. 

[Monisha Sivanthilingam]

Hi Rodrigo, 

  

Thank you for your patience. 

  

We have analyzed the issue you reported and we would like to tell you that we have not completely provided support for Excel type filtering in Gantt Chart. While, we can achieve it through the work-around we shared previously, most of the functionalities are missing. This is the reason why you are facing this issue. However, we have logged a feature report to provide Excel type filtering in Gantt Chart. You can track its status from the below feedback link. 

  

Feedback: https://www.syncfusion.com/feedback/25434/provide-excel-filter-support-in-gantt 

  

As we have already lined up some major features, we could not implement this support immediately. We will implement this and include it in any of our upcoming releases. Please cast your vote on this feature. Based on the customer demand we will prioritize the features in our upcoming road map. 

   

Regards, 

Monisha. 

[Rodrigo]

Hi Monisha, thank you very much for your support.

Regards.

[Ranjani Prabakaran]

Hi Rodrigo, 

Please contact us if you need any further assistance. 

Regards,

Ranjani