Pulling sys_history_line field on report on sc_task

[Kaju]

Hi All ,

I have report for fetching sc_task records with previous assignment group A and now reassigned to different assignment group.

I have done this by using script include and calling that script include in report.

Now, I want to show that who has updated the assignment group. To achieve this for particular record, I need to show "user_name" field from sys_history_line table to the existing report on sc_task.

Do we have any solution to achieve this?

I tried with database views, but did not work. I believe , it is not recommended to have database views on sys_history_line and sys_audit tables.

Kindly suggest another option.

Thank you in advance 🙂  

[Kaju]

Hi ,

Thank you for your guidance:)

trying with metrics , not able to get previous assignment group details as we do not have option to use "previous" object in metrics scripting

Do you have any suggestions to achieve this?

Thank you.