llua_jira_issue_dimension-dist Normal 0 / ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER CLIENT N CLIENT ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE METRICS_DATE Y METRICS_DATE METRICS_CODE Y METRICS_CODE METRICS_DESCRIPTION Y METRICS_DESCRIPTION METRICS_SUBJECT Y METRICS_SUBJECT METRICS_TYPE Y METRICS_TYPE METRICS_VALUE Y METRICS_VALUE 0.0 0.0 10000 50 50 N Y 50000 Y N 1000 100 cluster N dynamic Y 1 ati-dev-ana01 ati-dev-ana01 9081 pentaho-di njain Encrypted 2be98afc86aa7f2e4bb18bd63c99dbdde Y N ATI-PRD-ANA03 ATI-PRD-ANA03 9080 pentaho-di admin Encrypted 2be98afc86aa7f2e4bb18bd63c99dbdde N N ATI-STG-ANA03 ATI-STG-ANA03 9080 pentaho-di pentaho Encrypted 2be98afc86aa7f2b4ae17ba71d69dff8b N N DI Server localhost 9080 pentaho-di joe Encrypted 2be98afc86aa7f2e4bb18bd63c99dbdde Y N DI Server 5.0 localhost 9080 pentaho-di admin Encrypted 2be98afc86aa7f2e4bb18bd63c99dbdde Y N local 127.0.0.1 9080 cluster Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8 Y N Master localhost 8081 cluster Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8 Y N remote 192.168.1.16 9080 pentaho-di/kettle admin Encrypted 2be98afc86aa7f2e4bb18bd63c99dbdde Y N Slave1 localhost 8082 cluster Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8 N N Slave2 localhost 8083 cluster Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8 N N Slave3 localhost 8084 cluster Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8 N N Slave4 localhost 8085 cluster Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8 N N Slave5 localhost 8086 cluster Encrypted 2be98afc86aa7f2e4cb1aa265cd86aac8 N N ClusterSchema 40000 2000 5000 Y N Slave3 Slave2 Slave1 Master ClusterSchema_dynamic 40000 2000 5000 Y Y Master - 2020/08/06 22:06:26.911 schmitz 2022/06/03 16:08:42.849 H4sIAAAAAAAAAAMAAAAAAAAAAAA= N Extract and Transform 16 16 145 26 .AppleSystemUIFont 13 N N 0 0 0 255 205 112 100 100 100 Y !!! Verify that the ID of the custom field "Sprint" is actually "10108" in your database. You will find the custom fileds in the "customfield" table of your Jira database. !!! 16 1520 510 74 .AppleSystemUIFont 13 N N 0 0 0 255 205 112 100 100 100 Y Jira DB [ihre_domain/container_name] POSTGRESQL Native jira [host/container_port] jira Encrypted 2be98c5a118c69686bb18bd63c99dbdde FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N PORT_NUMBER [host/container_port] PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING N Table input - issue Sort rows id Y Table input - project Sort rows id 2 Y Table input - labels Sort rows issue Y Group by label Merge join id - issue Y Sort rows issue Group by label Y Table input - issuetype Sort rows id 3 Y Sort rows id Merge join id - issue Y Merge join id - issue Sort rows project Y Sort rows id 2 Merge join project - id Y Merge join project - id Sort rows issuetype Y Sort rows project Merge join project - id Y Sort rows issuetype Merge join issuetype - id Y Sort rows id 3 Merge join issuetype - id Y Merge join issuetype - id Sort rows id 4 Y Filter rows - epic Filter rows - subtask Y Filter rows - epic epic Y Filter rows - subtask task Y Filter rows - subtask subtask Y Table input - issuelink Sort rows source Y epic Merge join id - source Y task Merge join id - destination Y subtask Merge join id - destination 2 Y Filter rows - epiclink Filter rows - subtasklink Y Filter rows - epiclink epiclink Y Filter rows - subtasklink subtasklink Y subtasklink Merge join id - source 2 Y epiclink Merge join id - source Y Sort rows id 4 Select values only necessary and rename Y Sort rows source Filter rows - epiclink Y Merge join id - source Select values summary and destination Y Sort rows destination Merge join id - destination Y Select values summary and destination Sort rows destination Y Select values only necessary and rename Filter rows - epic Y Select values remove issue and destination Merge join id - source 2 Y Select values remove issue and destination tasks Y Merge join id - source 2 Select values destination, epic, sprint Y Select values destination, epic, sprint Sort rows destination 2 Y Sort rows destination 2 Merge join id - destination 2 Y Merge join id - destination 2 Select values remove destination Y Select values remove destination Append streams Y tasks Append streams Y Table input - sprint Select values ID and NAME Y Table input - customfieldvalue Filter rows customfield = 10108 Y Filter rows customfield = 10108 Sort rows 19 Y Select values ID and NAME Sort rows ID 5 Y Sort rows ID 5 Merge join stringvalue - ID Y Sort rows 19 Merge join stringvalue - ID Y Merge join stringvalue - ID Select values issue and sprint Y Sort rows issue 3 Merge join id - issue 2 Y Merge join id - destination Merge join id - issue 2 Y Merge join id - issue 2 Select values remove issue and destination Y Sort rows id 6 Copy rows to result Y Group by issue, aggregate sprint Sort rows issue 3 Y Select values issue and sprint Sort rows issue 2 Y Sort rows issue 2 Group by issue, aggregate sprint Y epic epic 1 Y epic 1 epic 3 Y Append streams Append streams 2 Y Append streams 2 Sort rows id 6 Y epic 3 Add constants epic and sprint Y Add constants epic and sprint Append streams 2 Y Add constants epic and sprint Constant Y 1 none epic String -1 -1 N sprint String -1 -1 N

