andy/ts-etl-mcu-upload-national
1
0
Fork 0
Code Issues 2 Pull Requests Packages Projects Releases Wiki Activity

SQL INJECT LOG #1

New Issue
Open
opened 2024-11-28 10:47:12 +07:00 by andy · 5 comments
andy commented 2024-11-28 10:47:12 +07:00
Owner
Copy Link

INJECT LOG MGM_HEADER

INSERT INTO log_upload_mgm_header(
LogUploadMgmHeaderMgm_HeaderID,
LogUploadMgmHeaderStatus,
LogUploadMgmHeaderRetry,
LogUploadMgmHeaderUploadDate,
LogUploadMgmHeaderCreated
)
SELECT
Mgm_HeaderID AS LogUploadMgmHeaderMgm_HeaderID,
'Y' AS LogUploadMgmHeaderStatus,
0 AS LogUploadMgmHeaderRetry,
CURRENT_TIMESTAMP() AS LogUploadMgmHeaderUploadDate,
CURRENT_TIMESTAMP() AS LogUploadMgmHeaderCreated
FROM mgm_header
LEFT JOIN log_upload_mgm_header
ON Mgm_HeaderID = LogUploadMgmHeaderMgm_HeaderID
WHERE Mgm_HeaderIsActive = 'N' -- Pilih hanya data yang aktif
AND LogUploadMgmHeaderID IS NULL
-- AND Mgm_HeaderMgm_McuID = 17
LIMIT 30000
ON DUPLICATE KEY UPDATE
LogUploadMgmHeaderStatus = VALUES(LogUploadMgmHeaderStatus),
LogUploadMgmHeaderRetry = VALUES(LogUploadMgmHeaderRetry),
LogUploadMgmHeaderUploadDate = VALUES(LogUploadMgmHeaderUploadDate),
LogUploadMgmHeaderLastUpdated = CURRENT_TIMESTAMP;

## INJECT LOG MGM_HEADER INSERT INTO log_upload_mgm_header( LogUploadMgmHeaderMgm_HeaderID, LogUploadMgmHeaderStatus, LogUploadMgmHeaderRetry, LogUploadMgmHeaderUploadDate, LogUploadMgmHeaderCreated ) SELECT Mgm_HeaderID AS LogUploadMgmHeaderMgm_HeaderID, 'Y' AS LogUploadMgmHeaderStatus, 0 AS LogUploadMgmHeaderRetry, CURRENT_TIMESTAMP() AS LogUploadMgmHeaderUploadDate, CURRENT_TIMESTAMP() AS LogUploadMgmHeaderCreated FROM mgm_header LEFT JOIN log_upload_mgm_header ON Mgm_HeaderID = LogUploadMgmHeaderMgm_HeaderID WHERE Mgm_HeaderIsActive = 'N' -- Pilih hanya data yang aktif AND LogUploadMgmHeaderID IS NULL -- AND Mgm_HeaderMgm_McuID = 17 LIMIT 30000 ON DUPLICATE KEY UPDATE LogUploadMgmHeaderStatus = VALUES(LogUploadMgmHeaderStatus), LogUploadMgmHeaderRetry = VALUES(LogUploadMgmHeaderRetry), LogUploadMgmHeaderUploadDate = VALUES(LogUploadMgmHeaderUploadDate), LogUploadMgmHeaderLastUpdated = CURRENT_TIMESTAMP;
andy commented 2024-11-28 11:00:33 +07:00
Author
Owner
Copy Link

mgm detail

desc mgm_detail;
desc log_upload_mgm_detail;

