Query or detect whether an add-on has been used on a particular issue

Jacin Ferreira

Running JIRA Server 7.9.0 with qTest Add-On installed.

I'm looking for the ability to run a query in JIRA to see which Tasks have something populated inside the qTest Add-On.

The end goal is to be able to see which Tasks do not have anything populated in the qTest Add-On to see which Tasks still need test cases associated with them.

The best case scenario would to be able to have qTest populate a field or a label of some sort automatically when the they are associated in qTest, but it doesn't, and am looking for a creative workaround.

Andy Heinzer

I should preface this response with the fact that I have not used this plugin and I don't know how it works.

That said, the approach I would take here, since you're using Jira Server, would be first login to Jira as an admin, and then navigate to the Gear Icon -> System -> Plugin Data Storage.  Or navigate directly to [YourJiraURL] /plugins/servlet/active-objects/tables/list

This page will list all the Active Object (AO) tables in your Jira database.  I would look for the ones associated with the qTest plugin first.  Then with this information, I would look to access your Jira database directly, using your native database tools, like pgAdmin, MySQLworkbench, MS SQL studio manager, etc depending on your flavor of linux.

Now I should point out that I'm not advocating for making any changes via SQL directly.  However you should be able to perform some SQL select statements on these tables to better understand how the data in them relate to Jira issues.  From there I would imagine that one or more of these tables likely make reference to your jiraissue table in the same database.  This table contains all the issues in your Jira instance.