Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How do I search within the SQL of all PocketQuery queries?

Jacob Boyko
Contributor
August 1, 2014

I have a fairly large number of queries and I would like to be able to search for keywords in the SQL statements.

For example, I'm editing a stored procedure in my database that I know is used in some queries, and I'd like to search for the procedure name so I can check dependencies.

Is there a way to do this? I looked in the database but this query wasn't useful:

SELECT * FROM plugindata where PLUGINKEY = 'de.scandio.confluence.plugins.pocketquery'

2 answers

1 accepted

1 vote
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.
August 5, 2014

Hi Jacob,

I prepared a little piece of JavaScript code that retrieves the query objects and their statements in Confluence Admin. When you are on that screen, you can open a browser console (e.g. DevTools in Chrome) and execute the script. It should then print all query objects (which you can expand and see all data) and a string that contains all statements separated.

(function($) {

	var allQueryObjects = [];
	var statementsString = '';

	$('#queries-list li').each(function() {
		var $this = $(this);
		var queryName = $this.data('entityname');
		var queryObj = PocketQuery.getEntity('query', queryName);
		allQueryObjects.push(queryObj);
		statementsString += '\n===\n' + queryObj.statement;
	});

	console.log('All query objects:');
	console.log(allQueryObjects);

	console.log('All query statements');
	console.log(statementsString);

}(jQuery))

Let me know if you need further help!

Regards, Felix

Jacob Boyko
Contributor
August 5, 2014

Hi Felix,

Wow, that will work nicely, thanks for such a quick response!

Cheers, Jacob

0 votes
Jacob Boyko
Contributor
May 20, 2015

This is just related info - it does the same thing for the templates as the above does for the queries:

(function($) {
    var PQEntityObjects = [];
    var outputString = '';
 
    $('#templates-list li').each(function() {
        var $this = $(this);
        var entityname= $this.data('entityname');
        var entityObj = PocketQuery.getEntity('template', entityname);
        PQEntityObjects.push(entityObj);
        outputString += '\n\n=== '+ entityname +' ===\n' + entityObj.content;
    });
 
    console.log('All template objects:');
    console.log(PQEntityObjects);
 
    console.log('All template content:');
    console.log(outputString);
 
}(jQuery))

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, atlassian community, job interviews, interview tips, career advice, interview preparation, job search, interview experiences, hiring process, atlassian careers, community discussion, interview best practices

Interview Tips & Pet Peeves ✍️

Join the discussion on interview best practices and common pitfalls. Share your experiences and learn from others in the Atlassian Community.

Share you experiences!
AUG Leaders

Atlassian Community Events