INSERT INTO log_upload_mgm_detail (
LogUploadMgmDetailMgm_DetailID,
LogUploadMgmDetailStatus,
LogUploadMgmDetailRetry,
LogUploadMgmDetailUploadDate,
LogUploadMgmDetailCreated
)
SELECT
Mgm_DetailID AS LogUploadMgmDetailMgm_DetailID,
'Y' AS LogUploadMgmDetailStatus,
0 AS LogUploadMgmDetailRetry,
CURRENT_TIMESTAMP() AS LogUploadMgmDetailUploadDate,
CURRENT_TIMESTAMP() AS LogUploadMgmDetailCreated
FROM mgm_detail
LEFT JOIN log_upload_mgm_detail
ON Mgm_DetailID = LogUploadMgmDetailMgm_DetailID
WHERE Mgm_DetailIsActive = 'N'
AND LogUploadMgmDetailID is null
LIMIT 30000
ON DUPLICATE KEY UPDATE
LogUploadMgmDetailStatus = VALUES(LogUploadMgmDetailStatus),
LogUploadMgmDetailRetry = VALUES(LogUploadMgmDetailRetry),
LogUploadMgmDetailUploadDate = VALUES(LogUploadMgmDetailUploadDate),
LogUploadMgmDetailLastUpdated = CURRENT_TIMESTAMP;

## mgm detail desc mgm_detail; desc log_upload_mgm_detail; INSERT INTO log_upload_mgm_detail ( LogUploadMgmDetailMgm_DetailID, LogUploadMgmDetailStatus, LogUploadMgmDetailRetry, LogUploadMgmDetailUploadDate, LogUploadMgmDetailCreated ) SELECT Mgm_DetailID AS LogUploadMgmDetailMgm_DetailID, 'Y' AS LogUploadMgmDetailStatus, 0 AS LogUploadMgmDetailRetry, CURRENT_TIMESTAMP() AS LogUploadMgmDetailUploadDate, CURRENT_TIMESTAMP() AS LogUploadMgmDetailCreated FROM mgm_detail LEFT JOIN log_upload_mgm_detail ON Mgm_DetailID = LogUploadMgmDetailMgm_DetailID WHERE Mgm_DetailIsActive = 'N' AND LogUploadMgmDetailID is null LIMIT 30000 ON DUPLICATE KEY UPDATE LogUploadMgmDetailStatus = VALUES(LogUploadMgmDetailStatus), LogUploadMgmDetailRetry = VALUES(LogUploadMgmDetailRetry), LogUploadMgmDetailUploadDate = VALUES(LogUploadMgmDetailUploadDate), LogUploadMgmDetailLastUpdated = CURRENT_TIMESTAMP;
andy commented 2024-11-28 13:32:02 +07:00
Author
Owner
Copy Link

RIWAYAT

INSERT INTO log_upload_mgm_riwayat (
LogUploadMgmRiwayatMgm_RiwayatID,
LogUploadMgmRiwayatStatus,
LogUploadMgmRiwayatRetry,
LogUploadMgmRiwayatUploadDate,
LogUploadMgmRiwayatCreated
)
SELECT
Mgm_RiwayatID AS LogUploadMgmRiwayatMgm_RiwayatID,
'Y' AS LogUploadMgmRiwayatStatus,
0 AS LogUploadMgmRiwayatRetry,
CURRENT_TIMESTAMP() AS LogUploadMgmRiwayatUploadDate,
CURRENT_TIMESTAMP() AS LogUploadMgmRiwayatCreated
FROM mgm_riwayat
WHERE Mgm_RiwayatIsActive = 'N'
AND Mgm_RiwayatID NOT IN (
SELECT LogUploadMgmRiwayatMgm_RiwayatID
FROM log_upload_mgm_riwayat
)
ON DUPLICATE KEY UPDATE
LogUploadMgmRiwayatStatus = VALUES(LogUploadMgmRiwayatStatus),
LogUploadMgmRiwayatRetry = VALUES(LogUploadMgmRiwayatRetry),
LogUploadMgmRiwayatUploadDate = VALUES(LogUploadMgmRiwayatUploadDate),
LogUploadMgmRiwayatLastUpdated = CURRENT_TIMESTAMP;

