How to join sys_history_line with hr case table

[Prateek07]

I want to join sys_history_line with hr case table with lable = state. I am trying below DB view solution but it is not working. Please suggest.

Thanks in advance!

[Samaksh Wani]

Hello @Prateek07 

Do the following :-

In the Second record you wrote :- hi.set=hs.sys_id

replace yours with mine :-

hi.hs=hs.sys_id

Plz mark my solution as Accept, If you find it helpful.

Regards,

Samaksh

[Prateek07]

Hi @Samaksh Wani 

I have seen this solution on below link. But it is giving me blank values.

https://www.servicenow.com/community/itsm-forum/how-to-join-sys-history-line-table-with-incident-tab...

Thanks,

Prateek

[Samaksh Wani]

Hello @Prateek07 

replace your second record :-

hi.hs=hs.sys_id

like this 

Plz mark my solution as Accept, If you find it helpful.

Regards,

Samaksh

[Prateek07]

Hi @Samaksh Wani 

Got the below error

Thanks,

Prateek