Empty queryparameterstring when using custom template with dynamicload

TtheB
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 22, 2015

Hi,

I am using the following macro

<ac:structured-macro ac:name="pocketquery">
  <ac:parameter ac:name="dynamicload">true</ac:parameter>
  <ac:parameter ac:name="name">ListGroupPermissionsForContent</ac:parameter>
  <ac:parameter ac:name="parameters">groupname=*</ac:parameter>
  <ac:parameter ac:name="debug">true</ac:parameter>
  <ac:parameter ac:name="allowgetparams">true</ac:parameter>
</ac:structured-macro>

with this custom template

<form method="get" class="aui pq-dynamic-parameter-form" action="">
    #foreach($entry in $req.getParameterMap().entrySet())
        #if(!$entry.key.startsWith("pq_") && $PocketQuery.getValueFromMapEntry($entry))
            <input type="hidden" name="$entry.key" value="$PocketQuery.getValueFromMapEntry($entry)" />
        #end
    #end
    #foreach($key in $PocketQuery.sort($queryParameters.keySet()))
        #set($reqKey = "")
        #set($reqKey = "pq_$key")
        #set($s=$PocketQuery.getParameterFromRequestOrMacro($key, $req, $queryParameters))
        <div>
            <select id="$reqKey" name="$reqKey">
                #foreach( $group in $userAccessor.getGroupsAsList())
                    <option value="$group"#if("$group"=="$s") selected="selected"#end>$group</option>
                #end
            </select>
        </div>
    #end
    <button class="pq-change-button aui-button aui-style aui-button-primary" type="submit">submit</button>
</form>
$PocketQuery.template("default")

It does work fine, when setting dynamicload to false, but I really want the nice asynchronous loading and when I change dynamicload to true, I always end up with this error when I select a group and submit the form

org.springframework.dao.InvalidDataAccessApiUsageException: No value supplied for the SQL parameter 'groupname': No value registered for key 'groupname' at
org.springframework.jdbc.core.namedparam.NamedParameterUtils.buildValueArray(NamedParameterUtils.java:270) at 
org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.getPreparedStatementCreator(NamedParameterJdbcTemplate.java:256) at 
org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:133) at 
org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForList(NamedParameterJdbcTemplate.java:197) at 
org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForList(NamedParameterJdbcTemplate.java:201) at 
de.scandio.confluence.plugins.pocketquery.managers.SqlExternalDatabaseManager.executeQuery(SqlExternalDatabaseManager.java:83) at 
de.scandio.confluence.plugins.pocketquery.execution.PocketQueryDefaultExecution.executeQuery(PocketQueryDefaultExecution.java:192) at 
de.scandio.confluence.plugins.pocketquery.execution.PocketQueryDefaultExecution.run(PocketQueryDefaultExecution.java:109) at 
de.scandio.confluence.plugins.pocketquery.macros.PocketQueryMacro.execute(PocketQueryMacro.java:59)

since queryparameterstring and parameters are empty

{  
   "includechangetemplate":false,
   "dynamicloadinitially":false,
   "allowgetparams":true,
   "debug":true,
   "queryname":"ListGroupPermissionsForContent",
   "queryparameterstring":"",
   "includereloadbutton":false,
   "parameters":"",
   "query":"ListGroupPermissionsForContent",
   "pageid":123456789
}

What am I missing?

Thanks,

Tim

4 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

3 votes
Answer accepted
Felix Grund (Scandio)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 25, 2016

======

EDIT: this solution only works for PocketQuery >= 2.0.5. For PocketQuery <= 2.0.1, please chose the answer below!

======

Hi Tim!

Could you help us getting this work with PocketQuery 2.0.5 (not released yet)? Please install this SNAPSHOT version. In parallel to the code above: the queries stay the same. But the FormQuery template changes. From now on you won't have to embed the second PocketQuery macro ("ResultQuery") in your Confluence page. You'll only need one for the query "FormQuery" and this one will load the other one nested.

FormQuery Template:

&lt;form id="my-pocketquery-form" class="aui"&gt;
    &lt;div class="field-group"&gt;
        &lt;label for="select-country"&gt;Choose Country:&lt;/label&gt;
        &lt;select class="select" id="select-country" name="select-country"&gt;
            #foreach ($country in $result)
                &lt;option value="$country.Name" #if($country.Name == 'Sweden')selected="selected"#end&gt;$country.Name&lt;/option&gt;
            #end
        &lt;/select&gt;
    &lt;/div&gt;
