Difference between revisions of "PeopleSoft Query"

From TekiWiki
Jump to: navigation, search
(Further Reading)
(Further Reading)
Line 27: Line 27:
 
|-
 
|-
  
|[[File:Transform-PeopleSoft-Query.JPG|95px|link=http://bit.ly/PS_XSLT_BOOK]]
+
|[[File:Transform-PeopleSoft-Query.JPG|100px|link=http://bit.ly/PS_XSLT_BOOK]]
  
 
|Plus find out how to transform your PeopleSoft Query results into something spectacular:
 
|Plus find out how to transform your PeopleSoft Query results into something spectacular:

Revision as of 23:03, 15 December 2016

PeopleSoft Query is a PeopleTool that creates a report based on a user defined SQL statement. The output can be shown in a web page or downloaded to Microsoft Excel, Crystal Reports or BI Publisher (used to be XML Publisher). PeopleSoft Query is sometimes also called PS Query or just Query.

Queries can be created via a two tier client or via the web client.

Using Expressions in PS Query

Using Prompts in Case Expressions

Dates in PS Query

Getting More Out of PeopleSoft Query

Making Use of Translate

PS Query Transformations

Further Reading

UsingFunctionsInPeopleSoftQuerySmall.jpg For more information about functions in PeopleSoft Query and some other interesting stuff too, read our eBook:

Using Functions in PeopleSoft Query

Transform-PeopleSoft-Query.JPG Plus find out how to transform your PeopleSoft Query results into something spectacular:

Transforming PeopleSoft Query