How to create database view on sys_history_line, sys_history_set and u_finance_request

[Akshaykhare]

I am creating database view on sys_history_line, sys_history_set and u_finance_request but somehow confused with the where clause as it is not working. Image attached for the reference.

The last where clause is history_id=freq_sys_id && history_table=freq.

[Ankur Bawiskar · Accepted solution]

@Akshaykhare 

sys_history_set table is in rotation policy so I doubt it will show data even after correctly configuring the database views.

why not use Audit table?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Akshaykhare 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.