Project

General

Profile

Production Ticket(ST) #12114

YAKULT - create the Access Control Mobile based on the User Group

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

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Rashdan Hussin
Start date:
28/06/2024
Due date:
02/07/2024
% Done:

100%

Estimated time:
Spent time:
2.00 h
Job Remark:
Ticket Logged Date:
28/06/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
28/06/2024
SLA Delivery:
02/07/2024
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
28/07/2024
Resolution:

1) Review and verify all the data from the excel file given.
2) Create mobile access based on user group.

Root cause: Mobile Access Control setup for Yakult users based on their User Group

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

None

Description

Dear Rashdan,

Based on the Yakult User List previously attached, please create the Access Control Mobile based on the User Group column in the User Master.

Thanks.

Warm Regards,

Muhamad Kamal Arif Bin Muhamad

History

#1 Updated by Rashdan Hussin 3 months ago

  • Status changed from Assigned To to Support In Progress

select * from member where org_id = 'A000002'

select * from user_group where org_id = 'A000002'

select * from user_group where org_id = 'A000002' and ug_cd not in
(select access_control_cd from mobile_access_control where org_id = 'A000002')

select * from mobile_access_control where org_id = 'A000002' order by updated_date desc

select * from mobile_access_control where org_id = 'A000002' and access_control_cd not in
(select ug_cd from user_group where org_id = 'A000002')

--insert into mobile_access_control (access_control_id, access_control_cd, access_control_name, access_control_desc, status, created_date, created_by, updated_date, updated_by, org_id, tenant_id)
--select newid(), ug_cd, ug_cd, ug_cd, 'Active', getdate(), 'Support', getdate(), 'Support', org_id, tenant_id
--from user_group
--where org_id = 'A000002' and ug_cd not in
--(select access_control_cd from mobile_access_control where org_id = 'A000002')

select c.access_control_cd, b.ug_cd, a.mobile_access_control_id, c.access_control_id, * from member a
inner join user_group b on b.ug_id = a.ug_id and b.org_id = 'A000002'
inner join mobile_access_control c on c.access_control_cd = b.ug_cd and c.org_id = 'A000002'
where a.org_id = 'A000002'

--select * into _member_20240701 from member

--update a set a.mobile_access_control_id = c.access_control_id, a.updated_date = getdate(), a.updated_by = 'Support'
--from member a
--inner join user_group b on b.ug_id = a.ug_id and b.org_id = 'A000002'
--inner join mobile_access_control c on c.access_control_cd = b.ug_cd and c.org_id = 'A000002'
--where a.org_id = 'A000002'

--delete from mobile_access_control where org_id = 'A000002' and access_control_id not in
--(select mobile_access_control_id from member where org_id = 'A000002')

#2 Updated by Rashdan Hussin 3 months ago

  • Status changed from Support In Progress to Ticket Resolved
  • % Done changed from 0 to 100
  • Actual Initial Response set to 28/07/2024
  • Resolution updated (diff)

Also available in: Atom PDF