How to get LifecycleTemplate state
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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';
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
