Using Prompts in Case Expressions - Revision history

WikiSysop at 19:23, 24 November 2015

2015-11-24T19:23:44Z

← Older revision		Revision as of 19:23, 24 November 2015
Line 1:		Line 1:
-	=== [[PeopleSoft Query]] Issue using a Prompt in Case Expression at [[PeopleTools]] 8.49 ===	+	== [[PeopleSoft Query]] ==
		+	===Issue using a Prompt in Case Expression at [[PeopleTools]] 8.49 ===

	(ED: Does this happen on other PeopleTools versions?)		(ED: Does this happen on other PeopleTools versions?)

WikiSysop at 22:11, 28 August 2015

2015-08-28T22:11:17Z

← Older revision		Revision as of 22:11, 28 August 2015
Line 27:		Line 27:
	==More About Functions==		==More About Functions==

-	For more information about functions in [[PeopleSoft Query]], ~~get a copy of~~ our eBook:	+	{\| class="wikitable"
		+	\|-
		+	\|[[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]]
		+
		+	\|For more information about functions in [[PeopleSoft Query]] and some other interesting stuff too, read our eBook:

	[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]
		+
		+	\|}

WikiSysop at 23:07, 27 August 2015

2015-08-27T23:07:23Z

← Older revision		Revision as of 23:07, 27 August 2015
Line 1:		Line 1:
-	=== [[PeopleSoft Query]] Issue using a Prompt in Case Expression at PeopleTools 8.49 ===	+	=== [[PeopleSoft Query]] Issue using a Prompt in Case Expression at [[PeopleTools]] 8.49 ===

	(ED: Does this happen on other PeopleTools versions?)		(ED: Does this happen on other PeopleTools versions?)

-	The following case statement in PS Query would not give a correct value:	+	The following case statement in [[PeopleSoft Query]] would not give a correct value:

	<pre>		<pre>

WikiSysop at 23:04, 27 August 2015

2015-08-27T23:04:26Z

← Older revision		Revision as of 23:04, 27 August 2015
Line 1:		Line 1:
-	=== PS Query Issue using a Prompt in Case Expression at PeopleTools 8.49 ===	+	=== [[PeopleSoft Query]] Issue using a Prompt in Case Expression at PeopleTools 8.49 ===

	(ED: Does this happen on other PeopleTools versions?)		(ED: Does this happen on other PeopleTools versions?)

WikiSysop at 21:33, 25 August 2015

2015-08-25T21:33:25Z

← Older revision		Revision as of 21:33, 25 August 2015
Line 7:		Line 7:
	<pre>		<pre>
	case		case
-	when ~~deptid~~ like :1 then ~~fte~~	+	when DEPTID like :1 then FTE
	else		else
	0		0
Line 17:		Line 17:
	<pre>		<pre>
	case		case
-	when ~~deptid~~ like rtrim(:1) then ~~fte~~	+	when DEPTID like rtrim(:1) then FTE
	else		else
	0		0
Line 24:		Line 24:

	In SQL Server, rtrim(:1,' ') would resolve the issue (provided there were no leading spaces).		In SQL Server, rtrim(:1,' ') would resolve the issue (provided there were no leading spaces).
-
-	~~Incidentally, the SQL View would show the following:~~
-
-	~~<pre>~~
-	~~case~~
-	~~when deptid like ':1' then fte~~
-	~~else~~
-	0
-	~~end~~
-	~~</pre>~~

	==More About Functions==		==More About Functions==

WikiSysop at 21:30, 25 August 2015

2015-08-25T21:30:03Z

← Older revision		Revision as of 21:30, 25 August 2015
Line 34:		Line 34:
	end		end
	</pre>		</pre>
		+
		+	==More About Functions==
		+
		+	For more information about functions in [[PeopleSoft Query]], get a copy of our eBook:
		+
		+	[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]

WikiSysop at 15:22, 11 August 2013

2013-08-11T15:22:59Z

← Older revision		Revision as of 15:22, 11 August 2013
Line 17:		Line 17:
	<pre>		<pre>
	case		case
-	when deptid like rtrim(:1~~,' '~~) then fte	+	when deptid like rtrim(:1) then fte
	else		else
	0		0
Line 23:		Line 23:
	</pre>		</pre>

-	In SQL Server, ~~trim~~(:1) would resolve the issue (provided there were no leading spaces).	+	In SQL Server, rtrim(:1,' ') would resolve the issue (provided there were no leading spaces).

	Incidentally, the SQL View would show the following:		Incidentally, the SQL View would show the following:

WikiSysop at 11:30, 26 February 2011

2011-02-26T11:30:43Z

← Older revision		Revision as of 11:30, 26 February 2011
Line 1:		Line 1:
-	PS Query Issue using a Prompt in Case Expression at PeopleTools 8.49	+	=== PS Query Issue using a Prompt in Case Expression at PeopleTools 8.49 ===

-	(Does this happen on other PeopleTools versions?)	+	(ED: Does this happen on other PeopleTools versions?)

	The following case statement in PS Query would not give a correct value:		The following case statement in PS Query would not give a correct value:

WikiSysop: Created page with "PS Query Issue using a Prompt in Case Expression at PeopleTools 8.49 (Does this happen on other PeopleTools versions?) The following case statement in PS Query would not give a..."

2011-02-26T11:28:55Z

Created page with "PS Query Issue using a Prompt in Case Expression at PeopleTools 8.49 (Does this happen on other PeopleTools versions?) The following case statement in PS Query would not give a..."

New page

PS Query Issue using a Prompt in Case Expression at PeopleTools 8.49

(Does this happen on other PeopleTools versions?)

The following case statement in PS Query would not give a correct value:

<pre>
case
when deptid like :1 then fte
else
0
end
</pre>

The problem was that the entered prompt value was padded with spaces to the length of the prompt. So the solution was using rtrim (Oracle):

<pre>
case
when deptid like rtrim(:1,' ') then fte
else
0
end
</pre>

In SQL Server, trim(:1) would resolve the issue (provided there were no leading spaces).

Incidentally, the SQL View would show the following:

<pre>
case
when deptid like ':1' then fte
else
0
end
</pre>