Using Prompts in Case Expressions
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Using Prompts in Case Expressions
| Line 1: | Line 1: | ||
| - | == | + | == [[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 | + | The following case statement in [[PeopleSoft Query]] would not give a correct value: |
<pre> | <pre> | ||
case | case | ||
| - | when | + | when DEPTID like :1 then FTE |
else | else | ||
0 | 0 | ||
| Line 17: | Line 18: | ||
<pre> | <pre> | ||
case | case | ||
| - | when | + | when DEPTID like rtrim(:1) then FTE |
else | else | ||
0 | 0 | ||
| Line 23: | Line 24: | ||
</pre> | </pre> | ||
| - | In SQL Server, | + | 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] | |
| + | |||
| + | |} | ||
