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
- All
- Comments
- Work Log
- History
- Activity
- Links Hierarchy
- Transitions
- Trace
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