Is there a query I can write to bulk update the Product owner for a list of Epics & Stories? I need to update the Product owner name where All epics containing the letters of "CDRL" and their related stories.
Thanks
Karen
Hello @Karen F. Schaefer
Is "Product owner" a User Picker field in each of the issues you want to update? If so you can use the Advanced Issue Search screen to get a list of issues, and then click on the ... button in the upper right corner and select Bulk Change to work through a wizard that will help you change the selected issues.
As per my answer in your other post to search for a set of Epics and all their child issues using native Jira functionality you would need to explicitly list the Epic keys thus:
issue in (<comma separated list of Epic issue keys>) or "Epic Link" in (<comma separated list of Epic issues keys>)
Since you need your list of Epics to be based on search criteria you will have to create a filter for the Epics separate from the filter for the child stories, and use the Bulk Change feature on the two sets of results separately.
What field in the Epics contains the letters "CDRL"? Is that in text/paragraph fields, or other fields?
If it is only in text fields then you would use the ~ operator; i.e.
type = Epic and summary ~ "CDRL"
This page provide more information about search syntax for text fields:
https://support.atlassian.com/jira-software-cloud/docs/search-syntax-for-text-fields/
When you have confirmed that your list of Epics is correct you will need to make note of the issue keys listed for those Epics and use that for comma separated list of Epics to retrieve all the child stories in a separate filter.
"Epic Link" in (<comma separated list of Epic issues keys>)
There are third party applications that you can add to your Jira system, at a cost, that will extend the JQL functionality so that you could embed your Epic search criteria into a single filter that would retrieve both the Epics and the child stories. You might want to check if you have any of those third party apps already.
https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=jql
Thank you for your assistance - is there a way to do a wild card on the epic name without any special add on tools to jira?
Karen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The document link I provided concerning searching with text field criteria:
https://support.atlassian.com/jira-software-cloud/docs/search-syntax-for-text-fields/
...discusses the options that can be used when specifying the text to find, including wildcards.
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.