Compatibility with Future macro?

I LOVE PocketQuery, but I have a couple reports that take a while and of course block the page from loading.  If you put it in a Future (part of the Bob Swift SQL package) it runs the query with the default parameters but the user cannot modify the parameters and rerun it.  Well, they can, but it just uses the defaults.  Here is a screenshot of the only visible wonkiness:

image2015-4-1 8:34:58.png

When it's outside of the Future, it looks like this:

image2015-4-1 8:35:31.png

1 answer

1 accepted

1 vote
Answer accepted

Hi Scott!

Thank you for using PocketQuery smile. The problem with a Future macro around the PocketQuery macro is that it will be a separate request. I.E. the PocketQuery macro will be rendered in another request environment (the Ajax request sent to the future servlet). While this is generally not a big deal for the default functionality of PQ, it breaks the "Dynamic Parameter" feature, since it reads the parameters from the request. Now in that case, PQ tries to read everything from the Future request that doesn't have the required information available.

We are currently working on PocketQuery 2.0 which will have its own "render macro dynamically" functionality. This will load the PocketQuery macro dynamically in the background and won't prevent the page from loading. No Future macro will be required anymore. Unfortunately, this release will still take some more time and I don't see any workaround for this issue at the moment. Maybe you can try to make your query faster somehow and go without the Future macro already?

Regards, Felix [Scandio]

Awesome news about 2.0, thanks!  Unfortunately this is a vendor DB and it is just very slow.

I might be able to provide you a beta version of 2.0. If you're interested, please send an email to atlassian[at]

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

1,271 views 2 13
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