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.

[Aman Kumar S]

Hey,

Try changing the variable prefix to some other name for task_sla to "tsk"

[poornima batchu]

not working

[Aman Kumar S]

Have you enabled audit for task_sla table, OOB it is not audited

[Community Alums]

Hi @poornima batchu ,

The sys_history_line table participates in Table Rotation. Ideally DB views should not be created on tables that participate in Table Rotation as it will not produce desired result.

Also, you can see the list of tables that undergo Table Rotation under - System Definitions - Table Rotations.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep