Difference between revisions of "PeopleSoft Query Tips and Tricks"

From The University of Akron Support Wiki
Jump to: navigation, search
Line 2: Line 2:
  
 
== Oracle Nuances ==
 
== Oracle Nuances ==
 
+
=== Oracle dates in the field list ===
  
 
== PSQuery Limitations ==
 
== PSQuery Limitations ==
 +
=== Maximum of 26 records ===
 +
PSQuery can have a maximum of 26 records in a query. This limitation is a result of how aliases are assigned to the recrods, namely via the alphabet [A-Z], and there is no handling for what happens after the "Zth" table is added.  It does not assign an alias and the query breaks.
  
 
== Other PSQuery Tips ==
 
== Other PSQuery Tips ==
 
=== Adding Oracle Hints to PSQueries ===
 
=== Adding Oracle Hints to PSQueries ===
 
I haven't tried it yet, but [http://blogs.hexaware.com/peoplesoft/2007/08/adding-hint-to-.html here] is a step-by-step on adding an Oracle hint to a PSQuery
 
I haven't tried it yet, but [http://blogs.hexaware.com/peoplesoft/2007/08/adding-hint-to-.html here] is a step-by-step on adding an Oracle hint to a PSQuery

Revision as of 20:42, 29 September 2008

PSV9 > Oracle Knowledge Base

Oracle Nuances

Oracle dates in the field list

PSQuery Limitations

Maximum of 26 records

PSQuery can have a maximum of 26 records in a query. This limitation is a result of how aliases are assigned to the recrods, namely via the alphabet [A-Z], and there is no handling for what happens after the "Zth" table is added. It does not assign an alias and the query breaks.

Other PSQuery Tips

Adding Oracle Hints to PSQueries

I haven't tried it yet, but here is a step-by-step on adding an Oracle hint to a PSQuery