I've found the filtersubscription table and related it to the searchrequest table. I need to find out where the subscription frequency is stored. I'm having a problem with a couple of subscriptions and need to see when they are run without looking up every filter through the UI.
Hi Chris,
That is inside the jquartz_triggers table. You can get those with:
SELECT * FROM jquartz_triggers WHERE trigger_name LIKE '%com.atlassian.jira.issue.subscription.DefaultSubscriptionManager%';
The trigger_name of subscription will look like:
com.atlassian.jira.issue.subscription.DefaultSubscriptionManager:10100
I hope this helps!
The jquartz_triggers only shows when the next run is. This worked well enough for me to get the info I needed though. Just an fyi for anyone else passing through, the actual frequency is listed under the jquartz_cron_triggers. Also they changed the format of the trigger_name to just SUBSCRIPTION_10100. At least this is true with Jira 6.1.6.
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.