View source for Using Prompts in Case Expressions

== [[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]

|}