&lt;/form&gt;
$PocketQuery.renderPocketQueryMacro("ResultQuery", {
	'page': $page,
	'parameters': {'CountryName':'Sweden'},
	'dynamicload': true
})
&lt;script&gt;
jQuery('#my-pocketquery-form select').change(function() {
    var container = jQuery('.pocketquery-dynamic-load[data-query="ResultQuery"]');
    var dataIndex = container.data('index');
	var data = PocketQuery.getDynamicLoadData(dataIndex);
    data.queryParameters = { CountryName: jQuery('#select-country').val() };
    PocketQuery.load({
        container: container,
        data: data
    });
});
&lt;/script&gt;

Does this work for you with the above snapshot version? Thank you in advance for your help - really appreciated!!

Regards, Felix

Pranjal Shukla February 25, 2016

Felix,

I tried this but did not work in my case. Maybe i am doing something wrong here. Tim would be the right person to answer here.

 

I am using the below code:

&lt;form id="my-pocketquery-form" class="aui"&gt;
  &lt;div class="field-group"&gt;
    &lt;label for="pq_Severity"&gt;Severity&lt;/label&gt;
    &lt;select class="select" id="pq_Severity" name="pq_Severity" selected="$!req.getParameter("pq_Severity")"&gt;
        &lt;option value="CRITICAL"&gt;CRITICAL&lt;/option&gt;
        &lt;option value="MAJOR"&gt;MAJOR&lt;/option&gt;
        &lt;option value="WARNING"&gt;WARNING&lt;/option&gt;
    &lt;/select&gt;
  &lt;/div&gt;
&lt;/form&gt;
&lt;table&gt;&lt;thead&gt;&lt;tr&gt;#foreach ($column in $columns)&lt;th&gt;$!column&lt;/th&gt;#end&lt;/tr&gt;&lt;/thead&gt;&lt;tbody&gt;#foreach ($row in $result)&lt;tr&gt;#foreach ($column in $row)&lt;td&gt;$!column&lt;/td&gt;#end&lt;/tr&gt;#end&lt;/tbody&gt;&lt;/table&gt;
&lt;script&gt;
jQuery('#my-pocketquery-form select').change(function() {
    var container = jQuery('.pocketquery-dynamic-load[data-query="OMI_TEST"]');
    var dataIndex = container.data('index');
    var data = PocketQuery.getDynamicLoadData(dataIndex);
    data.queryParameters = { CountryName: jQuery('#pq_Severity').val() };
    PocketQuery.load({
        container: container,
        data: data
    });
});
&lt;/script&gt;

 

I have a PQ Macro with name=OMI_TEST. I am using the above template in the same OMI_TEST macro. I am calling the same macro again as i want new table based on the new parameter. Not sure what wrong i am doing but it is not working.

TtheB
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 26, 2016

Felix, I can confirm, that it works exactly as you described it using the 2.0.5-snapshot version of PocketQuery.

Felix Grund (Scandio)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 26, 2016

Thanks for the feedback, Tim! I will release version 2.0.5 very soon! Really appreciate your participation in PocketQuery!! smile

TtheB
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 26, 2016

No problem, Felix. Once it's released, I would like to clean up this topic a bit, so others can get straight to the point. Maybe you could merge your second answer into the first one, with a hint, that this works for PocketQuery >= 2.0.5

Felix Grund (Scandio)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 26, 2016

Pranja, you misunderstood. You need two queries, one for the form and one for the subquery. In your case, the form query is most probably a dummy query with the template.

FormQuery query (dummy):

SELECT 1

FormQuery template:

&lt;form id="my-pocketquery-form" class="aui"&gt;
  &lt;div class="field-group"&gt;
    &lt;label for="pq_Severity"&gt;Severity&lt;/label&gt;
    &lt;select class="select" id="pq_Severity" name="pq_Severity" selected="$!req.getParameter("pq_Severity")"&gt;
        &lt;option value="CRITICAL"&gt;CRITICAL&lt;/option&gt;
        &lt;option value="MAJOR"&gt;MAJOR&lt;/option&gt;
        &lt;option value="WARNING"&gt;WARNING&lt;/option&gt;
    &lt;/select&gt;
  &lt;/div&gt;