## RIWAYAT INSERT INTO log_upload_mgm_riwayat ( LogUploadMgmRiwayatMgm_RiwayatID, LogUploadMgmRiwayatStatus, LogUploadMgmRiwayatRetry, LogUploadMgmRiwayatUploadDate, LogUploadMgmRiwayatCreated ) SELECT Mgm_RiwayatID AS LogUploadMgmRiwayatMgm_RiwayatID, 'Y' AS LogUploadMgmRiwayatStatus, 0 AS LogUploadMgmRiwayatRetry, CURRENT_TIMESTAMP() AS LogUploadMgmRiwayatUploadDate, CURRENT_TIMESTAMP() AS LogUploadMgmRiwayatCreated FROM mgm_riwayat WHERE Mgm_RiwayatIsActive = 'N' AND Mgm_RiwayatID NOT IN ( SELECT LogUploadMgmRiwayatMgm_RiwayatID FROM log_upload_mgm_riwayat ) ON DUPLICATE KEY UPDATE LogUploadMgmRiwayatStatus = VALUES(LogUploadMgmRiwayatStatus), LogUploadMgmRiwayatRetry = VALUES(LogUploadMgmRiwayatRetry), LogUploadMgmRiwayatUploadDate = VALUES(LogUploadMgmRiwayatUploadDate), LogUploadMgmRiwayatLastUpdated = CURRENT_TIMESTAMP;
andy commented 2024-11-28 14:34:58 +07:00
Author
Owner
Copy Link

CEK mgm detail

desc mgm_detail;
desc log_upload_mgm_detail;

SELECT COUNT(Mgm_DetailMgm_HeaderID)
FROM one_etl.mgm_detail
LEFT JOIN one_etl.log_upload_mgm_detail
ON Mgm_DetailID = LogUploadMgmDetailMgm_DetailID

                    WHERE  (LogUploadMgmDetailStatus IS NULL  -- Belum ada log
                        OR LogUploadMgmDetailStatus IN ('N', 'R', 'E')  -- Status N, R, E
                        OR (LogUploadMgmDetailStatus = 'Y' AND Mgm_DetailLastUpdated > LogUploadMgmDetailUploadDate)) 
                    AND Mgm_DetailMgm_HeaderID IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID  = 17);

SELECT COUNT(Mgm_DetailMgm_HeaderID)
FROM one_etl.mgm_detail
LEFT JOIN one_etl.log_upload_mgm_detail
ON Mgm_DetailID = LogUploadMgmDetailMgm_DetailID
WHERE
(LogUploadMgmDetailStatus = 'Y' AND Mgm_DetailLastUpdated > LogUploadMgmDetailUploadDate)
AND Mgm_DetailMgm_HeaderID
IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17);

SELECT COUNT(Mgm_DetailMgm_HeaderID)
FROM one_etl.mgm_detail
LEFT JOIN one_etl.log_upload_mgm_detail
ON Mgm_DetailID = LogUploadMgmDetailMgm_DetailID
WHERE
LogUploadMgmDetailStatus IN ('N', 'R', 'E')
AND Mgm_DetailMgm_HeaderID
IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17);

SELECT COUNT(Mgm_DetailMgm_HeaderID)
FROM one_etl.mgm_detail
LEFT JOIN one_etl.log_upload_mgm_detail
ON Mgm_DetailID = LogUploadMgmDetailMgm_DetailID
WHERE
LogUploadMgmDetailStatus IS NULL
AND Mgm_DetailMgm_HeaderID
IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17);

