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.defaultFetchSize
500
EXTRA_OPTION_MYSQL.useCursorFetch
true
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
PORT_NUMBER
3307
QUOTE_ALL_FIELDS
N
STREAM_RESULTS
Y
SUPPORTS_BOOLEAN_DATA_TYPE
N
USE_POOLING
N
redmine MIGRATE
127.0.0.1
MYSQL
Native
redmine_migrate
3306
redmine
Encrypted 2be98afc86aa7f2e4cb0bab74d39ba1df
EXTRA_OPTION_MYSQL.defaultFetchSize
500
EXTRA_OPTION_MYSQL.useCursorFetch
true
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
PORT_NUMBER
3306
QUOTE_ALL_FIELDS
N
STREAM_RESULTS
Y
SUPPORTS_BOOLEAN_DATA_TYPE
N
USE_POOLING
N
redmine TO
127.0.0.1
MYSQL
Native
redmine_sup
3307
redmine_sup_user
Encrypted 2beeacaac07ce9c81940abb608fc0fc8e
EXTRA_OPTION_MYSQL.defaultFetchSize
500
EXTRA_OPTION_MYSQL.useCursorFetch
true
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
PORT_NUMBER
3307
QUOTE_ALL_FIELDS
N
STREAM_RESULTS
Y
SUPPORTS_BOOLEAN_DATA_TYPE
N
USE_POOLING
N
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
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
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
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
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
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