Jira

Project management tool & issue tracking.

• Jira (Atlassian)
• How to process pentest findings with Jira and Confluence (Blog on Security)
• Create an issue and a subtask (Atlassian)

JQL

• Use advanced search with Jira Query Language (JQL) (Atlassian)

Examples

type = "whatever" order by key desc

type = "whatever" and Assignee = currentUser() order by "CustomID"desc, key desc

watcher = currentUser() ORDER BY created DESC

not (reporter = jsmith or reporter = jbrown)

Import CSV file to issues

Export Excel to CSV file

• Change your list separator on Windows.
  • Open the Control Panel.
  • Click on Clock and Region (or Regional and Language Options).
  • Click on Region (or the Regional Options tab).
  • Click on Additional settings.
  • Change the List separator to “|” (or any character that is not present in your data).
  • Click OK.
• Open the file in Excel.
• Add a column named “IssueType”. Enter the Jira issue type for each line in this column. If this column is not present, Jira will import the data as the default issue type.
• Click on File -> Save As.
• Save as type CSV UTF-8 (Comma delimited) (*.csv). It is necessary to support accents.

Import CSV file

• Go to your project home page.
• Click on the Issues tab.
• Click on “…” beside Detail view.
• Click on Import issues from CSV.
  • Import to Project: Select your project name.
  • File encoding: UTF-8
  • Delimiter: |
  • Date format: yyyy-MM-dd h:mm
• Click on Next.
• For each field from the CSV, select the corresponding field from Jira.

Edit multiple issues

• Go to your project home page.
• Click on the Issues tab.
• Click on More+ and select a column to filter on.
• Click on “…” beside Detail view.
• Click on Bulk change all x issue(s).
• Select the issues to modify.
• Click Next.
• Select Edit Issues and click Next.
• Select the field to modify and edit the value.
• Click Next.