Need to join case table with asmt_assessment_instance table . I did but only getting 7 record

[priyankar umesh]

I joined asmt_assessment_instance table with case table . please see my where clause 
asmt_task_id = cse_sys_id && (asmt_metric_type='855bde6f1bcf22502b80ea82b24bcbdd' || asmt_metric_type='a19ea66b1b8f62502b80ea82b24bcb7c') since I only want to include two specific metric type .
I m only getting 7 record that too only belongs to one metric type . please help.
@Brad Bowman  

[Brad Bowman]

Both Where clause formats work for me in a similar Database View.  If your Where clause is only

asmt_task_id = cse_sys_id

how many records are shown? Is Left join = false on both tables?  If you manually filter a list view on asmt_assessment_instance only by Metric type is xxx OR Metric type is yyy, using the same two metric types, how many records are shown?

[priyankar umesh]

by asmt_task_id = cse_sys_id i can see 72 records 
Yes left join is false 
my manual filtering with metric type is assesment table i m getting 130 records

[Brad Bowman]

If you have 72 assessments that are related to the case table, you can't have more than that when filtering on only two metric types.  It sounds like one or both of the metric types you are filtering on are not triggering on the case table in some or all instances, so the task on the assessment instance is not a record on the sn_customerservice_case table.  In your manual filtering of the assessment instance table, add Task and Task.Task type to your list view to confirm the number of records that are related to cases.

[PeriyasamyP]

@priyankar umesh , Try to add condition directly in "asmt_assessment_instance " table and see