Filter on Ganttchart in Oracle apex

[ShantveerS]

Dear Sir,
I have few textfields and drop down on my gantt chart page. I want to filter the gantt chart based on these fields. I can do it, but I need to submit the page to refresh the gantt chart data.

How can I filter Gantt chart dynamically, without submitting the page. ?

Thanks,
Shantveer

[ShantveerS]

Also, I have huge data in Gantt Chart and How can I improve the performance as Gantt chart getting loaded very slowly.

[ogobrecht]

Dear Shantveer,

the Gantt chart can be refreshed with a partial page refresh (AJAX) like many other regions in APEX. All you have to do is to create a dynamic action on a button click or a item change and as the true action select "Refresh", as selection type "Region" and as Region your Gantt chart:

To bring your items needed for the region query into session state you have to provide them under "Page Items to Submit" - in my example are no items selected for session state because the query does not need them at the moment:

I have no idea how many data you load at the moment and where your bottleneck is - could be anything (query performance, network speed...). Normally the JavaScript in the frontend will not be the problem. As an first test please simply put #TIMING# in the footer of your Gantt chart region. APEX will then provide the runtime of your query in seconds in the region footer. You can do this trick also in other regions like classic or interactive reports.

Hope this helps, best regards
Ottmar