creating database view for task_Sla and sys_history_line

[poornima batchu]

hi guys,

 I am trying to create a database view for task_Sla table and sys_history_line table but it its not showing any records to display.

[Community Alums]

Hi @poornima batchu ,

Any update to this ?Any follow-up required? if not

Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

[Community Alums]

Hi @poornima batchu ,

Any update to this ?Any follow-up required? if not

Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

[Abhijit4]

Hi Poornima,

Try changing task_sla table order as 50.

Also try with below query :

His_set.id=task_task

The reason is, you are comparing history line record sys_id with task sys_id which will not match anyway, you would need to compare task sys_id with field from history line table which stores sys_id of the task.

Let me know if you have any further queries.

Please mark this as Correct or Helpful if it helps.

Thanks and Regards,
Abhijit
Community Rising Star 2022