_SvIncludePlusContent-_DP_Schema_Issues_Jira
All data relating to issues will be exported to issues CSV file.
| Field | Description |
|---|---|
id (Primary Key) | Type: Number Description: Unique ID of this issue. Use as Primary Key. Example: |
| instance_url | Type: String Description: Base url of the current instance Example: |
| url | Type: String Description: URL of the issue Example: |
| key | Type: String Description: Unique Key for this issue Example: |
| project_key | Type: String Description: Key of the project this issue is in Example: |
| project_name | Type: String Description: Title of the project this issue is in Example: |
| project_type | Type: String Description: Type of the project this issue is in (can be Business, Software, Service Desk) Example: |
| project_category | Type: String Description: Assigned category for the project this issue is in Example: |
| issue_type | Type: String Description: Type of issue (for example, task, bug, or epic) Example: |
| summary | Type: String Description: Summary of the issue Example: |
| description | Type: String Description: Description of the issue (limited to 2000 characters) Example: |
| creator_id | Type: Number Description: Unique identifier of the user who created the issue, regardless of directory Example: |
| creator_name | Type: String Description: Name of the user issue creator Example: Schema: Version 1 only. This data is now contained in the Users file. |
| reporter_id | Type: Number Description: Unique identifier of the issue reporter, regardless of directory Example: |
| reporter_name | Type: String Description: Name of the issue reporter Example: Schema: Version 1 only. This data is now contained in the Users file. |
| assignee_id | Type: Number Description: Unique identifier of the issue assignee, regardless of directory Example: |
| assignee_name | Type: String Description: Name of the issue assignee Example: Schema: Version 1 only. This data is now contained in the Users file. |
| status | Type: String Description: Current status of this issue Example: |
| status_category | Type: String Description: Status category for the current status for this issue Example: |
| priority_sequence | Type: String Description: The priority order (admins can change this which will result in non-deterministic priority orders) Example: |
| priority_name | Type: String Description: Name of the priority for this issue Example: |
| resolution | Type: String Description: The final status of an issue. Jira considers the workflow of an Issue complete once a value is present in the resolution field. Example: |
| watcher_count | Type: Number Description: Number of users watching this issue Example: |
| vote_count | Type: Number Description: Number of votes for this issue Example: |
| created_date | Type: Date Description: UTC timezone creation date of this issue (ISO string) Example: |
| resolution_date | Type: Date Description: UTC timezone resolution date of this issue (ISO string) Example: |
| updated_date | Type: Date Description: UTC timezone date that this issue was last updated (ISO string) Example: 2020-11-05T14:44:57Z |
| due_date | Type: Date Description: UTC timezone date that this issue is due to be completed (ISO string) Example: |
| estimate | Type: Number Description: Estimate time remaining from original estimate, in seconds (requires time-tracking enabled) Example: |
| original_estimate | Type: Number Description: Original estimate that was set, in seconds (requires time-tracking enabled) Example: |
| time_spent | Type: Number Description: Amount of logged work, in seconds (requires time-tracking enabled). Field is null if there is no time spent. Example: |
| labels | Type: String Description: JSON array of label names. Field is null if there are no labels. Example: |
| components | Type: String Description: JSON array of component names. Field is null if there are no labels. Example: |
| parent_id | Type: Number Description: ID of the parent issue. Field is null if the issue is not a subtask. Example: |
| environment | Type: String Description: A short description of the environment in which the issue occurred (for example, Example: |
| affected_versions | Type: String Description: JSON Array of Affected Version Names. Field is null if there are no labels. Example: |
| fix_versions | Type: String Description: JSON array of fix version names. Field is null if there are no labels. Example: |
| security_level | Type: String Description: Security level name. NOTE: This can change between data exports. Example: |
| Type: Number Description: Unique identifier of the user who archived the issue, regardless of directory. Example: Schema: Version 1 and later (requires Jira 8.19 or later) |
| Type: Date Description: UTC timezone date this issue was archived (ISO string). Example: Schema: Version 1 and later (requires Jira 8.19 or later) |