Finding every filter which name starts with a given prefix Edited

Hello,

we intensively use filters in the frame  of our projects.

Filter names match a naming convention.

We want to create a confluence page listing every filter which name starts with a certain prefix. We don't want to manually manage this page.

 

An idea would be to create a JQL listing all filters. But filters return only issues and does not return a filter list.

Have you got a workaround for such a JQL:

filter ~MY-PREFIX

and that would return a list of filters.

A plugin or any other alternative would be very appreciated.

 

Thanks a lot !

1 answer

0 vote
Lenard Lee Atlassian Team Nov 14, 2017

Hi Michael,

Allow me to offer my 2 cents. For your information, filters are saved in JIRA's database in the "searchrequest" table.

Perhaps you could try querying the table directly to return a list of filters fitting your search conditions.

An example would be like the picture below:

image.png

Hope this helps in some ways!

Regards,
Lenard

Thank you Leonard!

Since you are tagged as Atlassian team, I assume there is no better solution than the one you propose, at least in the current newest JIRA version.

So I am going to ask our JIRA administrator whether they allow querying the searchrequest table, perhaps using a specific interface such as a read only web service or something else.

 

For the moment, my current alternative, was not to use JIRA filters. Instead I use Confluence pages with a specific name, including the JIRA macro. The JIRA macro uses a JQL and does not reference a filter.

And a main Confluence page contains links to the pages containing the JQL.

So I meet my initial requirement, by using page+JIRA macro, instead of filters.

It's a shame to do without filters, and I would prefer to get rid of numerous Confluence pages, but this is life.... And it is perhaps easier for end users. Also another filter trap: we can modify them on the JIRA side without knowing that they are used in the Confluence JIRA / Filter macro. So if we delete or modify them in JIRA, it can affect several Confluence pages without our knowledge.
Hence my initial desire to list a set of filters, rather than filter filter links.
My solution with Confluence pages containing JQL avoids this problem, but leads to a multiplication of pages.

Lenard Lee Atlassian Team Nov 15, 2017

Hi Michael,

I think there should be a better way to do this, but I'm unable to come up with any other ideas.

There could be some plugins or scripts our there that could achieve this.

But you are indeed correct. The JQL filters return JIRA issues as results. I mean, as far as I know, you can't use a filter, to return a filter.

Best regards,
Lenard

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,321 views 14 20
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot