PeopleSoft

Integration Broker

PeopleSoft Integration Broker related articles, setups, tips and tricks.

Query to Retrieve the Compare Report Data for Projects created in App Designer

1> Run the Compare Reports successfully through App Designer and then run the following query to get the correct results.

SELECT DISTINCT (CASE WHEN PI.OBJECTTYPE=0 THEN 'Record'
             WHEN PI.OBJECTTYPE=1 THEN 'Index'
             WHEN PI.OBJECTTYPE=2 THEN 'Field'
             WHEN PI.OBJECTTYPE=3 THEN 'Field Format'
             WHEN PI.OBJECTTYPE=4 THEN 'Translate'
             WHEN PI.OBJECTTYPE=5 THEN 'Page'
             WHEN PI.OBJECTTYPE=6 THEN 'Menu'
             WHEN PI.OBJECTTYPE=7 THEN 'Component'