cancel
Showing results for 
Search instead for 
Did you mean: 
Security Alert Log4j Security Vulnerability. Click here to know more.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to get LifecycleTemplate state

adev-2
4-Participant

How to get LifecycleTemplate state

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';

1 REPLY 1
sboddu-3
5-Regular Member
(To:adev-2)

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

Announcements