How do I code the "Timestamp Range" parameter class into the query?

0

What are the expressions I should use? How do I link the range to the respected variables? Example "Date created" and "Date Finished" need to be the To and From parameters?

 

Thank you for any help!

 

-Colt

coltae's picture
12
Joined: Sep 15 2015 - 9:53am
Last seen: 3 years 7 months ago

hi

can you explain the issue in detail so that i can help you

RamaKrishna.B - 3 years 10 months ago

1 Answer:

0

Jasper Query:                                                                            SQL Query:

where $X{BETWEEN,column_name,param1,param2} -----> where column_name>param1 and column_name<param2

where $X{[BETWEEN,column_name,param1,param2} -----> where column_name>=param1 and column_name<param2

where $X{BETWEEN],column_name,param1,param2} -----> where column_name>param1 and column_name<=param2

where $X{[BETWEEN],column_name,param1,param2} -----> where column_name>=param1 and column_name<=param2

zh3ntil's picture
531
Joined: Nov 19 2014 - 11:02pm
Last seen: 3 years 6 days ago
Feedback
randomness