I need total filters list with owner,project name who has registered subscribed filters and i want a query for fetching these details.
you need to query the tables searchrequest and filtersubscription join them via searchrequest.id and filtersubscription.filter_i_d
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"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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->
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Since it is my Birthday: here the query
select * from searchrequest sr left outer join filtersubscription fs on sr.id = fs.filter_i_d
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
OH Happy B-DAY UDO!!!!
All the best for you...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.