Difference between revisions of "PS Query Transformations"
From TekiWiki
(→Further Reading) |
|||
| Line 1: | Line 1: | ||
| − | + | Using Transformations in [[PeopleSoft]] [[PeopleSoft Query|Query]] can create files of the following types: | |
| + | |||
| + | * Text format - e.g. CSV, fixed columns | ||
| + | * HTML | ||
| + | * XML - e.g. SpreadsheetML (to produce formatted Excel spreadsheets). | ||
Additionally, pagelets can be built from PeopleSoft Query results. Annoyingly, the format for pagelets is slightly different from Query. However, both can be processed using XSLT (eXtensible Stylesheet Language - Transformations). | Additionally, pagelets can be built from PeopleSoft Query results. Annoyingly, the format for pagelets is slightly different from Query. However, both can be processed using XSLT (eXtensible Stylesheet Language - Transformations). | ||
Revision as of 23:27, 18 December 2016
Using Transformations in PeopleSoft Query can create files of the following types:
- Text format - e.g. CSV, fixed columns
- HTML
- XML - e.g. SpreadsheetML (to produce formatted Excel spreadsheets).
Additionally, pagelets can be built from PeopleSoft Query results. Annoyingly, the format for pagelets is slightly different from Query. However, both can be processed using XSLT (eXtensible Stylesheet Language - Transformations).
You still have all the capabilities of SQL in Query, and then you can add formatting using XSLT.
Further Reading
|
|
|
PeopleSoft Users Companion Extras
|