## CEK mgm detail desc mgm_detail; desc log_upload_mgm_detail; SELECT COUNT(Mgm_DetailMgm_HeaderID) FROM one_etl.mgm_detail LEFT JOIN one_etl.log_upload_mgm_detail ON Mgm_DetailID = LogUploadMgmDetailMgm_DetailID WHERE (LogUploadMgmDetailStatus IS NULL -- Belum ada log OR LogUploadMgmDetailStatus IN ('N', 'R', 'E') -- Status N, R, E OR (LogUploadMgmDetailStatus = 'Y' AND Mgm_DetailLastUpdated > LogUploadMgmDetailUploadDate)) AND Mgm_DetailMgm_HeaderID IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17); SELECT COUNT(Mgm_DetailMgm_HeaderID) FROM one_etl.mgm_detail LEFT JOIN one_etl.log_upload_mgm_detail ON Mgm_DetailID = LogUploadMgmDetailMgm_DetailID WHERE (LogUploadMgmDetailStatus = 'Y' AND Mgm_DetailLastUpdated > LogUploadMgmDetailUploadDate) AND Mgm_DetailMgm_HeaderID IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17); SELECT COUNT(Mgm_DetailMgm_HeaderID) FROM one_etl.mgm_detail LEFT JOIN one_etl.log_upload_mgm_detail ON Mgm_DetailID = LogUploadMgmDetailMgm_DetailID WHERE LogUploadMgmDetailStatus IN ('N', 'R', 'E') AND Mgm_DetailMgm_HeaderID IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17); SELECT COUNT(Mgm_DetailMgm_HeaderID) FROM one_etl.mgm_detail LEFT JOIN one_etl.log_upload_mgm_detail ON Mgm_DetailID = LogUploadMgmDetailMgm_DetailID WHERE LogUploadMgmDetailStatus IS NULL AND Mgm_DetailMgm_HeaderID IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17);
andy commented 2024-11-28 14:35:24 +07:00
Author
Owner
Copy Link

cek mgm riwayat

desc mgm_header;
desc log_upload_mgm_riwayat ;

/UPDATE log_upload_mgm_riwayat SET LogUploadMgmRiwayatUploadDate = NOW()
WHERE LogUploadMgmRiwayatMgm_RiwayatID IN
(
SELECT Mgm_RiwayatID
FROM one_etl.mgm_riwayat
LEFT JOIN one_etl.log_upload_mgm_riwayat
ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID
WHERE
(LogUploadMgmRiwayatStatus = 'Y' AND Mgm_RiwayatLastUpdated > LogUploadMgmRiwayatUploadDate)
AND Mgm_RiwayatMgm_HeaderID
IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17)
);/

SELECT COUNT(Mgm_RiwayatMgm_HeaderID)
FROM one_etl.mgm_riwayat
LEFT JOIN one_etl.log_upload_mgm_riwayat
ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID

                    WHERE  (LogUploadMgmRiwayatStatus IS NULL  -- Belum ada log
                        OR LogUploadMgmRiwayatStatus IN ('N', 'R', 'E')  -- Status N, R, E
                        OR (LogUploadMgmRiwayatStatus = 'Y' AND Mgm_RiwayatLastUpdated > LogUploadMgmRiwayatUploadDate)) 
                    AND Mgm_RiwayatMgm_HeaderID IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID  = 17);

SELECT COUNT(Mgm_RiwayatMgm_HeaderID)
FROM one_etl.mgm_riwayat
LEFT JOIN one_etl.log_upload_mgm_riwayat
ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID
WHERE
(LogUploadMgmRiwayatStatus = 'Y' AND Mgm_RiwayatLastUpdated > LogUploadMgmRiwayatUploadDate)
AND Mgm_RiwayatMgm_HeaderID
IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17);

SELECT COUNT(Mgm_RiwayatMgm_HeaderID)
FROM one_etl.mgm_riwayat
LEFT JOIN one_etl.log_upload_mgm_riwayat
ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID
WHERE
LogUploadMgmRiwayatStatus IN ('N', 'R', 'E')
AND Mgm_RiwayatMgm_HeaderID
IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17);

