If you only have one epic, is not difficult to do by hand. If your task keys are ABC-1, ABC-2 and ABC3 and your epic is ABC-4, search for
And run the bulk change on them.
In my case, I delinked ALL my epics (I changed their type to a custom "epic", only to discover that there's no such thing). With ~70 epics I needed more automation, so I wrote a script. Is super-tailored to what I needed, so I'll leave it here and then it's up to you to modify it accordingly.
My workflow consisted in copying the history of an Epic into a text file called "History.txt" straight from my browser. Then the script will look for changes made by the specified user (as my mistake was caused by an automation, the user was "Automation for Jira"). The script will output the JQL query needed for Bulk Changing. As that was going to be a lot of work, I looked around and found GitHub - ankitpokhrel/jira-cli: 🔥 [WIP] Feature-rich interactive Jira command line., a Jira CLI interface. My script also will build the command that needs to be executed to link a number of issues to an epic, but if you don't want that, just comment the lines. It's based on Go, so you might need that too, or if you don't want to go through that hassle, use the JQL query.
To run it, for example, to search for changes made by "Automation by Jira" in the epic's history that is pasted on "History.txt", of an Epic with key "ABC-4" on a project with acronym "ABC", I would call it like this
The script: JiraLinker.py PS: looks like this garbage doesn't like big code sections, and renders them as normal text!
class Lvl(str, Enum):
"""Debug log levels
The different logging levels and the colours associated to the output
"""
ERROR = "\x1b[0;31;22m" # RED + normal mode
OK = "\x1b[0;32;22m" # GREEN
WARNING = "\x1b[0;33;22m" # YELLOW
# YELLOW, but I can use in temporary debugs and then delete
DEBUG = "\x1b[0;33;22m"
INFO = "\x1b[0;36;22m" # CYAN
NORMAL = "\x1b[0;37;22m" # NORMAL white text
RESET = "\x1b[0m" # Reset
def debugPrint(level: Lvl, msg: Any) -> None:
"""Prints coloured text
Args:
level: a member of the class lvl, that indicates the level of the messsage
msg: a string to be printed with the selected colour
"""
print(f"{level}" + f"{msg}" + f"{Lvl.RESET}")
def buildQuery(listOfIssues: list[str], projectAcronym: str) -> str:
searchQuery: str = 'project = "' + projectAcronym + '" and ('
for key in listOfIssues[:-1]:
searchQuery += 'key="' + f'{key}' + '" or '
searchQuery += 'key="' + listOfIssues[-1] + '") ORDER BY created DESC'
return searchQuery
# Parse CLI arguments
parser = ArgumentParser()
parser.add_argument("-p", "--projectAcronym",
help="The acronym of the project containing the issues", type=str, required=True)
parser.add_argument("-t", "--history",
help="Path to the file that contains the pasted history of the epic", type=str, required=True)
parser.add_argument("-e", "--epicKey",
help="The issue number or key of the Epic that has had its children removed",
type=str, required=True)
parser.add_argument("-u", "--user",
help="The user that created all the havoc!",
type=str, required=True)
args = parser.parse_args()
filename: Path = Path(args.history)
project: str = args.projectAcronym
epicKey: str = args.epicKey
user: str = args.user
try:
with open(filename, encoding="utf-8") as f:
history = f.read()
# This will need to be changed in order to match your case
childs = findall(rf'({user})(\n )(updated the Epic Child)([\s\w\d,:]*)({project}-[\d]+)(\n)(None)', history)
if childs:
issueNumbers = [child[4] for child in childs]
issueNumbers.sort()
for child in childs:
debugPrint(Lvl.OK, child[0] + " " + child [2] + " " + child[4] + " -> " + child[6])
jqlQuery = buildQuery(issueNumbers, project)
debugPrint(Lvl.OK, "JQL Search Query (for bulk editing)")
debugPrint(Lvl.INFO, jqlQuery)
jiraCliCommand = "jira epic add " + str(epicKey) + " " + " ".join(issueNumbers)
debugPrint(Lvl.OK, "Jira CLI Command)")
debugPrint(Lvl.INFO, jiraCliCommand)
try:
# Run the following command, redirecting stdin and stdout to be able to send input and display the output of the
# command. Stderr is redirected to sdtout so it's displayed in context. Universal Newlines to true makes
# Popen return text, instead of binary strings
# Redirecting stdin allows us to send an enter, becuase the batch file ends in a "press ENTER to continue..."
process = Popen(jiraCliCommand.split(), stdin=PIPE,
stdout=PIPE, stderr=STDOUT, universal_newlines=True)
# Send the enter the script is waiting for to end execution
process.communicate("\r\n")
debugPrint(Lvl.INFO, f"Output of '{jiraCliCommand}'")
# Print the output of the command. communicate() returns a string tuple with the stdout and stderr, although
# stderr is redirected to stdout already, and will be empty
(stdout, _) = process.communicate()
if stdout:
debugPrint(Lvl.INFO, stdout)
# If the command returns other than 0, exit
if (process.returncode != 0):
exit(1)
except FileNotFoundError as err:
debugPrint(Lvl.ERROR, 'ERROR: ' + str(err))
else:
debugPrint(Lvl.WARNING, "No Epic Child updates found in the history")
except FileNotFoundError:
debugPrint(Lvl.ERROR, "File not found?")
raise
****************** END OF THE SCRIPT ***************************
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.