PeopleSoft Query

PeopleSoft Query (PS Query or just Query) is a [[PeopleTools|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).

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]]

==Further Reading==

{| class="wikitable"
|-
|[[File:UsingFunctionsInPeopleSoftQuerySmall.jpg|90px|link=http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21]]

|For more information about functions in [[PeopleSoft Query]] and some other interesting stuff too, read our eBook:

[http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21 Using Functions in PeopleSoft Query]

|}