Exporting from OMW

Hello All

Does anyone know if you can Export (eg, Projects) from OMW.
i want to export every project that is at a Status of 21 for exemple.

or is there a table that i can get this type of info from?

thanks

Hi!

Go to the FORM..on exit bar go to (Search by Object) then type 21 in
Project Status you will find the list of projects along with object
names you can export the data in excel sheet from there...

Hope this info will help you..


Thanks & Regards,
Lalit Ranka
Deloitte.
Senior Analyst - PeopleSoft [CNC]
Desk #A3F015, RMZ Futura, Block 'A'
Plot #14-15, Hi-tech City Layout
Madhapur,HYDERABAD -500 081, INDIA
* E-Mail: [email protected]
* Mobile: +91-9393001540
* Tel.: +1-615-738-4099; + 91-40-55744365;

If you have access to SQL, you can try the following. I am on the AS/400 and have access to SQL/400 and the following works for me to produce a list of projects and there objects where the projects are at status 21.

SELECT
F98221.PUOMWUSER,
F98220.PMOMWPRJID,
F98220.PMOMWDESC,
F98220.PMOMWPS,
F98222.POOMWOBJID
FROM
SYS7334/F98220
JOIN SYS7334/F98221 ON
F98220.PMOMWPRJID = F98221.PUOMWPRJID
LEFT JOIN SYS7334/F98222 ON
F98220.PMOMWPRJID = F98222.POOMWPRJID
WHERE
F98220.PMOMWPS = '21'
ORDER BY
F98221.PUOMWUSER,
F98220.PMOMWPRJID,
F98222.POOMWOBJID

does anybody know this statment for an Oracle DB?

greetingsneo

Try this:

SELECT PUOMWUSER, PMOMWPRJID, PMOMWDESC, PMOMWPS, POOMWOBJID
FROM SYS7334.F98220, SYS7334.F98221, SYS7334.F98222
WHERE PMOMWPRJID = PUOMWPRJID
AND PMOMWPRJID = POOMWPRJID
AND PMOMWPS = '21'
ORDER BY PUOMWUSER, PMOMWPRJID, POOMWOBJID

thanks peterbruce that works great

greetingsneo,

You could also try using a canned UBE : Project Objects Report - R98222A. It's very useful and quite easy to use/modify to fit your particular needs.

good luck!