I'm using Jira data replicated into my warehouse, and I'm wondering how could I manage to filter the data in the issues table to only get the issues in the currently active sprint. It's required for some reporting, and I'd like to make it dynamically to always target current sprint, and drop the tickets either in the backlog or past sprints.
Thanks a lot!
Thanks for the reply!
Yes, I've already checked those, but I have no table named ao_60db71_sprint, so that's why I'm asking.
I thought I could get it by combining issues table and one I found with the sprints data (including a status column), but not working:
SELECT * FROM jira.issues
WHERE id IN(
SELECT _sdc_source_key_id FROM jira.issues__fields__customfield_10007
WHERE boardid = 207 --specific board I'd like to pull data from
AND state = 'active');
This involves some reverse engineering to understand the Jira Software AO tables. I think I would start by using REST at
which returns a list of sprints, find the ID of the active sprint and then use
to get the issues. Once that was working I would jump into the source code for the REST API for Jira Software and see what tables are being used.
Alternatively poke around a test instance (not warehouse) and the AO_60DB71 tables. Then take that info to the warehouse tables.
We are excited to announce the open beta program for self-hosted runners. Bitbucket Pipelines Runners is available to everyone. Please try it and let us know your feedback. If you have any issue...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events