PeopleSoft Query
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page PeopleSoft Query
| Line 1: | Line 1: | ||
| - | PeopleSoft Query (PS Query or just Query) is a | + | 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. | Queries can be created via a two tier client or via the web client. | ||
| Line 8: | Line 8: | ||
[[Dates in PS Query]] | [[Dates in PS Query]] | ||
| + | |||
| + | [[Getting More Out of PeopleSoft Query]] | ||
==Further Reading== | ==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] | [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] | ||
| + | |||
| + | |} | ||