1488 2512 Y Append streams Append Y 1 none tasks Select values remove destination

1328 2400 Y Append streams 2 Append Y 1 none Append streams Add constants epic and sprint

1328 2512 Y Copy rows to result RowsToResult Y 1 none

1328 2736 Y Filter rows - epic FilterRows Y 1 none epic Filter rows - subtask N issuetype = constant String Epic -1 -1 N

544 1024 Y Filter rows - epiclink FilterRows Y 1 none epiclink Filter rows - subtasklink N linktype = constant Integer 10200 -1 0 N ####0;-####0

656 1264 Y Filter rows - subtask FilterRows Y 1 none subtask task N issuetype = constant String Sub-task -1 -1 N

1120 1104 Y Filter rows - subtasklink FilterRows Y 1 none subtasklink N linktype = constant Integer 10100 -1 0 N ####0;-####0

656 1968 Y Filter rows customfield = 10108 FilterRows Y 1 none Sort rows 19 N customfield = constant Integer 10108 -1 0 N ####0;-####0

352 1456 Y Group by label GroupBy Y 1 none N N %%java.io.tmpdir%% grp N N issue label label CONCAT_COMMA

448 96 Y Group by issue, aggregate sprint GroupBy Y 1 none N N %%java.io.tmpdir%% grp N N issue sprint sprint CONCAT_COMMA

768 1648 Y Merge join id - destination 2 MergeJoin Y 1 none LEFT OUTER subtask Sort rows destination 2 id destination

1168 2304 Y Merge join stringvalue - ID MergeJoin Y 1 none INNER Sort rows 19 Sort rows ID 5 stringvalue ID

608 1456 Y Merge join id - issue 2 MergeJoin Y 1 none LEFT OUTER Merge join id - destination Sort rows issue 3 id issue

1088 1648 Y Merge join id - issue MergeJoin Y 1 none LEFT OUTER Sort rows id Group by label id issue

544 192 Y Merge join project - id MergeJoin Y 1 none INNER Sort rows project Sort rows id 2 project id

544 416 Y Merge join issuetype - id MergeJoin Y 1 none LEFT OUTER Sort rows issuetype Sort rows id 3 issuetype id

544 656 Y Merge join id - source MergeJoin Y 1 none LEFT OUTER epic epiclink id source

864 1264 Y Merge join id - destination MergeJoin Y 1 none LEFT OUTER task Sort rows destination id destination

1088 1456 Y Merge join id - source 2 MergeJoin Y 1 none INNER Select values remove issue and destination subtasklink id source

1088 1968 Y Select values issue and sprint SelectValues Y 1 none issue sprint N

608 1552 Y Select values summary and destination SelectValues Y 1 none summary epic destination N

864 1360 Y Select values only necessary and rename SelectValues Y 1 none id assignee summary label pname project pname_1 issuetype creator reporter N

544 880 Y Select values remove issue and destination SelectValues N 1 none N destination issue

1088 1792 Y Select values destination, epic, sprint SelectValues Y 1 none destination epic sprint N

1088 2064 Y Select values remove destination SelectValues Y 1 none N destination

1168 2400 Y Select values ID and NAME SelectValues Y 1 none ID NAME sprint N

320 1376 Y Sort rows project SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N project Y N N 0 N

544 288 Y Sort rows issuetype SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N issuetype Y N N 0 N

544 512 Y Sort rows id 3 SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N id Y N N 0 N

304 656 Y Sort rows id 4 SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N id Y N N 0 N

544 752 Y Sort rows source SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N source Y N N 0 N

320 1264 Y Sort rows destination SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N destination Y N N 0 N

864 1456 Y Sort rows destination 2 SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N destination Y N N 0 N

1088 2176 Y Sort rows id 6 SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N id Y N N 0 N

