How to get MapID with a Workflow ID...?

[nicolas46]

Hi,

Everything is in the title. I have the ID of a Workflow and i want the id of the workflow map.


Thanks for helping me.

 

[appnair]

I have written this for another purpose but I am sure the relations/tables are in there as well

http://www.tek-tips.com/viewthread.cfm?qid=1618245&page=2

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[nicolas46]

Thanks appnair.

The request i use now is just :

(select MAP_MAPOBJID from WMap where
map_MapID=(SELECT SubWork_MapID
FROM WSubWork where SubWork_WorkID=112665 and subwork_subworkid=112665))


I thinks it is ok.