I want to create a data base view

[taqdeer]

Hi All,

I want to see the below fields on a report.

RITM Table : 

RITM Number
Requested for
Assignment Group
Assigned to
State

Task SLA Table :

Has Breached 
Business elapsed percentage

I want to create a report for these fields coming from two different tables. I tried creating a database view for this one. Unfortunately I couldn't retrieve the data correctly. Attached is the screenshot for your reference. 

Could anyone please help with the Where clause so that I can get the correct data.

[Mohan raj]

Hi @taqdeer,

Try below where clause 

sla_task=ritm_sys_id

able fetch all fields from sc_req_item table and task_sla table, Screen shot was attached for you reference.

If my response helps you to resolve the issue close the question by Accepting solution and hit thumb icon. From Correct answers others will get benefited in future.

Regards,

T Mohan.

[Harshal Aditya]

Hi @taqdeer ,

Hope you are doing well.

Please refer below screenshot it should work

Please mark this response as correct or helpful if it assisted you with your question.

Regards,
Harshal