Creating a database view

[MStritt]

I'm trying to create a database view between 2 tables, and am having problems creating the where clause. Whatever I enter as a clause for either table, I'm not seeing any records when I click on 'try it' under Related Links. I would assume I'd see all cases and provisional records. I guess I'm not totally sure how to configure the clause. How to link the tables.

Tables:

sn_customerservice_case

sn_customerservice_provisioning_request

[Bert_c1]

On the database view table entry, add the 'Left join' column and set that to true for the 'sn_customerservice_provisioning_request' table. You will get all records from that table.

[MStritt]

I'm seeing records when I click on Try it. I'm wanting to create a report, that includes Case records and Provisioning records. I'm not sure if I can even do what I want to do. For example, for conditions, cs_active is true AND pro_active is true. Then I'm looking for a list of Cases and Provisioning requests that are active. 

[MStritt]

If I add a condition where Active (pro_active) is true, I want only active Provisioning Requests to display (should be 4). However, I'm seeing 102,600 records. All different Case Numbers but showing the same Provisioning Number for all the Cases.

[Bert_c1]

the following should help you:

example-left-join-db-view.html