UPDATE FROM ORACLE:
You have reached a known product defect Bug 34879280 - "EDITING COMPOSITE QUERY LONG EXPRESSION TEXT CAUSES AN ERROR HAS OCCURRED".
The fix will be mainly included in PeopleTools version 8.63 and a backport bug will be created to include the fix in the next PT 8.61.xx or PT 8.62 patches. No development will be done to the older code line.
There is no estimated time available when the fix will be released.
====
I have what might be a bug... but not sure... wondering if you all had experienced this...
When I have a case statement that I am creating within the composite query and then attempt to edit the name of the field - it seems to crash campus solutions and kicks me out.
If I don't rename it .. it runs just fine.
Here is the text of the expression... nothing too fancy
case when substr(#{Q1.A.STRM}, 4, 1) = '2' then 'FA'
when substr(#{Q1.A.STRM}, 4, 1) = '5' then 'SP'
else 'Summer'
end
------------------------------
Steph Zimmerman
IT Tech Associate
Illinois State University
------------------------------
Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------