Project

General

Profile

Production Ticket(ST) #11790

OROMEO - assign all customers (15787) to user ID: 110001 (Admin)

Added by Rashdan Hussin 4 months ago. Updated 4 months ago.

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Rashdan Hussin
Start date:
23/05/2024
Due date:
29/05/2024
% Done:

100%

Estimated time:
Spent time:
1.00 h
Job Remark:
Ticket Logged Date:
23/05/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
23/05/2024
SLA Delivery:
29/05/2024
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
23/05/2024
Resolution:

1) Create query to add customer to user relation for 110001.

Root cause: Add customer to user relation for 110001.

Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:

None

Description

Dear @Rashdan Hussin,

Kindly assist to assign all customers (15787) to user ID: 110001 (Admin). Ms Carmen will be able to access all the customer details from mobile devices.

Thanks.

Warm Regards,

Muhamad Kamal Arif Bin Muhamad

Hi @Rashdan Hussin,

As confirmed with Ms Carmen, please assigned all Oromeo Customer to user id: 110001 through On Behalf.

Thanks.

Warm Regards,

Muhamad Kamal Arif Bin Muhamad

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

  • Due date changed from 27/05/2024 to 29/05/2024
  • Status changed from Support In Progress to Pending Client Verification
  • % Done changed from 0 to 90
  • SLA Delivery changed from 27/05/2024 to 29/05/2024
  • Actual Initial Response set to 23/05/2024
  • Resolution updated (diff)

select * from member where member_cd = '110001'

select * from customer where org_id = 'OROMEO'
select * from customer_to_user_relation where user_id = 'OROMEO-admin'

--select * into DMS_Ecosystem_Backup_Table.dbo._customer_to_user_relation_20240529
--from DMS_EcoSystem.dbo.customer_to_user_relation

select * from customer a
left join customer_to_user_relation b on a.customer_id = b.customer_id and b.user_id = 'OROMEO-admin'
WHERE b.customer_id is NULL and a.org_id = 'oromeo'

--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(), a.customer_id, 'OROMEO-admin', getdate(), 'Support', getdate(), 'Support', 'OROMEO', 'OROMEO', '2023-01-01 00:00:00.000', '2099-12-31 00:00:00.000'
--from customer a
--LEFT JOIN customer_to_user_relation b ON a.customer_id = b.customer_id AND b.user_id = 'OROMEO-admin'
--WHERE b.customer_id IS NULL and a.org_id = 'oromeo'

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

#3 Updated by Rashdan Hussin 4 months ago

  • Status changed from Pending Client Verification to Ticket Resolved
  • % Done changed from 90 to 100

Also available in: Atom PDF