Make a database view between incident and sys_email table

nadia78 · ‎01-31-2019

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 · ‎02-06-2019

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

View solution in original post

KP27 · ‎01-31-2019

if the object of sys_email table is email & that of incident is inc then the where clause should be something like this
email.instance = inc.sys_id

nadia78 · ‎02-01-2019

Thank you KP so much ! i works

KP27 · ‎02-01-2019

Welcome!!!

Sri Harsha3 · ‎02-01-2019

Please mark the answer if it solved the problem so that the ticket will be closed.