ManjunathaM8669 Member since 2016 15 posts
Societe Generale
Posted: 3 years ago
Last activity: 3 years 6 months ago

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***

User Interface
Moderation Team has archived post
Share this page LinkedIn