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]

@Akshaykhare 

I won't recommend creating database view on system tables

those tables are huge so it will lead to performance issue

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

[Ankur Bawiskar]

@Akshaykhare 

something like this if you still require

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

[Akshaykhare]

@Ankur Bawiskar : first two tables are getting joined but as soon as I added sys_history_line with the where clause, then it is not working.

[Ankur Bawiskar]

@Akshaykhare 

in table sys_history_set the ID field is document ID

so it needs to be handled differently

Database view - How to correctly join a table using a document_id field 

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