PeopleSoft Query - Revision history

WikiSysop at 18:27, 26 January 2017

2017-01-26T18:27:27Z

2016-12-15T23:04:07Z

‎Further Reading

2016-12-15T23:03:38Z

‎Further Reading

2016-12-15T23:02:22Z

‎Further Reading

2016-12-15T23:01:02Z

‎Further Reading

2016-12-15T22:59:55Z

‎Further Reading

2016-12-15T22:58:07Z

‎Further Reading

2016-12-15T22:56:49Z

‎Further Reading

2016-11-23T13:15:00Z

2016-07-21T22:05:36Z

← Older revision		Revision as of 18:27, 26 January 2017
Line 12:		Line 12:

	[[Making Use of Translate]]		[[Making Use of Translate]]
		+
		+	[[PS Query Lists]] - Creating long lists of values quickly and easily in PS Query

	[[PS Query Transformations]]		[[PS Query Transformations]]

@@ Line 27: / Line 27: @@
 |-
-|[[File:Transform-PeopleSoft-Query.JPG|100px|link=http://bit.ly/PS_XSLT_BOOK]]
+|[[File:Transform-PeopleSoft-Query.JPG|105px|link=http://bit.ly/PS_XSLT_BOOK]]
 |Plus find out how to transform your PeopleSoft Query results into something spectacular:

@@ Line 27: / Line 27: @@
 |-
-|[[File:Transform-PeopleSoft-Query.JPG|95px|link=http://bit.ly/PS_XSLT_BOOK]]
+|[[File:Transform-PeopleSoft-Query.JPG|100px|link=http://bit.ly/PS_XSLT_BOOK]]
 |Plus find out how to transform your PeopleSoft Query results into something spectacular:

@@ Line 27: / Line 27: @@
 |-
-|[[File:Transform-PeopleSoft-Query.JPG|100px|link=http://bit.ly/PS_XSLT_BOOK]]
+|[[File:Transform-PeopleSoft-Query.JPG|95px|link=http://bit.ly/PS_XSLT_BOOK]]
 |Plus find out how to transform your PeopleSoft Query results into something spectacular:

@@ Line 27: / Line 27: @@
 |-
-|[[File:Transform-PeopleSoft-Query.JPG|120px|link=http://bit.ly/PS_XSLT_BOOK]]
+|[[File:Transform-PeopleSoft-Query.JPG|100px|link=http://bit.ly/PS_XSLT_BOOK]]
 |Plus find out how to transform your PeopleSoft Query results into something spectacular:

@@ Line 31: / Line 31: @@
+|
 [http://bit.ly/PS_XSLT_BOOK Transforming PeopleSoft Query]
 |}

← Older revision		Revision as of 22:56, 15 December 2016
Line 24:		Line 24:

	[http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21 Using Functions in PeopleSoft Query]		[http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21 Using Functions in PeopleSoft Query]
		+
		+	\|-
		+
		+	\|[[File:Transform-PeopleSoft-Query.JPG\|90px\|link=http://bit.ly/PS_XSLT_BOOK]]
		+
		+	\|
		+	[http://bit.ly/PS_XSLT_BOOK Transforming PeopleSoft Query]
		+
		+	[[PeopleSoft Query]]
		+
		+	\|[[File:UsingFunctionsInPeopleSoftQuerySmall.jpg\|90px\|link=http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21]]
		+
		+

	\|}		\|}

← Older revision		Revision as of 22:05, 21 July 2016
Line 1:		Line 1:
−	PeopleSoft Query ~~(PS Query or just Query)~~ is a [[PeopleTools\|PeopleTool]] that creates a report based on a user defined SQL statement. The output can be shown in a web page or downloaded to Microsoft Excel, Crystal Reports or BI Publisher (used to be XML Publisher).	+	PeopleSoft Query is a [[PeopleTools\|PeopleTool]] that creates a report based on a user defined SQL statement. The output can be shown in a web page or downloaded to Microsoft Excel, Crystal Reports or BI Publisher (used to be XML Publisher). PeopleSoft Query is sometimes also called PS Query or just Query.

	Queries can be created via a two tier client or via the web client.		Queries can be created via a two tier client or via the web client.