Question
Societe Generale
IN
Last activity: 28 Mar 2017 9:47 EDT
SQL Function Alias - Not working
Hi Team,
I have a requirement of subtracting X minutes from the current datetime and use it as a criteria in RD. I have created a function alias for this like below.
sysdate + interval '{1}' minute
RD works correctly if i hardcode like sysdate + interval '-60' minute. If i replace the -60 with a parameter value i get below error while runing report definition.
** An error occured on executing the query for the report definition - There was a problem getting a list: code: 17003 SQLState: 99999 Message: Invalid column index
DatabaseException caused by prior exception: java.sql.SQLException: Invalid column index
| SQL Code: 17003 | SQL State: 99999
Please find the attached screen shot of the function alias rule.
***Moderator Edit: Vidyaranjan| Updated Categories***
Accepted Solution
Societe Generale
IN
Used like below and its working. Thanks
sysdate + interval '-<%=pega.findDataPage("DataPageName", false, "paramname", "para value").getInteger(".propertyName")%>' minute
Pegasystems Inc.
US
Hi Manjunatha,
Could you remove the single quotes in the source code like sysdate + interval {1} minute and let us know the end result.
Regards,
Mahesh
Accepted Solution
Societe Generale
IN
Used like below and its working. Thanks
sysdate + interval '-<%=pega.findDataPage("DataPageName", false, "paramname", "para value").getInteger(".propertyName")%>' minute
Virtusa
IN
Hi Manjunath,
We also have a similar requirement. We want to pass the parameter to the function alias as paramvalue to the datapage. How to achieve it.
Thanks.