Make a database view between incident and sys_email table

[nadia78]

Hi everybody, 

I am trying to make a report from two or three tables.

So I did a "database view", the thing is that the field I want to map with another is a "Document ID".

I want to make a database view from "incident" table and "sys_email" table to get back the number of the incident and the date of the email notification.

I wrote this "where clause" :

email_target (from sys_email table) CONTAINS inc_number (from incident table)

The notifications are sent to user-group. I want to get back the "created" field and link it with each incident .

Can anybody give me an idea about the way to do it. 

Best regards

[nadia78 · Accepted solution]

Hello Santhana, I tried this : sys_email_log emailog.message_id=email.sys_id exactly, this is the field called "name" I need for the report The instance displays an error : unknown column

[nadia78]

Ok for me email to sys_id, Thank you so much !