Gantt Chart Tweet
Gantt chart region pluginGantt Chart plugin is based on an existing jQuery plugin, however this plugin is patched significantly to work for my use-case (scale hours and days, limited by dates in page items).
To work correctly user db session and browser should have same TZ (otherwise chart bars are moved - actually displayed according to browser TZ) - so use auto-timezone application setting or something more sophisticated . Also assure that date ranges displayed are 'reasonable' - for too wide range script will block ( much more then is displayed on screen) , for too small it'll display nonsence (less then day, or only few days on day scale)
Sources also on github:
Do you have a question about this Plugin? Want to write a Review or Comment?
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
this will activate when exisitng task is clicked on chart
alert('Tasked clicked,id is: '+this.data.id);
then you need to construct URL to openen in JS.
Add New Task:
this will activate, when you click on grid outside of any task.
this.data.date contains a Date object with date value reflecting where you clicked on grid . this.data.id is then id of row.
out of this great gantt I was trying to link to the detailed form of the task but failed. If you managed this, can you provide how? -Thanks, F.
I optimized hours-days - so lower scacles might need some tweeks in JS.
Thanks a lot !
Could you put your sources in the zip file ?
It would allow us to create the plugin in apex 4.1, without you having to make your own in 4.1.
I'd love to use your gantt plugin but I am getting the same syntax error. I have pasted below my SQL in case it is obvious to you what the problem is:
ACTIVITIES_ID AS ROW_ID,
ACTIVITIES_ID as TASK_ID,
WHERE ACTIVITIES_TEST_TP2 > to_date(:P1_STARTDATE,'DD-MMM-YYYY')
AND ACTIVITIES_TEST_TP1 < to_date(:P1_ENDDATE,'DD-MMM-YYYY')
ORDER BY ROW_NAME, ROW_DESC
ACTIVITIES_TEST_TP1 and 2 are both "timestamp with time zone" columns.
I'd be grateful for any help
|Powered by Sigsiu.NET|