Difference between revisions of "Using Prompts in Case Expressions"

Latest revision as of 08:51, 25 March 2016

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:

case 
    when DEPTID like :1 then FTE
else
    0
end

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):

case 
    when DEPTID like rtrim(:1) then FTE
else
    0
end

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

More About Functions

For more information about functions in PeopleSoft Query and some other interesting stuff too, read our eBook: Using Functions in PeopleSoft Query