Production Ticket(ST) #11464
SNEKKU - help to call report for which customer not yet upload photo
Job Remark:
Ticket Logged Date:
16/04/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
16/04/2024
SLA Delivery:
23/04/2024
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
21/04/2024
Resolution:
user ask list to customer to provide list that they did not upload photo in customer module
already done
Root cause- no root cause
Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:
None
Description
hi @Azhar MCC, can help to call report for which customer not yet upload photo?
History
#1 Updated by Rashdan Hussin 5 months ago
- Assignee changed from Rashdan Hussin to Muhammed Azhar Mohamed Maideen
#2 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
- Status changed from Assigned To to Support In Progress
#3 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
- File Snekku_ customer_list.xlsx Snekku_ customer_list.xlsx added
- Status changed from Support In Progress to Pending Client Verification
- Resolution updated (diff)
SELECT customer_code, customer_name,'Customer that did not upload photos' as Remark
FROM customer
WHERE org_id = 'snekku'
AND customer_id NOT IN (SELECT customer_id FROM customer_attachment);
#4 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- Actual Initial Response set to 21/04/2024