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.
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:
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.
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG