PS Query Transformations

From TekiWiki
Revision as of 23:27, 24 December 2016 by WikiSysop (Talk | contribs)

Jump to: navigation, search

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).

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

Transform-PeopleSoft-Query.JPG

Transforming PeopleSoft Query

PeopleSoft Query

UsingFunctionsInPeopleSoftQuerySmall.jpg

Using Functions in PeopleSoft Query

PeopleSoft Query

PeopleSoftUserCompanion.jpg

PeopleSoft Users Companion

PeopleSoft Users Companion Extras


Other Links

Return to PeopleSoft Query