I am still learning how to build and manipulate queries within PeopleSoft and I'm certainly no expert with SQL, but I am looking to find the correct statement to have the query look at a person's years of service with the company (which is calculated using an expression) and when the person's years of service are 5, 10, 15, 20 years, I need the query to return a character, such as *, in a separate field. I cannot build this into the criteria because I do not want to exclude those rows of data where the years of service are other than 5, 10, 15 and so on. I think I need an expression, but I'm not sure where to start. This is to help us tag who is reaching a milestone anniversary. Can anyone help?
| Title | Under | Posted on |
|---|---|---|
| How to run nvision report through portal | PeopleSoft Technical | 08/31/2010 - 4:45am |
| Any1 here who can help? | PeopleSoft Technical | 08/31/2010 - 2:12am |
| How to create matrix layout | PeopleSoft Technical | 08/27/2010 - 2:22am |
| UnCaught C++ Exception | PeopleSoft Technical | 08/10/2010 - 9:05am |
Could you use a case statement,eg
SELECT CASE YOUR_EXPRESSION WHEN = '5' THEN '5' CONCAT '* WHEN = '20' THEN '20*' ELSE YOUR_EXPRESSION END
FROM SOMETHING
??
Post new comment