Creating a database view

[MStritt]

I'm trying to create a database view between 3 tables (below), so I can create a report and have all the fields for all 3 tables available. But, don't seem to be able to configure the 'Where clause' successfully.

Case: sn_customerservice_case
JIRA Issues: u_m2m_cases_jira_issues
Case Task: sn_customerservice_task

[SanjivMeher]

The one you currently have looks fine.

[MStritt]

What would be the Where clause for Jira Issues?

[Andrew_TND]

Hello, database views can be hard! Try this link which goes over Database view where clauses.  'Servicenow Database View  

Please mark as helpful or if it’s resolved the issue, CORRECT!