Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,465,475
Community Members
 
Community Events
176
Community Groups

Chage JIRA Cloud Feature in workbook 1 changes in workbook 2

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.

Why?

2 answers

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?

Nobody seems to have that answer.

0 votes

Welcome to the Atlassian Community!

What do you mean by "workbook"?

Excel workbook file.  Need to understand why but it appears that a Query defined in the import of one workbook has a unique identification because changing it has impact on a second workbook that has been copied: 

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.

It's not confusing - your workbooks are configured to change shared objects.

You have my attention.... I will need to dig into this further.

@Nic Brough -Adaptavist- I have poked around and don't find any reference to changing this configuration - would you have ready references?

I'm afraid I don't know how the app is injecting shared filters into your workbooks, so I'm a bit stuck!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS

Atlassian Community Events