nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do i get filters details through mysql. is there any mysql query?

srrekanth

I need total filters list with owner,project name who has registered subscribed filters and i want a query for fetching these details.

Accepted answers

All comments

Udo Brand

you need to query the tables searchrequest and filtersubscription join them via searchrequest.id and filtersubscription.filter_i_d

C.Faysal {CFcon}

you may want to look at

https://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA

there is an example for "List Filter Subscriptions"

srrekanth

Hi Udo,

This query which you have shared i am getting for only 27 filters but in jira we have around 151 filters.while performing in JIRA UI through

ADMIN->USERS->SHARED FILTERS->

srrekanth

Hi Udo,

In jira we have 151 filters and please share the query a/c to it and this should include all the deatails like in UI.we are facing problem in query request to share the MYSQL QUERY.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

bug