Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I need to model data from MS project.
I have a problem - how to save the data of the dependencies between tasks.
I have a table-
PREV TASK
CURRENT TASK
i need that if im selecting one of ny tasks i wiil see-
1. all the tasks that must be before
2. all the tasks that this task is "pushing"
how should i save my data?
adi
Hi adi,
I don't know how your data is organised in the DB .
if you have all the details in a single table then its very easy, just pull the data and store it an QVD so that it will have the previous and next task as columns. If not make it as 3 different tables i.e the previous task details, next task details with the primary key for it .
Hope this helps you.
Could you please attach an example?
Hi Adi!
I think you should see Hierarchy and HierarchyBelongsTo
//example data
t1:
LOAD * Inline [
NodeID, ParentID, NodeName, TimeLength
1,, Task 1, 10
2,1, Task 1.1, 12
3,1, Task 1.2, 2
4, 2, Task 1.1.1, 4
5, 4, Task 1.1.1.1, 5
];
//for your first question:
//field NodeName is your selected task
// field ParentName are its previos tasks
t2:
HierarchyBelongsTo (NodeID, ParentID, NodeName, Tree, ParentName) LOAD
NodeID,
ParentID,
NodeName
Resident
t1;
DROP Table t1;
//for your second question:
// you can
//t2:
//Hierarchy(NodeID, ParentID, NodeName,ParentName,NodeName, Task, '/') LOAD
//NodeID,
//ParentID,
//NodeName,
//TimeLength
//Resident
// t1;
Btw, I don't now how to use both ways for your model