I needed to join the incident table with the users table to generate a specific report, how can we do that, as I would like to do it using the database view

[1231]

.

[Mohith Devatte · Accepted solution]

Hello ,

You can do it through data base views but what field you want to link from user table to incident table ? 

is it the caller field?

If yes please refer to below  attached screenshot

i created a data base view and create two view tables in the related list 

1)sys_user

2) Incident  --> i gave where clause as inc_caller_id = usr_sys_id which matches and gets all the incidents where caller id is present in user table 

3) After this click on try it related link. This will get you the records 

Please accept this solution if you find it helpful.This might help other users also

[1231]

I need the caller field but it dynamically reflects according to the user's selection

[Mohith Devatte]

Please check the above reply and let me know i have attached a screenshot on how to create