APEX-PLUGIN.COM

..the apex plugin directory

an initiative of
 

Latest Plugins

 

Top Rated Plugins

Context(rightclick) Menu (4.9)10
Combobox (4.8)10
SkillBuilders Super LOV (4.8)10
(IR) Report to Excel (xlsx) (4.8)10
DTreeTable (4.8)10

Add your APEX4.0 Plugin info

Describe your Plugin’s features. You can upload the Plugin’s code and documentation, or, alternatively, submit the URLs to your website or blog.

You are here:
Follow us on Twitter
Region Plugin Gantt Chart

Gantt Chart

10
Categories: Region Plugin
Author: Ivan Zderadicka

Gantt chart region plugin

Gantt 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)
Licensed by either MIT or GPL v3 license.

v0.1.1 - fixed jQuery component - there was a bug on hours scale when changing to DST 


Keywords
chart gantt

Company:
Date added: 7.1.2013
Views: 1850
Votes: 1
Reviews: 4
Min. APEX Version:
4.1
Share on Facebook
Digg! Share on Digg
Save This Page
Link to:
Download
download apex plugin
If something is not correct please report it here: Report Listing
Highslide JS
Do you have a question about this Plugin? Want to write a Review or Comment?
 Login first.
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
0 
Enquiry about gantt SQL syntax
by Emma Saunders
on March 28, 2013
Hello there

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:

SELECT
ACTIVITIES_ID AS ROW_ID,
ACTIVITIES_NAME ROW_NAME,
ACTIVITIES_DESC ROW_DESC,
ACTIVITIES_ID as TASK_ID,
ACTIVITIES_TEST_TP1 TASK_FROM,
ACTIVITIES_TP2 TASK_TO,
ACTIVITIES_NAME TASK_LABEL,
ACTIVITIES_DESC TASK_DESCRIPTION,
ACTIVITIES_PROJECTFLAG TASK_TYPE
FROM AA_WL_ACTIVITIES3
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
Thanks
Emma
0 
re:syntax issue
by Ivan Zderadicka
on March 21, 2013
The syntaxtError is rised probably by JASON parsing - there can be two reasons - some special characters in data that will confuse creation of JSON or invalid query (which I see as more probable) - if source query fails, then AJAX response contains rather error message then JSON - this then confuses JS and it raises this error.

I'll recommend first to use Firebug and see what is content of AJAX requests. If there are some error messages instead of JSON test your query - possibly outside of page - in SQL developer or something like this.
March 21, 2013
The Entry has been updated in the meantime!
0 
syntax issue
by Scott
on February 8, 2013
I couldn't get this to work without error - I kept receiving:
parsererrror
SyntaxError: Unexpected token <

Note when I took out gantt.js there was no error - but no chart rendered.
0 
Reg: How to implement this plug-in
by Raajkumar
on January 31, 2013
Hi,

Thanks for the good work. But please provide steps to use this plug-in in Apex 4.2

Raaj
Powered by Sigsiu.NET RSS Feeds

Disclaimer: The APEX Plugins on this site are not supported by Oracle Support Services.

If you have a question about a Plugin or need support: Login and select the plugin detail page. At the bottom you can enter your Question / Review / Remark.
Your message will be sent to the author of the plugin.