&lt;/form&gt;
$PocketQuery.renderPocketQueryMacro("ResultQuery", {
    'page': $page,
    'parameters': {'Severity':'CRITICAL'}, ## only for initial rendering
    'dynamicload': true
})
&lt;script&gt;
jQuery('#my-pocketquery-form select').change(function() {
    var container = jQuery('.pocketquery-dynamic-load[data-query="OMI_TEST"]');
    var dataIndex = container.data('index');
    var data = PocketQuery.getDynamicLoadData(dataIndex);
    data.queryParameters = { CountryName: jQuery('#pq_Severity').val() };
    PocketQuery.load({
        container: container,
        data: data
    });
});
&lt;/script&gt;

OMI_TEST query:

This will be your query as before

OMI_TEST template:

Please try with the default template for now to keep things simple. Only if this works use your Chart macro.

Felix Grund (Scandio)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 26, 2016

TtheB and Pranjal, I just released PQ 2.0.5 smile

Pranjal Shukla February 28, 2016

Hi Felix,

I used a two query approach, and here is what i did:

  • Created two queries OMI_TEST and OMI_TEST_SEVERITY
  • OMI_TEST_SEVERITY is my first query with custom template as Dynamic_Load


OMI_TEST_SEVERITY

Select distinct severity from ALL_EVENTS;


Dynamic_Load

&lt;form id="my-pocketquery-form" class="aui"&gt;
    &lt;div class="field-group"&gt;
        &lt;label for="select-severity"&gt;Choose Severity:&lt;/label&gt;
        &lt;select class="select" id="select-severity" name="select-severity"&gt;
            #foreach ($severity in $result)
                &lt;option value="$severity.severity" #if($severity.severity == 'CRITICAL')selected="selected"#end&gt;$severity.severity&lt;/option&gt;
            #end
        &lt;/select&gt;
    &lt;/div&gt;
&lt;/form&gt;
$PocketQuery.renderPocketQueryMacro("OMI_TEST", {
    'page': $page,
    'parameters': {'Severity':'CRITICAL'},
    'dynamicload': true
})
&lt;script&gt;
jQuery('#my-pocketquery-form select').change(function() {
    var container = jQuery('.pocketquery-dynamic-load[data-query="OMI_TEST"]');
    var dataIndex = container.data('index');
    var data = PocketQuery.getDynamicLoadData(dataIndex);
    data.queryParameters = { Severity: jQuery('#select-severity').val() };
    PocketQuery.load({
        container: container,
        data: data
    });
});
&lt;/script&gt;

 

OMI_TEST

select TOP 5 RELATED_CI_HINT as 'Hostname', COUNT(RELATED_CI_HINT) as 'Breach Count' from ALL_EVENTS where CATEGORY like 'OEM' and TITLE like '%CPU%' and SEVERITY = :Severity and ALL_EVENTS.TIME_CREATED between GETDATE() -7 and GETDATE() GROUP BY RELATED_CI_HINT ORDER BY 'Breach Count' DESC;

 

The query loads well and my initial result gets loaded well (With Severity==CRITICAL). However, new results do not load when the Severity is changed i.e. OnChange event is not getting fired. I upgraded my Confluence to 5.9.5 this morning.

Felix Grund (Scandio)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 28, 2016

The outer query OMI_TEST_SEVERITY may not have dynamic load enabled wink

Pranjal Shukla February 28, 2016

Yep, i enabled Dynamic Load but now the initial load does not work i.e. result with Severity=CRITICAL does not come. I just see a select list on the page load. The other behavior is still the same i.e. OnChange () event does not work. I am using the SnapShot version of 2.0.5. Not able to download the released JAR due to changed IT policy.

Felix Grund (Scandio)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 28, 2016

Can you download 2.0.5 from here? It think your snapshot version doesn't contain a change I made in the after. But again: your query OMI_TEST_SEVERITY must be in the page with the PocketQuery macro without dynamic load. The nested query OMI_TEST will be run with dynamic load because you have set 'dynamicload': true - which is correct.

Pranjal Shukla February 28, 2016

Now it works like a charm....smile...However, i have some more questions...i'll ask on the original thread where you answered my P5 and P6.

