Production Ticket(ST) #11508
SNEKKU - call report about which customer not yet get location
Job Remark:
Ticket Logged Date:
20/04/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
20/04/2024
SLA Delivery:
27/04/2024
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
20/04/2024
Resolution:
1) Do query in database to find the customer that have no location.
2) Export the result to excel file.
Root cause: Client request.
Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:
None
Description
hi @Azhar MCC please help to call report about which customer not yet get location, thanks
History
#1 Updated by Rashdan Hussin 5 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Rashdan Hussin 5 months ago
- File SNEKKU Customer Have No Location.xlsx SNEKKU Customer Have No Location.xlsx added
- Status changed from Support In Progress to Pending Client Verification
- % Done changed from 0 to 90
- Actual Initial Response set to 20/04/2024
- Resolution updated (diff)
#3 Updated by Rashdan Hussin 5 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100
--missing latitude / longitude
select b.customer_code,b.customer_name, a.latitude,a.longitude from mst_customer_contact_address (nolock) a
inner join customer (nolock) b on a.customer_id=b.customer_id
where a.org_id='snekku' and (a.latitude= '0' or a.latitude='') and a.address_type='contact'