CA Service Management

  • 1.  CA BOXI travel between objects

    Posted Dec 19, 2016 05:07 AM

    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. 



  • 2.  Re: CA BOXI travel between objects

    Posted Jan 03, 2017 09:09 PM

    You can drag and drop, and do the join using where clause.

     

    You can build a new universe;

    CABI4::. Building a new universe