BKolb - Friday, November 15, 2013 10:51 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. Is it shown somewhere? I want to export a change I've made, but I don't know how to figure out which package the item I changed is in.
DavidSpackman - Monday, November 25, 2013 12:10 AM:
It's not very easy to find in Aras. I prefer to do it in SQL.
Here is an example of a larger script I use
-----------------------------------------------------------------------------------
--Item Type Information
SELECT
A.[KEYED_NAME] as '[KEYED_NAME]ITEMTYPE'
,innovator.ConvertToLocal(A.[MODIFIED_ON],DEFAULT) AS [MODIFIED_ON]
,A.IS_RELATIONSHIP
,[CREATED_BY_ID] = U1.KEYED_NAME
,[MODIFIED_BY_ID] = U2.KEYED_NAME
,PD.NAME AS PACKAGE_NAME
, CASE WHEN PD.NAME IS NOT NULL AND A.IS_RELATIONSHIP = 1 THEN 'ERROR' ELSE 'OK' END AS [ERROR_CHECK]
FROM
[innovator].ITEMTYPE A
FULL JOIN [innovator].[USER] U1 ON U1.ID = A.CREATED_BY_ID
FULL JOIN [innovator].[USER] U2 ON U2.ID = A.MODIFIED_BY_ID
FULL JOIN [innovator].PACKAGEELEMENT PE ON PE.ELEMENT_ID = A.ID
FULL JOIN [innovator].PACKAGEGROUP PG ON PG.ID = PE.SOURCE_ID
FULL JOIN [innovator].PACKAGEDEFINITION PD on PD.ID = PG.SOURCE_ID
ORDER BY
A.[MODIFIED_ON] desc
-----------------------------------------------------------------------------------
BKolb - Wednesday, November 27, 2013 9:32 AM:
Thank you very much!
