[LS-237] Exclude CUSTOM_TAS task from tasks report Created: 20/Feb/25  Updated: 23/May/25  Due: 21/Feb/25  Resolved: 23/May/25

Status: Closed
Project: L3 Support
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Normal
Reporter: Salem Dannawi Assignee: Abir Messaikeh
Resolution: Fixed Votes: 0
Labels: SRD
Remaining Estimate: 0 minutes
Time Spent: 4 hours
Original Estimate: Not Specified

Attachments: PNG File custom_tas.png    
Customer:
OMAN-Tel
Planned Start:
Planned End:
Actual Start:
Date of Baselining:

 Description   

Please to exclude CUSTOM_TAS task from latest tasks activity report and keep it only for SLA calculation as agreed before,



 Comments   
Comment by Sara Saddik [ 06/Mar/25 ]

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

Comment by Anonymous [ 22/May/25 ]

fixed

Generated at Wed Apr 15 14:22:00 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.