3 Replies Latest reply on May 21, 2015 12:26 AM by dodiy.m

    Calculation for Customize Ticket Number

    Apprentice

      Hi,

       

      I want to have the format of customize ticket number as like this, IM15050001:

           IM - prefix for module, Incident Management. If PR - Problem Management; RM - Request Management, and etc.

           15 - current year in format YY.

           05 - current month in format MM.

           0001 - sequence/running number which restart/reset every month.

       

      Usually I will use SQL trigger to achieve this but in SDaaS I couldn't access into database level, so the way to achieve it is only by using calculation.

       

      Regards,

      Dodi