Query Manager inserts Quotes around the Prompt Value in an expression When Used as a field
edited Jul 17, 2020 3:48PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered ✓
Hi,
We need to use a Prompt Value in an Expression and That expression as a Field.
Example :
Prompt (:1) = DATE
Expression = (TO_DATE(:1,'MM/DD/YYYY')) - 7
Query : select TO_DATE (':1', 'MM/DD/YYYY') - 7 from PS_INSTALLATION.
The query above has quotes around the Prompt Bind value :1. This is causing an issue while running the query.
Is there a solution for this in the query manager tool ?
-Shiva
4