RE: [sqr-users] Question about upgrading from 8.3 to 8.9

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

You could also check out the PSPRSMDEFN table.  It contains the tree
structure of components and folders.  An important field is PORTAL_REFTYPE.
If it is "C", it is a component. If it is "F", it is a folder.  You may wish
to restrict PORTAL_NAME to "EMPLOYEE".  PORTAL_OBJNAME is the name of the
object, and PORTAL_PRNTOBJNAME is the parent's object name.  Objects at the
ROOT level have PORTAL_PRNTOBJNAME = "PORTAL_ROOT_OBJECT"


-----Original Message-----
From: Jeffrey Newton [mailto:jeffrey_d_newton@msn.com] 
Sent: Friday, August 11, 2006 11:59 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Question about upgrading from 8.3 to 8.9

Mike:  There are some SQRs on Customer Connection - they put them out for 
the change from 8.0 SP1 to 8.9, but they may provide what you need.  You 
might not expect where to find them because they are under the Campus 
Solutions documentation but they include the whole Campus Solutions / HCM 
system.  To find them on customer connection, go to:  Support, 
Documentation, Documentation Updates, Enterprise, Campus Solutions, All in 
Selected Product Line, Navigation Menu Mapping for Campus Solutions 8.9.


>From: "Moss, Mike " <MMoss@geico.com>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database reportinglanguage 
>fromHyperion Solutions." <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] Question about upgrading from 8.3 to 8.9
>Date: Fri, 11 Aug 2006 14:45:05 -0400
>
>Yeah, I saw that and used it to help work up the sql I have now, but I'm
>looking for the whole list.
>
>-----Original Message-----
>From: sqr-users-bounces+mmoss=geico.com@sqrug.org
>[mailto:sqr-users-bounces+mmoss=geico.com@sqrug.org] On Behalf Of Krist
>Dewilde
>Sent: Friday, August 11, 2006 2:35 PM
>To: 'This list is for discussion about the SQR database
>reportinglanguagefrom Hyperion Solutions.'
>Subject: RE: [sqr-users] Question about upgrading from 8.3 to 8.9
>
>Hi,
>
>You can retrieve this in PeopleTools > Portal >...  There is a component
>in where you can give your component name and it generates an overview
>of the navigation path(s).
>
>Regards,
>
>Krist Dewilde
>
>-----Original Message-----
>From: sqr-users-bounces+krist.dewilde=skynet.be@sqrug.org
>[mailto:sqr-users-bounces+krist.dewilde=skynet.be@sqrug.org] On Behalf
>Of Moss, Mike
>Sent: vrijdag 11 augustus 2006 20:17
>To: sqr-users@sqrug.org
>Subject: [sqr-users] Question about upgrading from 8.3 to 8.9
>
>We are upgrading from HRMS 8.3 to HRMS 8.9 and we are seeing that the
>navigation through the web is alot different than before.  Is there
>query or report that can be used to specify the portal navigation path
>for a given panelgroup name?
>====================
>This email/fax message is for the sole use of the intended
>recipient(s) and may contain confidential and privileged information.
>Any unauthorized review, use, disclosure or distribution of this
>email/fax is prohibited. If you are not the intended recipient, please
>destroy all paper and electronic copies of the original message.
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users
>
>
>
>
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users
>====================
>This email/fax message is for the sole use of the intended
>recipient(s) and may contain confidential and privileged information.
>Any unauthorized review, use, disclosure or distribution of this
>email/fax is prohibited. If you are not the intended recipient, please
>destroy all paper and electronic copies of the original message.
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users