Production Ticket(ST) #11617
hi, may i know how we can trace back the status of missing collection number?
0%
total missing collection
select CAST(RIGHT(Max(x.col_no), 6) AS INT) - Max(row_num) as total_missing, Max(col_no) as col_no, Max(row_num) as row_num from (SELECT SUBSTRING(col_no, 1, LEN(col_no) - 7) AS col_no,
ROW_NUMBER() OVER (PARTITION BY created_by ORDER BY col_no) AS row_num, created_by
FROM txn_mobile_collection_header
WHERE org_id = 'snekku' and created_by <>'INTEGRATION_API') x group by x.created_by having CAST(RIGHT(Max(x.col_no), 6) AS INT) - Max(row_num) >0
By row number & running number comparison
select * from (SELECT SUBSTRING(col_no, 1, LEN(col_no) - 7) AS col_no,
ROW_NUMBER() OVER (PARTITION BY created_by ORDER BY col_no) AS row_num, created_by
FROM txn_mobile_collection_header
WHERE org_id = 'snekku' and created_by <>'INTEGRATION_API') x
None
Description
hi, may i know how we can trace back the status of missing collection number?
for example, MS2, in the collection list, missing of number 3,5,7,9,11 & 13.
@Arif Ibrahim possible to help us generate data for those missing collection number's status first? as need to do closing account.
History
#1 Updated by Muhammad Arif 5 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Muhammad Arif 5 months ago
- Status changed from Support In Progress to Pending Client Verification
- Resolution updated (diff)
total missing collection
select CAST, 6) AS INT) - Max(row_num) as total_missing, Max(col_no) as col_no, Max(row_num) as row_num from (SELECT SUBSTRING - 7) AS col_no,
ROW_NUMBER() OVER (PARTITION BY created_by ORDER BY col_no) AS row_num, created_by
FROM txn_mobile_collection_header
WHERE org_id = 'snekku' and created_by <>'INTEGRATION_API') x group by x.created_by having CAST, 6) AS INT) - Max(row_num) >0
By row number & running number comparison
select * from (SELECT SUBSTRING - 7) AS col_no,
ROW_NUMBER() OVER (PARTITION BY created_by ORDER BY col_no) AS row_num, created_by
FROM txn_mobile_collection_header
WHERE org_id = 'snekku' and created_by <>'INTEGRATION_API') x
#3 Updated by Muhammad Arif 4 months ago
- Status changed from Pending Client Verification to Ticket Resolved