Database view not showing column values of one table

[DeblinaD]

Hello fellow developers,

I Have currently configured a database view by utilizing by 2 tables---Security Incident (sn_si_incident) and Application security tags. I Have put in all tHe required data and added two tables. Also added a where clause for Application security tags,specifying "si_sys_id= tag_record_id"(where si is prefix for Security Incident and tag is for Application security tags). The problem is when I am trying to get the data from both the tables, the field values/columns from security incident is coming as blank, whereas there is data for Application security tags. Have you faced any issue like this? Please help me!!

Regards,

Deblina 

[Ankur Bawiskar]

@DeblinaD 

did you add the fields present in where clause as view fields under that view table?

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

[JatinJ720760582]

I added them but still not helful