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

priyankar umesh
Tera Contributor

2 hours ago

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  

Preview file
44 KB
Preview file
74 KB
0 Helpfuls
  • 110 Views
2 REPLIES 2

Matthew_13
Kilo Sage

2 hours ago

You’re very close. The issue is usually one of these:

  1. Wrong operators
    If this is a report / PA / filter, && and || won’t work reliably. Use AND / OR or IN.

Example:

(asmt_metric_type='855bde6f1bcf22502b80ea82b24bcbdd'
 OR asmt_metric_type='a19ea66b1b8f62502b80ea82b24bcb7c')

or

asmt_metric_type IN
855bde6f1bcf22502b80ea82b24bcbdd,
a19ea66b1b8f62502b80ea82b24bcb7c

  1. Wrong field
    Verify the sys_ids actually live in asmt_metric_type. Often they belong to metric / asmt_metric which would explain why you only see one type.

  2. Join field
    Make sure you’re joining:

asmt_assessment_instance.asmt_task = case.sys_id

and not a different ID field.

I think your Most likely cause: filtering on the wrong field or using && / || instead of OR/IN.

 

@priyankar umesh  - Please mark as Accepted Solution and Thumbs Up if you found Helpful!!

0 Helpfuls

Brad Bowman
Kilo Patron
Kilo Patron

an hour ago

I would try the Where Clause with just one of the metric type sys_ids, see how many records the view contains, then change to just the other one and get the count.  If both work individually, they should work together, but it might be best to go with the simple Where Clause then use a before Query Business Rule on the view to limit it to the two metric types.

0 Helpfuls