Difference between revisions of "PS Query Transformations"

From TekiWiki
Jump to: navigation, search
(Further Reading)
Line 10: Line 10:
 
|-
 
|-
  
|[[File:Transform-PeopleSoft-Query.JPG|90px|link=http://bit.ly/PS_XSLT_BOOK]]
+
|[[File:Transform-PeopleSoft-Query.JPG|100px|link=http://bit.ly/PS_XSLT_BOOK]]
  
 
|
 
|

Revision as of 20:33, 9 December 2016

Direct from your PeopleSoft Query, you can create files in precise formats such as CSV, fixed columns, HTML and even SpreadsheetML (to produce formatted Excel spreadsheets.

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

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