Production Ticket(ST) #12016
Goldcrest- Hi pls check, this is MCJ route planning but WWX showing in MCJ route plan
1) already checked in the webportal
2) run the SQL profiler
3) escalate to technical team to further check on this
4) root cause- bug
None
Description
MCJ user is 28
History
#1 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Project changed from Datanory to Datanory - GOLDCREST
#2 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Assigned To to Support In Progress
#3 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Support In Progress to Escalated to Level 3
- Resolution updated (diff)
This issue similar with
#4 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
https://datanory.com.my/DMS_EcoSystem/MstRouteSummary/MstRouteSummary?MemberId=2c9e40b5f5904775b71192b8fd8b71ad&Mode=View
-- Web portal (17/06/2024)
exec sp_executesql N' select route_summary_id, c.customer_id as CustomerID, c.customer_code as CustomerCode ,c.customer_name as CustomerName, a.area_code as AreaCd from mst_route r inner join customer c on c.customer_id = r.customer_id inner join customer_to_user_relation cr on cr.customer_id = c.customer_id and cr.user_id = @member_id inner join mst_area a on c.area_id=a.area_id where r.member_id = @member_id and convert(varchar(10), r.date, 103) = @date group by route_summary_id, c.customer_id, c.customer_code ,c.customer_name, sequence, a.area_code order by cast(isnull(sequence,999999) as int) asc ',N'@member_id nvarchar(32),@date nvarchar(10)',
@member_id=N'2c9e40b5f5904775b71192b8fd8b71ad',
@date=N'17/06/2024'
this is the sql profiler
#5 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
ClickUp Status: in trail
#6 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Escalated to Level 3 to Pending Client Verification
- Resolution updated (diff)
As I check with technical team this is due to technical issue
#7 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Actual Initial Response set to 13/06/2024
#8 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Type set to Support Request
#9 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Pending Client Verification to Ticket Resolved