Below is query to retrieve redmine issue data including comments
SELECT i.id as issueId, i.subject as issueSubject, i.description
as issueDescription, i.due_date as issueDueDate, i.priority_id
as issuePriorityId, i.created_on as issueCreatedOn,
i.updated_on as issueUpdatedOn, i.start_date as issueStartDate,
i.done_ratio as issueDoneRatio, i.estimated_hours as issueEstimatedHour,
tr.name as trackerName,
p.name as projectName, p.description as projectDescription,
p.homepage as projectHomePage, p.created_on as projectCreatedOn,
p.updated_on as projectUpdatedOn, p.identifier as projectIdentifier,
c.name as categoryName, s.name as statusName,s.name as resolutionName,
u.login as assignedToLogin, u.firstName as assignedToFirstName,
u.lastName as assignedToLastName, u.mail as assignedToMail,
v.name as fixedVersionName, v.effective_date as fixedVersionEffectiveDate,
au.login as authorLogin, au.firstName as authorFirstName,
au.lastName as authorLastName, au.mail as authorMail,
(select group_concat(concat_ws(' ',j.created_on, ju.login, j.notes) separator '\n')
from journals j left join users ju on ju.id=j.user_id where j.journalized_id=i.id and length(j.notes) > 0) as note
FROM issues i left join trackers tr on tr.id=i.tracker_id
left join projects p on p.id = i.project_id
left join issue_categories c on c.id=i.category_id
left join issue_statuses s on s.id=i.status_id
left join trackers t on t.id=i.tracker_id
left join users u on u.id=i.assigned_to_id
left join versions v on v.id=i.fixed_version_id
left join users au on au.id=i.author_id
where i.id is not null order by i.project_id, i.id
Properties are:
# written by PropertiesConfiguration
# Fri Jun 25 02:33:12 WIT 2010
importsingleproject = false
importexistingproject = false
mapfromcsv = true
field.projectName = project.name
field.issueCreatedOn = created
field.issueUpdatedOn = updated
field.issueDueDate = duedate
field.issueEstimatedHour = customfield_10001
field.issueSubject = summary
field.fixedVersionName = fixVersions
field.projectDescription = project.description
field.issuePriorityId = priority
field.projectIdentifier = project.key
field.issueId = customfield_10000
field.authorLogin = reporter
field.issueDescription = description
field.statusName = status
field.assignedToLogin = assignee
field.trackerName = type
field.categoryName = components
field.projectHomePage = project.url
value.statusName.Feedback = 5
value.statusName.Resolved = 5
value.issuePriorityId.7 = 1
value.issuePriorityId.5 = 3
value.issuePriorityId.6 = 2
value.trackerName.Test = 5
value.trackerName.Feature = 4
value.trackerName.Support = 3
value.issuePriorityId.4 = 4
value.issuePriorityId.3 = 5
value.statusName.Closed = 6
value.trackerName.Bug = 1
value.statusName.New = 1
value.trackerName.Task = 3
value.statusName.Rejected = 5
value.statusName.Assigned = 3
date.import.format = yyyy-MM-dd
user.email.suffix = @katalisindonesia.com
existingprojectkey = AKLI
field.fixedVersionEffectiveDate = resolutiondate
field.note = comment
field.resolutionName = resolution
value.resolutionName.Feedback = 4
value.resolutionName.Closed = 1
value.resolutionName.Rejected = 2
value.resolutionName.Assigned = Assigned
value.resolutionName.Resolved = 1
value.resolutionName.New =
date.fields = issueCreatedOn
date.fields = issueUpdatedOn
date.fields = issueDueDate
date.fields = fixedVersionEffectiveDate