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.