Datanory Production » Datanory - SNEKKU

- Simulation has to be done in trail environment

--> upload photo ( without onbehalf)
-- perform onbehalf and upload photo in which table is inserting
-- check in which table the photo saves in the DB
-- save the image via portal

SELECT
FROM Txn_new_customer_attachment
WHERE filename NOT IN (SELECT filename FROM customer_attachment where org_id ='SNEKKU') AND ORG_ID= 'SNEKKU' order by created_date;
and customer_id ='3281EB96FC5A4F6287A88B9A72F8E452'
select * from customer where customer_id ='3281EB96FC5A4F6287A88B9A72F8E452'
SELECT c.
FROM customer_attachment c
LEFT JOIN Txn_new_customer_attachment nca ON c.filename = nca.filename
WHERE nca.filename IS NULL AND c.ORG_ID= 'snekku';

Have to move the photo that is stucked in the txn_newcustomer attachment--> customer_attachment

--select * into DMS_EcoSystem_backup_table.dbo.Txn_new_customer_attachment_23042024
--from DMS_EcoSystem.dbo.Txn_new_customer_attachment
--select * into DMS_EcoSystem_backup_table.dbo.customer_attachment_23042024
--from DMS_EcoSystem.dbo.customer_attachment

SELECT filename, new_customer_attachment_id, new_customer_id, ...
FROM Txn_new_customer_attachment
WHERE org_id = 'snekku';

select * from customer_attachment where org_id= 'snekku' and filename in (select filename FROM Txn_new_customer_attachment)

--insert
--insert into customer_attachment
--SELECT * FROM Txn_new_customer_attachment WHERE org_id = 'snekku'