SELECT COUNT(Mgm_RiwayatMgm_HeaderID)
FROM one_etl.mgm_riwayat
LEFT JOIN one_etl.log_upload_mgm_riwayat
ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID
WHERE
LogUploadMgmRiwayatStatus IS NULL
AND Mgm_RiwayatMgm_HeaderID
IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17);

## cek mgm riwayat desc mgm_header; desc log_upload_mgm_riwayat ; /*UPDATE log_upload_mgm_riwayat SET LogUploadMgmRiwayatUploadDate = NOW() WHERE LogUploadMgmRiwayatMgm_RiwayatID IN ( SELECT Mgm_RiwayatID FROM one_etl.mgm_riwayat LEFT JOIN one_etl.log_upload_mgm_riwayat ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID WHERE (LogUploadMgmRiwayatStatus = 'Y' AND Mgm_RiwayatLastUpdated > LogUploadMgmRiwayatUploadDate) AND Mgm_RiwayatMgm_HeaderID IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17) );*/ SELECT COUNT(Mgm_RiwayatMgm_HeaderID) FROM one_etl.mgm_riwayat LEFT JOIN one_etl.log_upload_mgm_riwayat ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID WHERE (LogUploadMgmRiwayatStatus IS NULL -- Belum ada log OR LogUploadMgmRiwayatStatus IN ('N', 'R', 'E') -- Status N, R, E OR (LogUploadMgmRiwayatStatus = 'Y' AND Mgm_RiwayatLastUpdated > LogUploadMgmRiwayatUploadDate)) AND Mgm_RiwayatMgm_HeaderID IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17); SELECT COUNT(Mgm_RiwayatMgm_HeaderID) FROM one_etl.mgm_riwayat LEFT JOIN one_etl.log_upload_mgm_riwayat ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID WHERE (LogUploadMgmRiwayatStatus = 'Y' AND Mgm_RiwayatLastUpdated > LogUploadMgmRiwayatUploadDate) AND Mgm_RiwayatMgm_HeaderID IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17); SELECT COUNT(Mgm_RiwayatMgm_HeaderID) FROM one_etl.mgm_riwayat LEFT JOIN one_etl.log_upload_mgm_riwayat ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID WHERE LogUploadMgmRiwayatStatus IN ('N', 'R', 'E') AND Mgm_RiwayatMgm_HeaderID IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17); SELECT COUNT(Mgm_RiwayatMgm_HeaderID) FROM one_etl.mgm_riwayat LEFT JOIN one_etl.log_upload_mgm_riwayat ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID WHERE LogUploadMgmRiwayatStatus IS NULL AND Mgm_RiwayatMgm_HeaderID IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17);
andy commented 2024-11-28 14:35:40 +07:00
Author
Owner
Copy Link

cek mgm header

desc mgm_header;
desc log_upload_mgm_riwayat ;

/UPDATE log_upload_mgm_riwayat SET LogUploadMgmRiwayatUploadDate = NOW()
WHERE LogUploadMgmRiwayatMgm_RiwayatID IN
(
SELECT Mgm_RiwayatID
FROM one_etl.mgm_riwayat
LEFT JOIN one_etl.log_upload_mgm_riwayat
ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID
WHERE
(LogUploadMgmRiwayatStatus = 'Y' AND Mgm_RiwayatLastUpdated > LogUploadMgmRiwayatUploadDate)
AND Mgm_RiwayatMgm_HeaderID
IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17)
);/

SELECT COUNT(Mgm_RiwayatMgm_HeaderID)
FROM one_etl.mgm_riwayat
LEFT JOIN one_etl.log_upload_mgm_riwayat
ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID

                    WHERE  (LogUploadMgmRiwayatStatus IS NULL  -- Belum ada log
                        OR LogUploadMgmRiwayatStatus IN ('N', 'R', 'E')  -- Status N, R, E
                        OR (LogUploadMgmRiwayatStatus = 'Y' AND Mgm_RiwayatLastUpdated > LogUploadMgmRiwayatUploadDate)) 
                    AND Mgm_RiwayatMgm_HeaderID IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID  = 17);

