Wednesday, September 23, 2009

Extract Project Objects Using an SQL


The query below will return all the objects inside of an Application Designer project. You can then copy the rows and paste them where ever you'd like.

SELECT
(CASE OBJECTTYPE WHEN 0 THEN 'Record'
WHEN
1 THEN 'Index'
WHEN
2 THEN 'Field'
WHEN
3 THEN 'Field Format'
WHEN
4 THEN 'Translate Value'
WHEN
5 THEN 'Pages'
WHEN
6 THEN 'Menus'
WHEN
7 THEN 'Components'
WHEN
8 THEN 'Record PeopleCode'
WHEN
9 THEN 'Menu PeopleCode'
WHEN
10 THEN 'Query'
WHEN
11 THEN 'Tree Structures'
WHEN
12 THEN 'Trees'
WHEN
13 THEN 'Access group'
WHEN
14 THEN 'Color'
WHEN
15 THEN 'Style'
WHEN
16 THEN 'N/A'
WHEN
17 THEN 'Business process'
WHEN
18 THEN 'Activity'
WHEN
19 THEN 'Role'
WHEN
20 THEN 'Process Definition'
WHEN
21 THEN 'Server Definition'
WHEN
22 THEN 'Process Type Definition'
WHEN
23 THEN 'Job Definitions'
WHEN
24 THEN 'Recurrence Definition'
WHEN
25 THEN 'Message Catalog'
WHEN
26 THEN 'Dimension'
WHEN
27 THEN 'Cube Definitions'
WHEN
28 THEN 'Cube Instance Definitions'
WHEN
29 THEN 'Business Interlink'
WHEN
30 THEN 'SQL'
WHEN
31 THEN 'File Layout Definition'
WHEN
32 THEN 'Component Interfaces'
WHEN
33 THEN 'AE program'
WHEN
34 THEN 'AE section'
WHEN
35 THEN 'Message Node'
WHEN
36 THEN 'Message Channel'
WHEN
37 THEN 'Message'
WHEN
38 THEN 'Approval rule set'
WHEN
39 THEN 'Message PeopleCode'
WHEN
40 THEN 'Subscription PeopleCode'
WHEN
41 THEN 'N/A'
WHEN
42 THEN 'Component Interface PeopleCode'
WHEN
43 THEN 'AE PeopleCode'
WHEN
44 THEN 'Page PeopleCode'
WHEN
45 THEN 'Page Field PeopleCode'
WHEN
46 THEN 'Component PeopleCode'
WHEN
47 THEN 'Component Record PeopleCode'
WHEN
48 THEN 'Component Rec Fld PeopleCode'
WHEN
49 THEN 'Image'
WHEN
50 THEN 'Style sheet'
WHEN
51 THEN 'HTML'
WHEN
52 THEN 'Not used'
WHEN
53 THEN 'Permission List'
WHEN
54 THEN 'Portal Registry Definitions'
WHEN
55 THEN 'Portal Registry Structures'
WHEN
56 THEN 'URL Definitions'
WHEN
57 THEN 'Application Packages'
WHEN
58 THEN 'Application Package Peoplecode'
WHEN
59 THEN 'Portal Registry User Homepage'
WHEN
60 THEN 'Problem Type'
WHEN
61 THEN 'Archive Templates'
WHEN
62 THEN 'XSLT'
WHEN
63 THEN 'Portal Registry User Favorite'
WHEN
64 THEN 'Mobile Page'
WHEN
65 THEN 'Relationships'
WHEN
66 THEN 'Component Interface Property Peoplecode'
WHEN
67 THEN 'Optimization Models'
WHEN
68 THEN 'File References'
WHEN
69 THEN 'File Type Codes'
WHEN
70 THEN 'Archive Object Definitions'
WHEN
71 THEN 'Archive Templates (Type 2)'
WHEN
72 THEN 'Diagnostic Plug In'
WHEN
73 THEN 'Analytic Model'
ELSE
'UNKNOWN OBJECT TYPE' END)
AS OBJECTTYPE
, OBJECTVALUE1
, OBJECTVALUE2
, OBJECTVALUE3
, OBJECTVALUE4
FROM PSPROJECTITEM
 
WHERE PROJECTNAME =
'Your_Project'
--- Replace w/ your project name
 
ORDER
BY OBJECTTYPE, OBJECTVALUE1, OBJECTVALUE2, OBJECTVALUE3;

If you would like to extract objects that are only marked for migration then add the following into the "Where" clause:

AND TAKEACTION =
'1'
-- 1 means checked for upgrade
-- 0 means do not upgrade

0 comments:

Post a Comment

Total Pageviews

Copyright © Tech & Management Notes