You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I have utilized Jira Cloud interface for Excel. Defined a filter and select the needed fields. I then copy Workbook 1 to Workbook 2. In Workbook 2, I change the filter. The Filter in Workbook 1 is now changed.
We are experiencing this exact issue. To help with planning, we created a MS Excel workbook as a template with 2 worksheets for teams to use. Sheet 1 (titled Team Name) uses Sheet 2 as a reference. Sheet 2 (titled Raw Data). Sheet 2 has a JQL query that contains a team name. The intent is that each team would save a copy of the workbook and update the JQL query with their team name to pull data. 3 teams have saved the workbook and changed the JQL query to change the team name to theirs. However, what this is doing is somehow changing the JQL query in the template and the other saved workbooks. So, the template and any saved workbooks changes to whomever changed the JQL query last in their own copies. If any of the 3 saved workbooks update their query to another team name, this same query is now populating in the copies and the template. I hope this makes sense.
What we would like to know is what data does the plugin refer to and how does saving a copy of a workbook template, changing its query, change the query for all workbooks that spawned out of the template?
Thanks for clarifying, I had to ask because I've gone off completely the wrong way when someone said just "workbook" more than once, and I didn't want to waste your time!
I suspect your two workbooks are linked to the same saved filter in Jira, so they are both edited one single object in Jira when you change the filter in them. You'll need to edit one of them, changing the pointer to the linked filter, not the filter itself. Once they're pointing at different filters, edits won't affect the other workbook.
I would totally understand and EXPECT that changes to a saved query would in fact reflect changes. I'm not even using saved filter. Go into the Workbook(WB)1 and define a query:
issueKey in (GIV-79001,GIV-90812,GIV-103680,GIV-110006)
Copy WB1 file to WB2.
Edit the above query in WB1 and it will change in WB2 and vice versa.
In fact, I have a second scenario: WB3 does use a saved filter. Copy WB3 to WB4. Go into WB4 and change to different saved filter and WB3 will be updated - very concerning/confusing.