Using CASE or DECODE in PS Query Expressions
edited May 22, 2019 3:47PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 6 commentsAnswered ✓
Hi -
When I try to create an Expression in PS Query with a CASE or DECODE that handles more than two cases, I get an "FROM clauses are not allowed in expressions (50,536) " error. I've researched this and it looks like the functionality was disabled in PT 8.54 for security reasons (incidentally, there seems to be astonishingly little documentation on PS Query). I'd like my query to return values that are more meaningful than an integer.
For example to report on an Express Capitalization rule...
DECODE(A.PC_AM_CAP_RULE,
1, 'Manual Identification',
2, 'One Asset per Activity',
3, 'One Asset from Many Activities',
1