Filtering a Select MDO Query based on Datetime values
I am using SAP MII 14.0 version & working on MDO's
I am writing a select MDO query to fetch data from a Custom Persistant MDO
This MDO has five fields out of which 4 are string variables & one is a Date time variable
Now, when i filter the Query based on Date time, Its gives me issues
I am giving the condition as below in the filter Expression tab:
[INSERT_DATE] >='[Param.1]' AND [INSERT_DATE]<='[Param.2]' where INSERT_DATE is date time variable
In the Parameters of the Template i give the values for the two parameters say 03/01/2015 00:00:00 and 03/10/2015 00:00:00 as i used the same format to populate the MDO
When i execute the Query, it gives me the below error:
java.sql.SQLException: Error while processing the template TMP452bc540-e1ee-11e4-83f1-d0b90a3b5f3b - 1:69 - type check error: the left hand side >>INSERT_DATE.< (TIMESTAMP) and the right hand side >>'?'<< (CHAR) of a comparison operator are not comparable
- 1:86 - type check error: the left hand side >>INSERT_DATE.< (TIMESTAMP) and the right hand side >>'?'<< (CHAR) of a comparison operator are not comparable
Although the same process gives proper results for a MII SQL Query template
Also, i tried to remove the Quotes in the Filtering Condition, then it gives the below error
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
Could any one kindly help me understand this or give me a solution???
Please check if you've enabled the TYPE PARAMETERS- you can check that and set the parameter type as timestamp for both param1 and param2 and then you can test. You need to set the parameter type.
Hope this helps.