Production Ticket(ST) #12237
OROMEO - this user only show 3 outlets of 7-11
1) Check the customer to user relation.
2) Check the file that they provide.
3) Found that the person in charge not inserted into database.
4) Insert all the person in charge.
Root cause: Person in charge not inserted into database.
None
Description
[14:30, 15/07/2024] +60 12-323 6144: for user 120013
[14:30, 15/07/2024] +60 12-323 6144: this user only show 3 outlets of 7-11
[14:30, 15/07/2024] +60 12-323 6144: there have different compare to the file we provided
History
#1 Updated by Rashdan Hussin 2 months ago
- File 74e2f1e1-00ee-4983-b763-6b3bd2271c80.jpg 74e2f1e1-00ee-4983-b763-6b3bd2271c80.jpg added
- Subject changed from Oromeo- there have different compare to the file we provided to OROMEO - this user only show 3 outlets of 7-11
- Description updated (diff)
- Type set to Support Request
- SLA Delivery set to 16/07/2024
#2 Updated by Rashdan Hussin 2 months ago
- Status changed from Assigned To to Support In Progress
#3 Updated by Rashdan Hussin 2 months ago
- Status changed from Support In Progress to Pending Client Verification
- % Done changed from 0 to 90
- Actual Initial Response set to 15/07/2024
- Resolution updated (diff)
select * from #TempTable
select * from #TempTable where customer_code not in (select customer_code from customer where org_id = 'oromeo')
select * from #TempTable where user_code not in (select member_cd from member where org_id = 'oromeo')
select * from #TempTable a
inner join customer b on b.customer_code = a.customer_code and b.org_id = 'oromeo'
inner join member c on c.member_cd = a.user_code and c.org_id = 'oromeo'
where not exists(select 1 from customer_to_user_relation r where r.org_id = 'oromeo' and b.customer_id = r.customer_id and c.member_id = r.user_id)
--select * into DMS_Ecosystem_Backup_Table.dbo._customer_to_user_relation_20240715
--from DMS_EcoSystem.dbo.customer_to_user_relation
--insert into customer_to_user_relation
--(customer_to_user_relation_id, customer_id, user_id, created_date, created_by, updated_date, updated_by, org_id, tenant_id, start_date, end_date)
--select newid(), b.customer_id, c.member_id, getdate(), 'Support', getdate(), 'Support', 'OROMEO', 'OROMEO', '2024-01-01 00:00:00.000', '2099-12-31 00:00:00.000'
--from #TempTable a
--inner join customer b on b.customer_code = a.customer_code and b.org_id = 'oromeo'
--inner join member c on c.member_cd = a.user_code and c.org_id = 'oromeo'
--where not exists(select 1 from customer_to_user_relation r where r.org_id = 'oromeo' and b.customer_id = r.customer_id and c.member_id = r.user_id)
select b.customer_code, a.customer_id, user_id, start_date, end_date, count(1) from customer_to_user_relation a
inner join customer b on b.customer_id = a.customer_id
where a.org_id = 'oromeo'
group by b.customer_code, a.customer_id, user_id, start_date, end_date
having count(1)>1
order by b.customer_code
#4 Updated by Rashdan Hussin 2 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100