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

Hi,

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

TO_CHAR(SAMPLE_TIME,'Mon dd, HH24:00') as SAMPLE_DTTM

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

2 answers

1 accepted

This widget could not be displayed.

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.

This widget could not be displayed.

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

select 
TO_CHAR(SAMPLE_TIME,'Mon dd HH24:mm') as SAMPLE_DTTM,
NVL((1-m.AVG_IDLE_TIME) , 0) as "Hourly Load Average" 
from JON_DASH.JON_HOST_METRICS M
where HOSTNAME=:hostname
and SAMPLE_TIME> SYSDATE-28
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 Aug 22, 2018 in Marketplace Apps

How a Marketplace app tech team is achieving gender diversity

Hello! My name is Genevieve Blanch, and I'm the Marketing Manager at RefinedWiki, creators of apps to give teams the tools to customize Atlassian platforms. Currently, 44% of the tech team at Re...

476 views 3 17
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