Difference between revisions of "PS Query Transformations"
From TekiWiki
| Line 1: | Line 1: | ||
Direct from your [[PeopleSoft]] [[PeopleSoft Query|Query]], you can create files in precise formats such as CSV, fixed columns and even SpreadsheetML. The query results can be output in HTML format in all the richness. | Direct from your [[PeopleSoft]] [[PeopleSoft Query|Query]], you can create files in precise formats such as CSV, fixed columns and even SpreadsheetML. The query results can be output in HTML format in all the richness. | ||
| − | Additionally, pagelets can be built from PeopleSoft Query results. Annoyingly, the format for pagelets is different from Query. | + | Additionally, pagelets can be built from PeopleSoft Query results. Annoyingly, the format for pagelets is different from Query. However, both can be processed using XSLT (eXtensible Stylesheet Language - Transformations). Add the power if this language to SQL and you have a winning formula. |
| + | |||
| + | |||
==Further Reading== | ==Further Reading== | ||
Revision as of 22:51, 24 November 2016
Direct from your PeopleSoft Query, you can create files in precise formats such as CSV, fixed columns and even SpreadsheetML. The query results can be output in HTML format in all the richness.
Additionally, pagelets can be built from PeopleSoft Query results. Annoyingly, the format for pagelets is different from Query. However, both can be processed using XSLT (eXtensible Stylesheet Language - Transformations). Add the power if this language to SQL and you have a winning formula.
Further Reading
|
|
PeopleSoft Users Companion Extras
|
