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.

[Udo Brand]

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

[Cee Cane]

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.

[Udo Brand]

Hi Kanthu, I guess the 27 have a subscription while the rest has not. Do an outer join then you should get all.

Cheers,

Udo

[Udo Brand]

Since it is my Birthday: here the query

select * from searchrequest sr 
left outer join filtersubscription fs 
on sr.id = fs.filter_i_d

[Cee Cane]

OH Happy B-DAY UDO!!!!

All the best for you...