PocketQuery and Oracle Date format - colon is misinterpreted as a parameter


Apparently PocketQuery interprets the colon in the date format descriptor as a parameter designator:


Is there a way how would I escape the colon to use it as a literal?

2 answers

1 accepted

2 votes
Accepted answer

Yea, now I see. This is actually kind of a problem. I'd say it'll be fixed in PocketQuery 1.13.1 which I plan to release sometime in September. Is this OK?

Thank you, that would be great!

Hi Evgeny, can you please check if this snapshot version of PocketQuery 1.13.1 solves this problem? Because in my tests it did ;). Let me know!

Yes it has solved the issue.

Should I just deploy it to PROD (how much has it changed from 1.13) or wait until the official release?

Nice! I'll prepare the official release and upload it to the marketplace later today! The new version contains your bugfix and another minor JavaScript issue that won't affect you ;). By the way: if you like PocketQuery, could you consider leaving a review at the Atlassian Marketplace?

Please find version 1.13.1 at the marketplace.

Hi Evgeny,

I tried to reproduce the problem with a sample MySQL database (this shouldn't be Oracle-specific) but I couldn't. I used this statement:

SELECT Name, DATE_FORMAT(NOW(),'%b %d %Y %h:%i %p') AS MyDate
FROM Country;

Can you provide your full statement?

Regards, Felix

Thank you for responding to this.

Here it is

NVL((1-m.AVG_IDLE_TIME) , 0) as "Hourly Load Average" 
where HOSTNAME=:hostname
order by SAMPLE_TIME asc

And that's how it is presented with the macro config (the 'mm' parameter, which it should not be):

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Feb 07, 2019 in Marketplace Apps

A Timeless Love Story

It started as any story starts, on a normal, rainy day.   Admin meets App, and her name was Klok2, and like any first relationship we were both trying to make it work but neither one knew what...

441 views 8 26
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you