how to save my data

[adiarnon]

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

[avinashelite]

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.

[#3]

Could you please attach an example?

[pokassov]

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