Production Ticket(ST) #12008
GOLDCREST - Hi Azhar pls check for me, why different
1) checked in the portal
2) checked in the sql profiler
3) escalate to technical team to check further on this
None
Description
History
#1 Updated by Rashdan Hussin 3 months ago
- Project changed from Datanory to Datanory - GOLDCREST
- Subject changed from Golldcrest- Hi Azhar pls check for me, why different to GOLDCREST - Hi Azhar pls check for me, why different
- Due date changed from 13/06/2024 to 14/06/2024
- Priority changed from P2 - High to P3 - Medium
- Type set to Support Request
- SLA Delivery set to 14/06/2024
#2 Updated by Rashdan Hussin 3 months ago
- Status changed from Assigned To to Support In Progress
- Assignee changed from Rashdan Hussin to Muhammed Azhar Mohamed Maideen
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'15/06/2024'
- Based on checking the route for MCJ on 15/6 suppose have 17 routes
#3 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Support In Progress to Escalated to Level 3
- Resolution updated (diff)
#4 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
ClickUp Status: In Progress
#5 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Escalated to Level 3 to Support In Progress
#6 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Support In Progress to Ticket Resolved
- Actual Initial Response set to 12/06/2024