How to get LifecycleTemplate state

[adev-2]

Hi,

how I can get the all lifecycle state name from lifecycletemplatemaster and lifecycletemplate right now I am running this query but it did not work for me, it just give me one lifecycle state name

select LifeCycleTemplateMaster.name, PhaseTemplate.name from lifecycletemplate, PhaseTemplate, LifeCycleTemplateMaster

where LifeCycleTemplateMaster.ida2a2 = lifecycletemplate.ida3masterreference and PhaseTemplate.ida2a2 = lifecycletemplate.ida3b9

and LifeCycleTemplateMaster.name = 'Action Item';

[sboddu-3]

Hi,

You can use below query.

select lctm.name, pt.name, pt.phaseState
from LifeCycleTemplateMaster lctm
join LifeCycleTemplate lct on lctm.idA2A2 = lct.idA3masterReference
join PhaseLink pl on lct.idA2A2 = pl.idA3A5
join PhaseTemplate pt on pl.idA3B5 = pt.idA2A2;

Regards

Srikanth