CA Service Management

 View Only
  • 1.  Jasper - WorkShift calculation

    Posted Sep 21, 2018 03:34 PM

    Is it possible to calculate a time duration within jasper, using workshift constraints? I need to calculate the real Service Time (In business days) for tickets. We had this functionality in Boxi, do we have it in Jasper?



  • 2.  Re: Jasper - WorkShift calculation

    Broadcom Employee
    Posted Sep 25, 2018 01:55 PM

    Hi Lucas,

       

          It may be possible through the function  "PDMDownTime ".

    **PdmDownTime ( slaName, workshift, startDate, endDate ) Calculates the downtime between two dates under the specified SLA and workshift. This function can be used only in the selection list.

          See this example discussed in another post of the community, where was used the  "PdmToday"

     

    SELECT

    cr.group_name,

    cr.ref_num,

    cr.open_date,

    cr.priority_symbol,

    cr.status_symbol,

    cr.request_area_symbol,

    cr.active,

    cr.web_url,

    (PdmToday() - cr.open_date)/(7*24*3600),

    (PdmToday() - cr.open_date)/(24*3600),

    (PdmToday() - cr.open_date)/3600,

     

    (case when ((PdmToday() - cr.open_date)/(7*24*3600)) <2 then '1'

    when ((PdmToday() - cr.open_date)/(7*24*3600)) >=2 AND ((PdmToday() - cr.open_date)/(7*24*3600)) <3 then '2'

    when ((PdmToday() - cr.open_date)/(7*24*3600)) >=3 AND ((PdmToday() - cr.open_date)/(7*24*3600)) <4 then '3'

    when ((PdmToday() - cr.open_date)/(7*24*3600)) >=4 AND ((PdmToday() - cr.open_date)/7*24*3600)) <5 then '4'

    when ((PdmToday() - cr.open_date)/(7*24*3600)) >=5 AND ((PdmToday() - cr.open_date)/(7*24*3600)) <8 then '5'

    when ((PdmToday() - cr.open_date)/(7*24*3600)) >=8 then '6'

    ELSE '' end ) as WeeksOpened,

     

    Additional Information

    PDM Functions for BusinessObjects Reports

    OOTB JasperReports query issue in Studio 6.3

     

    I hope I helped you in some way.

     

    Regards,

    Fábio Silva



  • 3.  Re: Jasper - WorkShift calculation

    Broadcom Employee
    Posted Sep 26, 2018 04:08 AM

    Please note that that this function and all other pdm functions  works only if you are using SDM odbc driver.

    see attached link for other pdm_function.

    https://docops.ca.com/ca-service-management/17-1/en/using/reporting/reporting-using-ca-service-desk-manager/ca-business-intelligence-reports/write-ca-business-intelligence-reports 



  • 4.  Re: Jasper - WorkShift calculation

    Posted Sep 26, 2018 07:03 AM
      |   view attached

    So, by default, does Jasper reports use ODBC driver or not?

     

     

     

     

     

     

     

    Lucas Lopes Mesquita

    ANALISTA DE TECNOLOGIA DA INFORMACAO I

    Fone: +55(85)3266-6425

    Cel: +55(85)99197-9963

    Email: lucas.mesquita@solarbr.com.br

     

     

     

    Antes de imprimir, pense no Planeta!

     

    A informação transmitida (incluindo qualquer anexo) é de uso exclusivo da pessoa ou entidade à qual ela foi endereçada e pode conter material confidencial e/ou privilegiado. Fica proibida qualquer revisão, disseminação, utilização e/ou tomada de decisões por pessoas ou entidades, exceto pelo destinatário pretendido. Se por um erro você recebeu este e-mail, por favor apague-o de qualquer computador e contate o remetente. Nós da Solar BR temos o compromisso de manter os mais altos padrões éticos e de integridade.  Conheça nosso canal de ética no Conecta SolarBR<http://conecta.solarbr.com.br/>.

     

    The information transmitted (including any attachments) is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, dissemination, making use of or taking of any action in reliance upon this information, by people or entities other than the intended recipient, is prohibited. If you have received this in error, please contact the sender and delete the material from any computer. At Solar BR we are committed to maintain the highest standards of business ethics and integrity. Know our ethical channel on Conecta SolarBR<http://conecta.solarbr.com.br/>.

     

    De: trich02 <communityadmin@communities-mail.ca.com>

    Enviada em: quarta-feira, 26 de setembro de 2018 05:09

    Para: Lucas Lopes Mesquita <lucas.mesquita@solarbr.com.br>

    Assunto: Re:  - Re: Jasper - WorkShift calculation

     

    CA Communities <https://communities.ca.com/?et=watches.email.thread>

     

     

    Re: Jasper - WorkShift calculation

     

    reply from CHRISTOPHE TRINQUET<https://communities.ca.com/people/trich02?et=watches.email.thread> in CA Service Management - View the full discussion<https://communities.ca.com/message/242143855-re-jasper-workshift-calculation?commentID=242143855&et=watches.email.thread#comment-242143855>



  • 5.  Re: Jasper - WorkShift calculation

    Broadcom Employee
    Posted Sep 26, 2018 07:43 AM

    yes out of the box reports are using SDM ODBC driver.