Hi Artashes,
I checked this with my local MySQL JIRA database and this query works for me:
SELECT ID, FINISH_DATE FROM os_historystep WHERE FINISH_DATE > '2016-06-12'
This is the output:
image2016-6-16 15:21:56.png
If I changed the query to this:
SELECT ID, FINISH_DATE FROM os_historystep WHERE FINISH_DATE > :min AND FINISH_DATE < :max
I supply 2015-01-01 as min and 2016-12-31 as max. The output is the same, which means it works perfectly. Am I in a wrong direction here? Or does your DB not support the < > operators for date strings?
Regards, Felix (Scandio)
Felix, I'm using postgre and have nex error:
org.postgresql.util.PSQLException: ERROR: operator does not exist: timestamp with time zone > integer Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 191 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182) at
screen.PNG
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please simplify your query to troubleshoot and run it with your default Postgres tool:
SELECT ID, FINISH_DATE FROM os_historystep WHERE FINISH_DATE > '2010-01-01'
Only if this works without PQ, the firsts steps in PQ should be made. This is more a Postgres issue than a PQ issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In your case query is done.
But I need to set period on confluence page, because I write reports, business users using it
I'll try to resolve this problem on postgre side
Thx
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
So does this not work the same for your query?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.