[SOLVED] Â Gantt Chart |
9/5/2018 10:50:31 PM |
PHPRunner General questions | |
M
Melanie authorDevClub member
I followed the tutorial for Adding GANTT chart to PHPRunner/ASPRunnerPro app - it was straightforward and seems like it will work very well for what we want to do, but I cannot make it work. I set up 2 tables with the same names and fields as in the tutorial and they have data in them with a common link (1 distinct project record to multiple tasks). I did use a different column name in each table for the link (instead of projectid I am using aircraft_oid which has 1 record in the project table and many in the task table). I then edited the gantt.php table with this change ($sql = "select * from tblTasks where aircraft_oid=".$_REQUEST["aircraft_oid"]." Order by TaskNumber"; ) and edited the snippet in my View page ( |
|
![]() |
fhumanes 9/6/2018 |
Please, |
M
|
Melanie authorDevClub member 9/6/2018 |
I was using custom views and not tables for my Gantt and this was not working - I created 2 views in my SQL database named tblProject and tblTasks and I can now get a Gantt chart. My next problem is that my query pulls 5 years worth of projects and of course even if I filter the data on my page, the Gantt sill uses everything in the Tasks table - so I need to see if I can pass a date range as well as the projectid. |
M
|
Melanie authorDevClub member 9/7/2018 |
I was using custom views and not tables for my Gantt and this was not working - I created 2 views in my SQL database named tblProject and tblTasks and I can now get a Gantt chart. My next problem is that my query pulls 5 years worth of projects and of course even if I filter the data on my page, the Gantt sill uses everything in the Tasks table - so I need to see if I can pass a date range as well as the projectid. Thanks to the excellent support from xlinesoft for their help!.
|