<p>I am not a SQL expert , and I am an absolute beginner with BIRT so please bear with me.</p>
<p> </p>
<p>I am trying to write a report where the user can input a given time range, and the result will show data from a postgres database within those times.</p>
<p> </p>
<p>I'm using parameters for the user input.</p>
<p> </p>
<p>So when the user runs the report he gives a start time and an end time.</p>
<p> </p>
<p>But the result includes times which are outside the range, usually before the start time rather than after the end time.</p>
<p> </p>
<p>When the same query is executed in the DB (with the '?' hardcoded) I get the correct times shown.</p>
<p> </p>
<p>When I repeat the query in BIRT with the times hardcoded I still get results outside the time range.</p>
<p> </p>
<p>I think this shows that the problem is with BIRT and not the query.</p>
<p> </p>
<p>Is there something that needs to be changed in the parameter settings of BIRT so that only results within the time range specified by the user are returned? </p>
<p> </p>
<p>thanks in advance</p>
<p> </p>
<p>summer </p>
<p> </p>
<p>PS I am using Eclipse version Neon.2 Release (4.6.2) with Postgres v9.5</p>
<p> </p>
<p> </p>