SELECT COUNT(Mgm_RiwayatMgm_HeaderID)
FROM one_etl.mgm_riwayat
LEFT JOIN one_etl.log_upload_mgm_riwayat
ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID
WHERE
(LogUploadMgmRiwayatStatus = 'Y' AND Mgm_RiwayatLastUpdated > LogUploadMgmRiwayatUploadDate)
AND Mgm_RiwayatMgm_HeaderID
IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17);

SELECT COUNT(Mgm_RiwayatMgm_HeaderID)
FROM one_etl.mgm_riwayat
LEFT JOIN one_etl.log_upload_mgm_riwayat
ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID
WHERE
LogUploadMgmRiwayatStatus IN ('N', 'R', 'E')
AND Mgm_RiwayatMgm_HeaderID
IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17);

SELECT COUNT(Mgm_RiwayatMgm_HeaderID)
FROM one_etl.mgm_riwayat
LEFT JOIN one_etl.log_upload_mgm_riwayat
ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID
WHERE
LogUploadMgmRiwayatStatus IS NULL
AND Mgm_RiwayatMgm_HeaderID
IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17);

## cek mgm header desc mgm_header; desc log_upload_mgm_riwayat ; /*UPDATE log_upload_mgm_riwayat SET LogUploadMgmRiwayatUploadDate = NOW() WHERE LogUploadMgmRiwayatMgm_RiwayatID IN ( SELECT Mgm_RiwayatID FROM one_etl.mgm_riwayat LEFT JOIN one_etl.log_upload_mgm_riwayat ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID WHERE (LogUploadMgmRiwayatStatus = 'Y' AND Mgm_RiwayatLastUpdated > LogUploadMgmRiwayatUploadDate) AND Mgm_RiwayatMgm_HeaderID IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17) );*/ SELECT COUNT(Mgm_RiwayatMgm_HeaderID) FROM one_etl.mgm_riwayat LEFT JOIN one_etl.log_upload_mgm_riwayat ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID WHERE (LogUploadMgmRiwayatStatus IS NULL -- Belum ada log OR LogUploadMgmRiwayatStatus IN ('N', 'R', 'E') -- Status N, R, E OR (LogUploadMgmRiwayatStatus = 'Y' AND Mgm_RiwayatLastUpdated > LogUploadMgmRiwayatUploadDate)) AND Mgm_RiwayatMgm_HeaderID IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17); SELECT COUNT(Mgm_RiwayatMgm_HeaderID) FROM one_etl.mgm_riwayat LEFT JOIN one_etl.log_upload_mgm_riwayat ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID WHERE (LogUploadMgmRiwayatStatus = 'Y' AND Mgm_RiwayatLastUpdated > LogUploadMgmRiwayatUploadDate) AND Mgm_RiwayatMgm_HeaderID IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17); SELECT COUNT(Mgm_RiwayatMgm_HeaderID) FROM one_etl.mgm_riwayat LEFT JOIN one_etl.log_upload_mgm_riwayat ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID WHERE LogUploadMgmRiwayatStatus IN ('N', 'R', 'E') AND Mgm_RiwayatMgm_HeaderID IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17); SELECT COUNT(Mgm_RiwayatMgm_HeaderID) FROM one_etl.mgm_riwayat LEFT JOIN one_etl.log_upload_mgm_riwayat ON Mgm_RiwayatID = LogUploadMgmRiwayatMgm_RiwayatID WHERE LogUploadMgmRiwayatStatus IS NULL AND Mgm_RiwayatMgm_HeaderID IN (SELECT Mgm_HeaderID FROM one_etl.mgm_header WHERE Mgm_HeaderMgm_McuID = 17);
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
No items
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
hanan sas.padmanto stephenk andy
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: andy/ts-etl-mcu-upload-national#1
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?