WikiSysop: 1 revision imported

2016-03-25T08:51:07Z

1 revision imported

WikiSysop at 19:23, 24 November 2015

2015-11-24T19:23:44Z

New page

== [[PeopleSoft Query]] ==
===Issue using a Prompt in Case Expression at [[PeopleTools]] 8.49 ===

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

The following case statement in [[PeopleSoft 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, rtrim(:1,' ') would resolve the issue (provided there were no leading spaces).

==More About Functions==

{| 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]

|}

← Older revision	Revision as of 08:51, 25 March 2016
(No difference)

Using Prompts in Case Expressions - Revision history

WikiSysop: 1 revision imported

WikiSysop at 19:23, 24 November 2015