How to create database view to get all incidents whose comments are not updated since 3 days ?

[Snehal13]

How to create database view to get all incidents whose comments are not updated since 3 days ?

Joining sys_journal_field table and incident table is fine but how to set the offset of X days in database view ?

Anyone has tried this approach and got the result as mentioned above ?

Note - I have a working approach of  running a query BR on above mentioned tables and getting the expected result BUT want to check if a database view can satisfy the requirement without the need of a business rule

[Snehal13]

I have the database view on 2 tables and defined the view table incident and added columns that should show on the view result but not seeing chosen columns.

[Ankur Bawiskar]

@Snehal13 

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.