Details
-
Type:
Bug
-
Status:
Closed
(View Workflow)
-
Priority:
Normal
-
Resolution: Fixed
-
Component/s: None
-
Customer:OMAN-Tel
Description
Please to exclude CUSTOM_TAS task from latest tasks activity report and keep it only for SLA calculation as agreed before,
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Gantt Options | Milestone (set to milestone: having a due date but zero effort) | |
| Planned Start | 2025-02-21 24:00 (milestone: set planned start date to due date) | |
| Planned End | 2025-02-21 24:00 (milestone: set planned end date to due date) |
| Labels | SRD |
| Assignee | Khaled Khalil [ kkhalil ] | Sara Saddik [ ssaddik ] |
| Summary | Exclude CUSTOM_TAS task from tasks latest activity report | Exclude CUSTOM_TAS task from tasks report |
| Status | Open Bug [ 10108 ] | Dev Scheduled [ 10014 ] |
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 4 hours [ 14400 ] | |
| Worklog Id | 261821 [ 261821 ] |
| Baseline Start | 2025-02-21 24:00 (set baseline based of initial work logging) | |
| Baseline End | 2025-02-21 24:00 (set baseline based of initial work logging) |
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| Status | To Be Released [ 10400 ] | Ready for QA [ 10023 ] |
| Assignee | Sara Saddik [ ssaddik ] | Salem Dannawi [ sdannawi ] |
| Status | Ready for QA [ 10023 ] | QA In Progress [ 10015 ] |
| Assignee | Salem Dannawi [ sdannawi ] | Abir Messaikeh [ amessaikeh ] |
| Status | QA In Progress [ 10015 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] |
| Transition | Time In Source Status | Execution Times | Last Executer | Last Execution Date | |||||
|---|---|---|---|---|---|---|---|---|---|
|
14d 2h 42m | 1 | Sara Saddik | 06/Mar/25 10:27 AM | |||||
|
3s | 1 | Sara Saddik | 06/Mar/25 10:27 AM | |||||
|
1h 48m | 1 | Sara Saddik | 06/Mar/25 12:15 PM | |||||
|
33m 15s | 1 | Khaled Khalil | 06/Mar/25 12:49 PM | |||||
|
77d 17h 13m | 1 | Abir Messaikeh | 23/May/25 7:02 AM | |||||
|
8s | 1 | Abir Messaikeh | 23/May/25 7:02 AM |
|
Links Hierarchy |
 Documentation
|
Dear Salem,
Issue will be fixed after applying the below query.
@integration
Kindly apply the following script on schema.
Query:
CREATE OR REPLACE FORCE EDITIONABLE VIEW "SRD_TASK_REPORT_VIEW" ("ID", "REQUEST_ID", "TASK_NAME", "TASK_STATUS", "ASSIGNEE", "TEAM", "ASSIGN_DATE", "COMPLETION_DATE", "INSERTDATE", "INSERTEDBY", "ASSIGNED_BY", "PROJECT_TYPE", "PROJECT_BRIEF", "STATUS", "REQUEST_TYPE") AS
select task.id, task.request_id ,task.task_name ,task.task_status , task.assignee, group_map.display_name, task.assign_date, task.completion_date,task.insertdate,task.insertedby,task.assigned_by,
request.project_type,request.project_brief,request.status,request.request_type
from srd_task task
INNER JOIN srd_service_request request on task.request_id = request.request_id
LEFT JOIN team_group_mapping group_map on task.team = group_map.name
where task.visible = 1;
commit;
Regards,
Sara