CA Service Management

Expand all | Collapse all

custom date field to be added in TEXT_API

Jump to Best Answer
  • 1.  custom date field to be added in TEXT_API

    Posted 09-11-2018 01:34 PM

    Hello ,

     

    We need to add custom field zsourcedate field which is date field in CA Service Desk in TEXT_API. So that we can send custom date time through email for this field.

    I have added field in TEXT_API as REQUEST.SOURCEDATE=zsourcedate.date

     

    I am trying to send email as %SOURCEDATE=09/11/2018 09:50 am but still this date/time is not updating in the ticket.

    Is there any other format to be send or something needs to be done. In CA Service Desk web, we are able to enter the format as  09/11/2018 09:50 am.

     

    Any idea?

     

    Thanks

    MM 



  • 2.  Re: custom date field to be added in TEXT_API

    Posted 09-11-2018 02:49 PM

    MM, what if you change to

    REQUEST.SOURCEDATE=zsourcedate.DATE

    and recycle? Thanks _Chi



  • 3.  Re: custom date field to be added in TEXT_API

    Posted 09-12-2018 06:09 AM

    Thanks Chi, I changed the Date as upper case. it starts working. But system updating with system date time zone. Is there any method to update this date field with user timezone.

    Thanks

    MM



  • 4.  Re: custom date field to be added in TEXT_API

    Posted 09-12-2018 09:11 AM

    MM, I don't think there is some configurable way to make the Text API use the user timezone. It always uses the server timezone. Thanks _Chi



  • 5.  Re: custom date field to be added in TEXT_API
    Best Answer

    Posted 09-12-2018 04:47 PM

    Hi,

     

    Workaround with custom function described here Ticket to be created VIA email if Affected End User entered wrong 

    could be helpful in this situation too.

     

    You can pass date as string concatenated with timezone, then using spel code parse and modify date before saving.

    split example: SPEL: How to upload attachment using SPEL 

    date parsing examples: CA Service Desk date function in spell code 

     

    Regards.



  • 6.  Re: custom date field to be added in TEXT_API

    Posted 09-13-2018 03:34 AM

    Thanks cdtj,

     

    It really helped me a lot. I have created function which adds the date difference to the date which sends by the end user.

    Thanks again.

    Cheers!

    MM