Difference between revisions of "PS Query Transformations"
From TekiWiki
| Line 11: | Line 11: | ||
You still have all the capabilities of SQL in Query, and then you can add formatting using XSLT. | You still have all the capabilities of SQL in Query, and then you can add formatting using XSLT. | ||
| − | [[File:Sample-Report.PNG| | + | [[File:Sample-Report.PNG|550px|link=http://bit.ly/PS_XSLT_BOOK]] |
Revision as of 18:18, 28 December 2016
Using the Transformations tab within PeopleSoft Query, you can create files of the following types:
- Text format - e.g. CSV, fixed columns
- HTML
- XML - e.g. SpreadsheetML (to produce formatted Excel spreadsheets).
The Transformations tab uses the XSLT language (eXtensible Stylesheet Language - Transformations) - a specialised language for transforming XML documents into other formats (or further XML).
Additionally, pagelets can be built from PeopleSoft Query results. Annoyingly, the XML file 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
|
Other Links
Return to PeopleSoft Query
