JIRA2PM Help
Connection settings
Connection settings consist of 3 fields:
- Username - username which you use in JIRA
- Password - password for your account
- Base URL - base url of your JIRA server. In case of cloud JIRA hosting it will look like this:
https://example.atlassian.net/
After filling all fields, press
connect
to connect to JIRA. Button should be changed to the success message after connecting.
JQL Query
- JQL Query - A query which you want to fetch. You can create it in JIRA and then copy to this field
- Fields to Show - Fields which will be displayed in table
- Custom Fields - Custom JIRA fields. Each custom field has fields for regular expression which allows more control over formatting. Displayed value will be the first regex result.
For example field which looks like com.atlassian.greenhopper.service.sprint.Sprint@[id=12,rapidViewId=12,state=ACTIVE,name=12 — Sprint 12,startDate=2012-12-12T12:12:12.121+12:12,endDate=2012-12-12T12:12:12.121+12:12,sequence=12]
and with regular expression .*name=(.*)\,startDate.*
will fetch sprint name and display just 12 — Sprint 12
Display Options
- Fields Displayed as Hyperlinks - selected fields will be displayed as hyperlinks to issues or JQL queries
- Date Format - Format to display dates. Y - year, M - month, D - day, h - hour, m - minute, s - second
- Estimation Unit - Unit in which estimations will be displayed
- Sort by parents - Sort issues by epics and subtasks. Epics have additional formatting
Setup Storage
- Refresh every... - If this option has been selected - the add-on should check was the last row inserted in the table before the selected time interval. If it was, the old information will be updated
Get Result
- Send Request - Sends request to JIRA with selected options and inserts received data into active sheet
- Clean Sheet and Send Request - Additionaly cleans sheet before inserting data from request
- Send Request and Insert Data into New Sheet - Inserts data from request to newly created sheet
Utilities
- Convert to JIRA Link - Converts selected keys in sheet to link for JIRA with these keys