Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

KDRV_PROJECTS Table?

Highlighted
Amanjyot
Super Collector

KDRV_PROJECTS Table?

Could anyone tell me for what purpose KDRV_PROJECTS  table is used?

 

Thanks in advance.

4 REPLIES
Utkarsh_Mishra
Honored Contributor

Re: KDRV_PROJECTS Table?

KDRV_PROJECTS table was used in version 6.0 and from 7.x it has been removed.

 

This table contains all the header information of a Project or task defined in Drive; you can get more details in 6.0 TRM.

 

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
AlexSavencu
Honored Contributor

Re: KDRV_PROJECTS Table?

Hi,

In newer versions, this is a view which contains denormalized data related to projects and work plan tasks altogether.

Cheers
Alex

--remember to kudos people who helped solve your problem
Amanjyot
Super Collector

Re: KDRV_PROJECTS Table?

Hi Alex,

 

I found only one task for a  project  entry in this table instead of all tasks which are there in work plan.

AlexSavencu
Honored Contributor

Re: KDRV_PROJECTS Table?

Hi,

You should check the query behind the view, maybe it is doing extra filtering.

Anyways, I would not recommend you to write your portlets or reports based on this view.

Cheers
Alex

--remember to kudos people who helped solve your problem
//Add this to "OnDomLoad" event