1328 2640 Y Sort rows ID 5 SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N ID Y N N 0 N

608 1376 Y Sort rows 19 SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N stringvalue Y N N 0 N

496 1456 Y Sort rows issue 3 SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N issue Y N N 0 N

944 1648 Y Sort rows issue 2 SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N issue Y N N 0 N

608 1648 Y Sort rows issue SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N issue Y N N 0 N

304 96 Y Sort rows id SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N id Y N N 0 N

304 192 Y Sort rows id 2 SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N id Y N N 0 N

304 416 Y Table input - customfieldvalue TableInput Y 1 none Jira DB SELECT issue , customfield , stringvalue FROM public.customfieldvalue 0 N N N N Integer normal issue 18 0 Table input - customfieldvalue issue ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N Integer normal customfield 18 0 Table input - customfieldvalue customfield ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N String normal stringvalue 255 -1 Table input - customfieldvalue stringvalue . , none N Y 0 N N N en_US Europe/Berlin N

144 1456 Y Table input - issue TableInput Y 1 none Jira DB SELECT id , project , assignee , reporter , creator , issuetype , summary FROM public.jiraissue 0 N N N N Integer normal id 18 0 Table input - issue id ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N Integer normal project 18 0 Table input - issue project ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N String normal assignee 255 -1 Table input - issue assignee . , none N Y 0 N N N en_US Europe/Berlin N String normal reporter 255 -1 Table input - issue reporter . , none N Y 0 N N N en_US Europe/Berlin N String normal creator 255 -1 Table input - issue creator . , none N Y 0 N N N en_US Europe/Berlin N String normal issuetype 255 -1 Table input - issue issuetype . , none N Y 0 N N N en_US Europe/Berlin N String normal summary 255 -1 Table input - issue summary . , none N Y 0 N N N en_US Europe/Berlin N

144 192 Y Table input - issuelink TableInput Y 1 none Jira DB SELECT linktype , "source" , destination FROM public.issuelink 0 N N N N Integer normal linktype 18 0 Table input - issuelink linktype ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N Integer normal source 18 0 Table input - issuelink source ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N Integer normal destination 18 0 Table input - issuelink destination ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N

144 1264 Y Table input - issuetype TableInput Y 1 none Jira DB SELECT id , pname FROM public.issuetype 0 N N N N String normal id 60 -1 Table input - issuetype id . , none N Y 0 N N N en_US Europe/Berlin N String normal pname 60 -1 Table input - issuetype pname . , none N Y 0 N N N en_US Europe/Berlin N

144 656 Y Table input - labels TableInput Y 1 none Jira DB SELECT issue , label FROM public.label 0 N N N N Integer normal issue 18 0 Table input - labels issue ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N String normal label 255 -1 Table input - labels label . , none N Y 0 N N N en_US Europe/Berlin N

144 96 Y Table input - project TableInput Y 1 none Jira DB SELECT id , pname FROM public.project 0 N N N N Integer normal id 18 0 Table input - project id ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N String normal pname 255 -1 Table input - project pname . , none N Y 0 N N N en_US Europe/Berlin N

144 416 Y Table input - sprint TableInput Y 1 none Jira DB SELECT * FROM public.AO_60DB71_SPRINT 0 N N N N Boolean normal CLOSED -1 -1 Table input - sprint CLOSED . , none N Y 0 N N N en_US Europe/Berlin N Integer normal COMPLETE_DATE 15 0 Table input - sprint COMPLETE_DATE ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N Integer normal END_DATE 15 0 Table input - sprint END_DATE ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N String normal GOAL 2147483647 -1 Table input - sprint GOAL . , none N Y 0 N N N en_US Europe/Berlin N Integer normal ID 15 0 Table input - sprint ID ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N String normal NAME 255 -1 Table input - sprint NAME . , none N Y 0 N N N en_US Europe/Berlin N Integer normal RAPID_VIEW_ID 15 0 Table input - sprint RAPID_VIEW_ID ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N Integer normal SEQUENCE 15 0 Table input - sprint SEQUENCE ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N Boolean normal STARTED -1 -1 Table input - sprint STARTED . , none N Y 0 N N N en_US Europe/Berlin N Integer normal START_DATE 15 0 Table input - sprint START_DATE ####0;-####0 . , none N Y 0 N N N en_US Europe/Berlin N

144 1376 Y epic Dummy N 1 none

864 1024 Y epic 1 Dummy Y 1 none

1616 1024 Y epic 3 Dummy Y 1 none

1616 2512 Y epiclink Dummy Y 1 none

768 1264 Y subtask Dummy Y 1 none

1168 1248 Y subtasklink Dummy Y 1 none

880 1968 Y task Dummy Y 1 none

1088 1248 Y tasks Dummy Y 1 none

1328 1792 Y N