CA Service Management

Expand all | Collapse all

How to add time_spent_sum from Tkt to CABI universe?

  • 1.  How to add time_spent_sum from Tkt to CABI universe?

    Posted 10-31-2016 02:07 PM

    I'm trying to add the time_spent_sum field from Tkt object to CABI universe to use this in a new report, but the Universe Designer shows the following messages for each case:

     

    Case 1: tkt.time_spent_sum
    Error: The expression type is not compatible with the object type.

     

     

    Case 2: PdmSeconds(tkt.time_spent_sum)
    Error: Parse failed: Exception: DBD,[DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]AHD12028:PdmSeconds argumento NULL tem um tipo inválido string at time_spent_sum )State:12028

     

     

     

    Can anyone guide me if I'm doing something wrong or if this really possible?



  • 2.  Re: How to add time_spent_sum from Tkt to CABI universe?

    Posted 11-07-2016 08:23 AM

    Hi,

     

    Try to use a String type, for formulas Try to use on Report Formulas.

     

    Best Regards.