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

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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published Apr 10, 2018 in Marketplace Apps

Learn about how Stefan K. built one of the *first ever* Marketplace apps

In this post you will discover more about the evolution of K15t software, some big topics they're currently focusing on in the app space, and a rare (not not funny!) photo of founders Mike Cannon-Bro...

13,109 views 11 24
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