Manjunatha MN (ManjunathaM8669)
Societe Generale

Societe Generale
ManjunathaM8669 Member since 2016 15 posts
Societe Generale
Posted: January 10, 2017
Last activity: March 28, 2017
Posted: 10 Jan 2017 6:26 EST
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***

User Experience
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.