Difference between revisions of "PeopleSoft Query"
From TekiWiki
(→Further Reading) |
|||
| Line 24: | Line 24: | ||
[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] | [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] | ||
| + | |||
| + | |- | ||
| + | |||
| + | |[[File:Transform-PeopleSoft-Query.JPG|90px|link=http://bit.ly/PS_XSLT_BOOK]] | ||
| + | |||
| + | | | ||
| + | [http://bit.ly/PS_XSLT_BOOK Transforming PeopleSoft Query] | ||
| + | |||
| + | [[PeopleSoft Query]] | ||
| + | |||
| + | |[[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]] | ||
| + | |||
| + | |||
|} | |} | ||
Revision as of 22:56, 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 Prompts in Case Expressions
Getting More Out of PeopleSoft Query
Further Reading
|
For more information about functions in PeopleSoft Query and some other interesting stuff too, read our eBook: | |
|
PeopleSoft Query |
|