Felix Grund (Scandio)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 28, 2016

Could you please send an email to atlassian[at]scandio[dot]de? I'd like to ask you something wink

Pawel Rozek March 24, 2016

I have a similar setup as above, but I would like the drop down menu control 2 separate tables on select of my region.

Is it possible to have the drop down menu control 2 table updates on change of the menu? I managed to have 2 tables display by duplicating the:

 

$PocketQuery.renderPocketQueryMacro("STATUS", {
    'page': $page,
    'parameters': {'SelectedStatus':'%'},
    'dynamicload'true
But I'm not certain what needs to be updated in the script to allow for additional table to update. Only the first table gets updates. Any help would be appreciated.
Felix Grund (Scandio)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 28, 2016

Hi Pawel! Should be quite easy. Your setup is almost correct: you need two PQ macros, both with dynamicload set. Only one macro should have the "change params template" set. In the template of the query with the form, you attach to the JS event and trigger a load on both macros like so:

jQuery('#my-pocketquery-form select').change(function() {
	var selectedValue = jQuery(this).val();
	jQuery('.pocketquery-dynamic-load[data-query="YourQueryName"]').each(function() {
		var container = jQuery(this);
	    var dataIndex = container.data('index');
	    var data = PocketQuery.getDynamicLoadData(dataIndex);
	    data.queryParameters = { YourParameterName: selectedValue };
	    PocketQuery.load({
	    	container: container,
	    	data: data
	    });
	});
});

Replace "YourQueryName" and "YourParameterName" in the code and it should work...

Regards, Felix

Pawel Rozek April 4, 2016

That worked perfectly. Thank you Felix smile

Brian_Bump December 8, 2016

I too have been able to get this to work! Much appreciated for the examples. I do have one odd error... If I try to have both macros in the same section within the page layout, I get an error stating:

Dynamic load validation failed.No valid page ID given in the dynamic load request.

However, it works if I change the page layout to 2 column, with result macro and control macro in different columns. any ideas? 

Felix Grund (Scandio)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 9, 2016

Hi Brian! Can you use your browser dev tools and check if the Ajax request to PocketQuery contains a parameter "pageid" in the case the where error occurs?

Brian_Bump January 12, 2017

Sorry for the late response...

The page loads initially, it only fails when I change the drop down to something other than the default selection. There is a parameter for page id in the initial load-dynamically request along with the default selection parameter. There is no parameter 'pageid' in the ajax request to load dynamically when i change the selection.

1 vote
Felix Grund (Scandio)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 6, 2016

======

EDIT: this solution only works for PocketQuery <= 2.0.1. For PocketQuery >= 2.0.5, please chose the accepted answer below!

======

Hi Tim,

This is a little more advanced and uses a JS method "load" on the PocketQuery object that we have only used internally so far. So there is no proper documentation for it. I created an example for you that should demonstrate how it works.

I have two queries.

"FormQuery":

SELECT Name
FROM Country
WHERE Continent = :Continent

"ResultQuery":

SELECT LifeExpectancy
FROM Country
WHERE Name = :CountryName

This query "FormQuery" gives me all country names in a given continent. I set "Sweden" as the default country in the macro. From the result, I create a form with a select box containing all the countries in the result. Now if a user selects another country in the select box, I want to render the PocketQuery macro for "ResultQuery" with the selection of the select box.

I have this template for "FormQuery":

&lt;form id="my-pocketquery-form" class="aui"&gt;
	&lt;div class="field-group"&gt;
		&lt;label for="select-country"&gt;Choose Country:&lt;/label&gt;
		&lt;select class="select" id="select-country" name="select-country"&gt;
			#foreach ($country in $result)
				&lt;option value="$country.Name" #if($country.Name == 'Sweden')selected="selected"#end&gt;$country.Name&lt;/option&gt;
			#end	
		&lt;/select&gt;
	&lt;/div&gt;
&lt;/form&gt;
&lt;script&gt;
jQuery('#my-pocketquery-form select').change(function() {
	var container = jQuery('.pocketquery-dynamic-load[data-query="ResultQuery"]');
	var data = container.clone().data();
	data.queryParameters = { CountryName: jQuery('#select-country').val() };
	PocketQuery.load({
		'$container': container,
		data: data
	});
});
&lt;/script&gt;

The PocketQuery.load method takes an object "data" and an object "$container" (note that this must be in quotes since Velocity won't accept the $ sign in variables) which is the jQuery wrapped div with the class ".pocketquery-dynamic-load" (there are some more options to that function that are probably not needed here). "data" will contain everything required. It is first created from the data-* attributes of the container. I set a new object "queryParameters" on the object that contains the parameter for ResultQuery, which I retrieve from the selected option in the form.

In your page, you have two PocketQuery macros:

  • FormQuery
  • ResultQuery (for this you must check the "dynamicload" option!)

Looks like this for me:

image2016-1-7 11:37:47.png

image2016-1-7 11:37:21.png

Can you make something out of this?

Regards, Felix (Scandio)

TtheB
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 7, 2016

Thank you Felix, it works perfectly.

Felix Grund (Scandio)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 25, 2016

Hi Tim! I have a suspicion that this might not work with PocketQuery >= 2.0.2 anymore. Could you verify? If it doesn't I'll provide you a new way to get it work (no big change).

TtheB
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 25, 2016

Hi Felix, you are correct, I just updated PocketQuery on our TestServer from 2.0.1 to 2.0.4 and I now get

Dynamic load validation failed.No valid page ID given in the dynamic load request.

Thanks for the warning in advance, what needs to be changed?

Pawel Rozek March 22, 2016

Hi Felix, it seems that the error TtheB mentioned is still in version 2.0.7. Additionally on the initial load, I'm getting an error on the "ResultQuery" macro:

PocketQuery experienced an error!
There were errors executing this statement. Please check whether the following parameters are given: [CountryName]. If the parameters are correct, something must be wrong with the query or the database connection. For inspection, please use the debug mode in the macro or contact your administrator.

It seems that the parameter is not loading, even though I have "Load macro dynamically" set and "Enable dynamic parameters" set as well. This is the stack trace:

Stack Trace
org.springframework.dao.InvalidDataAccessApiUsageException: No value supplied for the SQL parameter 'CountryName': No value registered for key 'CountryName' at org.springframework.jdbc.core.namedparam.NamedParameterUtils.buildValueArray(NamedParameterUtils.java:336) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.getPreparedStatementCreator(NamedParameterJdbcTemplate.java:348) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:192) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForList(NamedParameterJdbcTemplate.java:264) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForList(NamedParameterJdbcTemplate.java:271) at de.scandio.confluence.plugins.pocketquery.managers.SqlExternalDatabaseManager.executeQuery(SqlExternalDatabaseManager.java:83) at de.scandio.confluence.plugins.pocketquery.execution.PocketQueryDefaultExecution.executeQuery(PocketQueryDefaultExecution.java:193) at de.scandio.confluence.plugins.pocketquery.execution.PocketQueryDefaultExecution.run(PocketQueryDefaultExecution.java:110) at de.scandio.confluence.plugins.pocketquery.macros.PocketQueryMacro.execute(PocketQueryMacro.java:59) at sun.reflect.GeneratedMethodAccessor1564.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.atlassian.confluence.macro.xhtml.XhtmlMacroManager$ResourceAwareMacroInvocationHandler.invoke(XhtmlMacroManager.java:203) at com.sun.proxy.$Proxy2032.execute(Unknown Source) at com.atlassian.confluence.content.render.xhtml.view.macro.ViewMacroMarshaller.executeMacro(ViewMacroMarshaller.java:229) at com.atlassian.confluence.content.render.xhtml.view.macro.ViewMacroMarshaller.marshalInternal(ViewMacroMarshaller.java:156) at com.atlassian.confluence.content.render.xhtml.view.macro.ViewMacroMarshaller.lambda$marshal$0(ViewMacroMarshaller.java:113) at com.atlassian.confluence.impl.content.render.xhtml.analytics.MetricsCollectingMarshaller.marshal(MetricsCollectingMarshaller.java:49) at com.atlassian.confluence.content.render.xhtml.view.macro.ViewMacroMarshaller.marshal(ViewMacroMarshaller.java:118) at com.atlassian.confluence.content.render.xhtml.view.macro.ViewMacroMarshaller.marshal(ViewMacroMarshaller.java:54) at com.atlassian.confluence.content.render.xhtml.UnmarshalMarshalFragmentTransformer.transform(UnmarshalMarshalFragmentTransformer.java:29) at com.atlassian.confluence.content.render.xhtml.transformers.DefaultFragmentTransformer.transformFragment(DefaultFragmentTransformer.java:141) at com.atlassian.confluence.content.render.xhtml.transformers.DefaultFragmentTransformer.transform(DefaultFragmentTransformer.java:123) at com.atlassian.confluence.content.render.xhtml.storage.StorageXhtmlTransformer.transform(StorageXhtmlTransformer.java:41) at com.atlassian.confluence.content.render.xhtml.TransformerChain.transform(TransformerChain.java:33) at com.atlassian.confluence.content.render.xhtml.TransformerChain.transform(TransformerChain.java:33) at com.atlassian.confluence.content.render.xhtml.PluggableTransformerChain.transform(PluggableTransformerChain.java:39) at com.atlassian.confluence.content.render.xhtml.DefaultRenderer.render(DefaultRenderer.java:111) at com.atlassian.confluence.content.render.xhtml.DeviceTypeAwareRenderer.render(DeviceTypeAwareRenderer.java:54) at com.atlassian.confluence.content.render.xhtml.DefaultXhtmlContent.convertStorageToView(DefaultXhtmlContent.java:140) at sun.reflect.GeneratedMethodAccessor985.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26) at com.sun.proxy.$Proxy345.convertStorageToView(Unknown Source) at sun.reflect.GeneratedMethodAccessor985.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:136) at com.sun.proxy.$Proxy345.convertStorageToView(Unknown Source) at de.scandio.confluence.plugins.pocketquery.util.PocketQueryUtil.renderConfluenceXhtmlMacro(PocketQueryUtil.java:186) at de.scandio.confluence.plugins.pocketquery.rest.PocketQueryViewRestService.loadPocketQueryDynamically(PocketQueryViewRestService.java:80) at sun.reflect.GeneratedMethodAccessor1574.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$ResponseOutInvoker$1.invoke(DispatchProviderHelper.java:192) at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$1.intercept(DispatchProviderHelper.java:83) at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke(DefaultMethodInvocation.java:53) at com.atlassian.plugins.rest.common.expand.interceptor.ExpandInterceptor.intercept(ExpandInterceptor.java:34) at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke(DefaultMethodInvocation.java:53) at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper.invokeMethodWithInterceptors(DispatchProviderHelper.java:110) at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$ResponseOutInvoker._dispatch(DispatchProviderHelper.java:190) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:288) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1469) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1400) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1349) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1339) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537) at com.atlassian.plugins.rest.module.RestDelegatingServletFilter$JerseyOsgiServletContainer.doFilter(RestDelegatingServletFilter.java:154) at com.sun.jersey.spi.container.servlet.ServletContainer.doFilter(ServletContainer.java:795) at com.atlassian.plugins.rest.module.RestDelegatingServletFilter.doFilter(RestDelegatingServletFilter.java:68) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:70) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:58) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.plugins.rest.module.servlet.RestServletUtilsUpdaterFilter.doFilterInternal(RestServletUtilsUpdaterFilter.java:22) at com.atlassian.plugins.rest.module.servlet.RestServletUtilsUpdaterFilter.doFilter(RestServletUtilsUpdaterFilter.java:34) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:26) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:26) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:26) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:26) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:26) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.confluence.efi.OnboardingFilter.doFilter(OnboardingFilter.java:61) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.mywork.client.filter.ServingRequestsFilter.doFilter(ServingRequestsFilter.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.prettyurls.filter.PrettyUrlsSiteMeshFixupFilter.doFilter(PrettyUrlsSiteMeshFixupFilter.java:36) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.prettyurls.filter.PrettyUrlsDispatcherFilter.doFilter(PrettyUrlsDispatcherFilter.java:60) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.prettyurls.filter.PrettyUrlsSiteMeshFilter.doFilter(PrettyUrlsSiteMeshFilter.java:92) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.prettyurls.filter.PrettyUrlsMatcherFilter.doFilter(PrettyUrlsMatcherFilter.java:56) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:70) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129) at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77) at com.atlassian.confluence.util.profiling.ProfilingSiteMeshFilter.doFilter(ProfilingSiteMeshFilter.java:45) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:39) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.confluence.util.profiling.ConfluenceActivityFilter.doFilter(ConfluenceActivityFilter.java:39) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.prettyurls.filter.PrettyUrlsCombinedMatchDispatcherFilter.doFilter(PrettyUrlsCombinedMatchDispatcherFilter.java:61) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:70) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.cache.TransactionalCacheFactoryCleanupFilter.doFilter(TransactionalCacheFactoryCleanupFilter.java:41) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.ServletContextThreadLocalFilter.doFilter(ServletContextThreadLocalFilter.java:21) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.LoggingContextFilter.doFilter(LoggingContextFilter.java:34) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.UserNameHeaderFilter.doFilter(UserNameHeaderFilter.java:25) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.web.filter.MauEventFilter.doFilter(MauEventFilter.java:31) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.web.filter.ConfluenceTimeoutFilter.doFilter(ConfluenceTimeoutFilter.java:57) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:240) at com.atlassian.confluence.web.filter.ConfluenceSecurityFilter.doFilter(ConfluenceSecurityFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.web.filter.ThreadLocalCacheFilter.doFilter(ThreadLocalCacheFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:103) at com.atlassian.confluence.util.AbstractBootstrapHotSwappingFilter.doFilter(AbstractBootstrapHotSwappingFilter.java:32) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:148) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:39) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:79) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter(RestSeraphFilter.java:39) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.prettyurls.filter.PrettyUrlsCombinedMatchDispatcherFilter.doFilter(PrettyUrlsCombinedMatchDispatcherFilter.java:61) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:70) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.ClusterHeaderFilter.doFilter(ClusterHeaderFilter.java:56) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170) at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:29) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:39) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.jwt.internal.servlet.JwtAuthFilter.doFilter(JwtAuthFilter.java:31) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.analytics.client.filter.DefaultAnalyticsFilter.doFilter(DefaultAnalyticsFilter.java:38) at com.atlassian.analytics.client.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:39) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.confluence.web.filter.HttpRequestStatsFilter.doFilter(HttpRequestStatsFilter.java:60) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:115) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:92) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.confluence.web.filter.ConfluenceTimingFilter.doFilter(ConfluenceTimingFilter.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.prettyurls.filter.PrettyUrlsCombinedMatchDispatcherFilter.doFilter(PrettyUrlsCombinedMatchDispatcherFilter.java:61) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:58) at com.atlassian.confluence.extra.webdav.servlet.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:43) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:64) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:37) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:70) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.web.filter.validateparam.RequestParamValidationFilter.doFilter(RequestParamValidationFilter.java:51) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.web.filter.TranslationModeFilter.doFilter(TranslationModeFilter.java:39) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.plugin.servlet.filter.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.web.filter.LanguageExtractionFilter.doFilter(LanguageExtractionFilter.java:45) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:45) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.web.filter.ResponseOutputStreamFilter.doFilter(ResponseOutputStreamFilter.java:23) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.impl.servlet.HoldingUntilStartedFilter.doFilter(HoldingUntilStartedFilter.java:88) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.servlet.FourOhFourErrorLoggingFilter.doFilter(FourOhFourErrorLoggingFilter.java:64) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.web.filter.DebugFilter.doFilter(DebugFilter.java:46) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)

Let me know if I can further assist you with further testing. Thank you.

TtheB
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 22, 2016

Did you try the correct answer for version >= 2.0.5? It seems to me, that you used the old solution which will only work for version <= 2.0.1 - this topic is kind of a mess, I guess I will clean it up soon.

Felix Grund (Scandio)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 23, 2016

TtheB is right. It seems you're using the old solution. Please try as written in the accepted answer:

======

EDIT: this solution only works for PocketQuery >= 2.0.5. For PocketQuery <= 2.0.1, please chose the answer below!

======

Pawel Rozek March 23, 2016

You are correct, thanks for a quick response.

0 votes
TtheB
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 6, 2016

Hi Felix, your assumption is correct. I'd appreciate it a lot, if you could share this cleaner approach. Thanks

0 votes
Felix Grund (Scandio)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 4, 2016

Hi Tim! I would like to understand your use case better. Is this assumption correct: you have a form and based on the input in that form you render PocketQuery results for a specific query? In that case I can suggest you a cleaner approach that we have used for a bigger project with PocketQuery recently ;)

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

TAGS
AUG Leaders

Atlassian Community Events