diff -r 1d48b38ca349 -r 9365c7fb0240 src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt --- a/src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt Sun Oct 10 15:12:12 2021 +0200 +++ b/src/main/kotlin/de/uapcore/lightpit/dao/PostgresDataAccessObject.kt Sat Nov 27 10:44:17 2021 +0100 @@ -604,8 +604,8 @@ } withStatement( """ - insert into lpit_issue_history_data (component, status, category, subject, description, assignee, eta, affected, resolved, eventid) - values (?, ?::issue_status, ?::issue_category, ?, ?, ?, ?, ?, ?, ?) + insert into lpit_issue_history_data (component, status, category, subject, description, assignee, assignee_username, eta, affected, resolved, eventid) + values (?, ?::issue_status, ?::issue_category, ?, ?, ?, ?, ?, ?, ?, ?) """.trimIndent() ) { setStringOrNull(1, issue.component?.name) @@ -614,10 +614,11 @@ setString(4, issue.subject) setStringOrNull(5, issue.description) setStringOrNull(6, issue.assignee?.shortDisplayname) - setDateOrNull(7, issue.eta) - setStringOrNull(8, issue.affected?.name) - setStringOrNull(9, issue.resolved?.name) - setInt(10, eventid) + setStringOrNull(7, issue.assignee?.username) + setDateOrNull(8, issue.eta) + setStringOrNull(9, issue.affected?.name) + setStringOrNull(10, issue.resolved?.name) + setInt(11, eventid) executeUpdate() } } @@ -725,6 +726,7 @@ subject = getString("subject"), description = getString("description") ?: "", assignee = getString("assignee") ?: "", + assigneeUsername = getString("assignee_username") ?: "", eta = getDate("eta"), affected = getString("affected") ?: "", resolved = getString("resolved") ?: ""