Create Database view

[Dileep2]

Hi All,

Please suggest how to create Database view with the below conditions.

1. Incident’s last updated by is NOT caller/affected user/opened by
2. #1 filter is only for category ‘HAK'.

Thank you

[Ankur Bawiskar]

@Dileep2 

database view is used only when you wish to join more than 2 tables and there is some common info between them.

For your above requirement you can simply use report on incident table

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

[jlaps]

This is a report or filter as noted in other response. You will want to do something like this-

[Bhimashankar H]

Hi @Dileep2 ,

Database views are created only when you want to see the data from more than 2 tables with some joins between table.

For your requirement you can create module on application menu 'incident' and link type 'List of records' on 'incident' table below that you can give your desired filter condition to filter the record from the table.

Type Modules in left navigation -> Under System Definition -> Click on Modules and create new one as described above.

Thanks,
Bhimashankar H

-------------------------------------------------------------------------------------------------
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. Thanks!