AnsweredAssumed Answered

Help with program/subproject query in 7.5.3

Question asked by matpj on Jun 6, 2011
Latest reply on Sep 13, 2011 by allen.bollinger
Hi guys,

I have a wee little query which returns project ID's within a program.

For my testing on a couple of known programs this works lovely.

however, there is one (at least?!) program that it returns absolutely nothing:
select *
from 
(select tsk.prprojectid as parent_id, p.id, p.name
from niku.srm_projects p, niku.prtask tsk
where tsk.prexternalid = p.unique_name)
start with id = 5034499
connect by prior id = parent_id
Can anyone see anything wrong with this, or any reasons why a program might not return any results.
Are there different ways a program can be set up?


Thanks in advance,
Matt

Outcomes