Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/content/12/8647612/html/index.php:4) in /home/content/12/8647612/html/includes/bootstrap.inc on line 1162

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/12/8647612/html/index.php:4) in /home/content/12/8647612/html/includes/bootstrap.inc on line 1162

Warning: Cannot modify header information - headers already sent by (output started at /home/content/12/8647612/html/index.php:4) in /home/content/12/8647612/html/includes/bootstrap.inc on line 726

Warning: Cannot modify header information - headers already sent by (output started at /home/content/12/8647612/html/index.php:4) in /home/content/12/8647612/html/includes/bootstrap.inc on line 727

Warning: Cannot modify header information - headers already sent by (output started at /home/content/12/8647612/html/index.php:4) in /home/content/12/8647612/html/includes/bootstrap.inc on line 728

Warning: Cannot modify header information - headers already sent by (output started at /home/content/12/8647612/html/index.php:4) in /home/content/12/8647612/html/includes/bootstrap.inc on line 729
PeopleSoft | CompShack.com

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'