Production Ticket(ST) #11909
SNEKKU - call report which customer not yet get photo and location
1) Query the customer that have no photo and location.
2) Export to excel file.
Root cause: Customer that have no photo and location.
None
Description
Hi @Rashdan Hussin Help to call report which customer not yet get photo and location, thanks
History
#1 Updated by Rashdan Hussin 4 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Rashdan Hussin 4 months ago
- File SNEKKU Customer Have No Location.xlsx SNEKKU Customer Have No Location.xlsx added
- File SNEKKU Customer Have No Photo.xlsx SNEKKU Customer Have No Photo.xlsx added
- Status changed from Support In Progress to Pending Client Verification
- % Done changed from 0 to 90
- Actual Initial Response set to 03/06/2024
- Resolution updated (diff)
Select customer_code, customer_name, 'Did not have photo' as Photo_status
from customer where org_id ='snekku' and customer_id not in (SELECT customer_id FROM customer_attachment WHERE org_id = 'snekku'
UNION
SELECT new_customer_id FROM Txn_new_customer_attachment WHERE org_id ='snekku')
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'
--this is to get customer that don't gave location
#3 Updated by Rashdan Hussin 4 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100