AnsweredAssumed Answered

CA BOXI travel between objects

Question asked by JFMelhorado on Dec 19, 2016
Latest reply on Jan 4, 2017 by TMACUL

Hello,

 

We're using CA BOXI 3.3, and for what we know, in the derived Universe we can't add anything in the Where Clause. 

So for instance, if we need to know the ID of the group which an incident has been assigned, we have to do it "manually" in the report (in this case we can do:

SELECT
in.ref_num,
in.group_name,
cnt.contact_num

FROM
in,
cnt
WHERE
in.open_date > {d '2016-11-01 00:00:00 am'}
AND
in.group_name = cnt.last_name 

This works fine. But is there a way to provide cnt.contact_num(the alternate identifier) without changing the query? Just adding the object to the query (in this case cr_cnt.contactu_num)? I have created the object, in CR, but it won't get the correct info, since we can't add anything in the where clause. 

 

So, is there a way to get the group parent (z_parent) by creating the object directly in cr? Or is it necessary to always change the query manually in the report? In the z_parent case, we created them in cr, but they return all the departments/areas. They won't filter by the group which the incident has been assigned.

 

Thank you in advance!!

Best regards,

Joao. 

Outcomes