This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DEVELOPERS FORUM - How do I tell what package an itemType is part of

オフライン Archive User 12 年以上前

BKolb - Friday, November 15, 2013 9:28 AM:

It has to be staring me in the face, but I can't figure out how to determine which package an itemType is part of. Can someone help me out?

Amit Nawale - Thursday, November 21, 2013 1:35 AM:

Open Sql Server Management Studio. Run following sql in your Database

that will give you name of your package.

Amit Nawale - Thursday, November 21, 2013 1:43 AM:

Open Sql Server Management Studio. Select your database. Run following sql that will give you name of your package.

select pacEle.SOURCE_ID as ElmentId,pacGrp.SOURCE_ID as GroupId,pacDef.NAME,pacDef.ID from

innovator.PACKAGEELEMENT pacEle,innovator.PACKAGEGROUP pacGrp, innovator.PACKAGEDEFINITION pacDef

where pacEle.SOURCE_ID = pacGrp.ID and pacGrp.SOURCE_ID = pacDef.ID

and pacEle.NAME like 'Part'

Amit Nawale - Thursday, November 21, 2013 1:50 AM:

Run Following Sql in Sql Server Management Studio.

select pacEle.SOURCE_ID as ElmentId,pacGrp.SOURCE_ID as GroupId,pacDef.NAME,pacDef.ID from

innovator.PACKAGEELEMENT pacEle,innovator.PACKAGEGROUP pacGrp, innovator.PACKAGEDEFINITION pacDef

where pacEle.SOURCE_ID = pacGrp.ID and pacGrp.SOURCE_ID = pacDef.ID

and pacEle.NAME like 'Part'

BKolb - Wednesday, November 27, 2013 9:31 AM:

Thanks much!