load-journal-detail / Y N
0.0 0.0 10000 50 50 N Y 50000 Y N 1000 - 2010/12/18 11:17:30.318 redmine FROM 127.0.0.1 MYSQL Native redmine 3307 redmine_user Encrypted 2be98afc86ad59780a610a0758fc0fc8e EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN IS_CLUSTEREDN PORT_NUMBER3307 QUOTE_ALL_FIELDSN STREAM_RESULTSY SUPPORTS_BOOLEAN_DATA_TYPEN USE_POOLINGN redmine MIGRATE 127.0.0.1 MYSQL Native redmine_migrate 3306 redmine Encrypted 2be98afc86aa7f2e4cb0bab74d39ba1df EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN IS_CLUSTEREDN PORT_NUMBER3306 QUOTE_ALL_FIELDSN STREAM_RESULTSY SUPPORTS_BOOLEAN_DATA_TYPEN USE_POOLINGN redmine TO 127.0.0.1 MYSQL Native redmine_sup 3307 redmine_sup_user Encrypted 2beeacaac07ce9c81940abb608fc0fc8e EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN IS_CLUSTEREDN PORT_NUMBER3307 QUOTE_ALL_FIELDSN STREAM_RESULTSY SUPPORTS_BOOLEAN_DATA_TYPEN USE_POOLINGN detail inputFilter unhandledY Filter unhandledignoreY Filter attachmentattachment lookupY Filter unhandledjournal lookupY journal lookupFilter attachmentY Filter attachmentFilter assignedY Filter assigned select values 2Y Filter assignedold assignee lookupY old assignee lookupnew assignee lookupY new assignee lookup select values 2 2Y select values 2 2unionY attachment select valuesunionY select values 2unionY unionjournal outputY Modified Java Script Valueattachment select valuesY attachment lookupModified Java Script ValueY detail input TableInput Y 1 none redmine FROM SELECT id , journal_id as journal_id_from , property , prop_key as prop_key_from , old_value , value FROM journal_details where 1 = 1 and journal_id in ( select id from journals where journalized_id in ( select i.id from issues i where i.project_id = 3 ) ) 0 N N N 400 21 Y ignore Dummy Y 1 none 518 127 Y Filter unhandled FilterRows Y 1 none ignore journal lookup N N property = constantStringcf-1-1N N OR prop_key_from = constantStringfixed_version_id-1-1N 401 124 Y Filter attachment FilterRows Y 1 none attachment lookup Filter assigned N property = constantStringattachment-1-1N 397 333 Y attachment lookup DBLookup Y 1 none redmine MIGRATE N N 0
attachment_from_to
N N prop_key_from id_from = id_to prop_key String 232 381 Y union Dummy Y 1 none 393 757 Y journal lookup DBLookup Y 1 none redmine MIGRATE N N 0 journal_from_to
N N journal_id_from id_from = id_to journal_id Number
397 241 Y
attachment select values SelectValues Y 1 none id -2 -2 property -2 -2 old_value -2 -2 value -2 -2 journal_id -2 -2 prop_key -2 -2 N prop_key prop_key String -2 -2 230 640 Y select values 2 SelectValues Y 1 none id -2 -2 property -2 -2 old_value -2 -2 value -2 -2 journal_id -2 -2 prop_key_from prop_key -2 -2 N 578 568 Y Filter assigned FilterRows Y 1 none old assignee lookup select values 2 N prop_key_from = constantStringassigned_to_id-1-1N 396 423 Y old assignee lookup DBLookup Y 1 none redmine MIGRATE N N 0 user_from_to
N N old_value id_from = id_to old_value_to Integer
395 499 Y
new assignee lookup DBLookup Y 1 none redmine MIGRATE N N 0 user_from_to
N N value id_from = id_to value_to 5 Integer
396 583 Y
select values 2 2 SelectValues Y 1 none id -2 -2 property -2 -2 old_value_to old_value -2 -2 value_to value -2 -2 journal_id -2 -2 prop_key_from prop_key -2 -2 N old_value old_value String -2 -2 value value String -2 -2 395 674 Y journal output TableOutput Y 1 none redmine TO journal_details
1000 N N Y Y N N Y N Y N journal_id journal_id property property old_value old_value value value prop_key prop_key 394 865 Y
Modified Java Script Value ScriptValueMod Y 1 none N 0 Script 1 //Script here var tmp; if (prop_key == null) { tmp = prop_key_from; } else { tmp = prop_key; } tmp prop_key Integer -1 -1 Y 226 519 Y N