Uploaded image for project: 'Jira Service Management Cloud'
  1. Jira Service Management Cloud
  2. JSDCLOUD-10177

Automation smart value date time functions do not work on the Assets date time attributes

      Summary

      Automation functions don't work on the Assets attributes.

      The datetime functions don't work on the Assets object date or dateTime attributes:

      Steps to Reproduce

      1. Add a date attribute to one of the object types and set a value for an object
      2. Create an automation rule that gets triggered when an object gets updated and add an action to create an issue and try to copy the date attribute of the object to the date custom field of the issue

      Expected Results

      Able to copy the value using the datetime functions:

       {{object.AttributeName.jqlDate}} 

      Actual Results

      The date and time functions do not work on the Insight object date, dateTime attributes. The below smart value is empty:

      {{object.AttributeName.jqlDate}} 
      {{object.AttributeName.toDate}} 
      

      While the below smartvalue returns the date:

      {{object.AttributeName}} 

      Though these functions work on the Created and Updated attributes of the Insight objects.

      {{object.Created.jqlDate}} 

      Workaround

      The following knowledge base article details workarounds for this bug as well as other automation functions impacted in a similar way: Workaround for using smart value functions with Assets data in Automations

      An example use of the workaround mentioned in the article:

      1. Create a variable "datevar" to store the date value:
        object.AnotherDate
      2. Then use the below functions on the variable name:
         {{datevar.toDate.jqlDate}} 

         We have an example listed on this kb: https://confluence.atlassian.com/display/JIRAKB/Update+Insight+object+attribute+values+using+automation 

            [JSDCLOUD-10177] Automation smart value date time functions do not work on the Assets date time attributes

            Simran G made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 838778 ]
            Andras M. made changes -
            Description Original: h3. Summary

            Automation functions don't work on the Assets attributes.

            The [datetime functions|https://support.atlassian.com/jira-software-cloud/docs/smart-values-date-and-time-functions/] don't work on the Assets object date or dateTime attributes:
            h3. Steps to Reproduce
             # Add a date attribute to one of the object types and set a value for an object
             # Create an automation rule that gets triggered when an object gets updated and add an action to create an issue and try to copy the date attribute of the object to the date custom field of the issue

            h3. Expected Results

            Able to copy the value using the [datetime functions|https://support.atlassian.com/jira-software-cloud/docs/smart-values-date-and-time-functions/]:
            {noformat}
             {{object.AttributeName.jqlDate}} {noformat}
            h3. Actual Results

            The date and time functions do not work on the Insight object date, dateTime attributes. The below smart value is empty:
            {noformat}
            {{object.AttributeName.jqlDate}}
            {{object.AttributeName.toDate}}
            {noformat}
            While the below smartvalue returns the date:
            {noformat}
            {{object.AttributeName}} {noformat}
            Though these functions work on the Created and Updated attributes of the Insight objects.
            {noformat}
            {{object.Created.jqlDate}} {noformat}
            h3. Workaround
             # Create a variable "datevar" to store the date value:
            {{object.AnotherDate}}
            !screenshot-1.png|thumbnail!
             # Then use the below functions on the variable name:
            {noformat}
             {{datevar.toDate.jqlDate}} {noformat}
             We have an example listed on this kb: [https://confluence.atlassian.com/display/JIRAKB/Update+Insight+object+attribute+values+using+automation
            New: h3. Summary

            Automation functions don't work on the Assets attributes.

            The [datetime functions|https://support.atlassian.com/jira-software-cloud/docs/smart-values-date-and-time-functions/] don't work on the Assets object date or dateTime attributes:
            h3. Steps to Reproduce
             # Add a date attribute to one of the object types and set a value for an object
             # Create an automation rule that gets triggered when an object gets updated and add an action to create an issue and try to copy the date attribute of the object to the date custom field of the issue

            h3. Expected Results

            Able to copy the value using the [datetime functions|https://support.atlassian.com/jira-software-cloud/docs/smart-values-date-and-time-functions/]:
            {noformat}
             {{object.AttributeName.jqlDate}} {noformat}
            h3. Actual Results

            The date and time functions do not work on the Insight object date, dateTime attributes. The below smart value is empty:
            {noformat}
            {{object.AttributeName.jqlDate}}
            {{object.AttributeName.toDate}}
            {noformat}
            While the below smartvalue returns the date:
            {noformat}
            {{object.AttributeName}} {noformat}
            Though these functions work on the Created and Updated attributes of the Insight objects.
            {noformat}
            {{object.Created.jqlDate}} {noformat}
            h3. Workaround
            The following knowledge base article details workarounds for this bug as well as other automation functions impacted in a similar way: [Workaround for using smart value functions with Assets data in Automations|https://confluence.atlassian.com/jirakb/workaround-for-using-smart-value-functions-with-assets-data-in-automations-1283495268.html]

            An example use of the workaround mentioned in the article:
             # Create a variable "datevar" to store the date value:
            {{object.AnotherDate}}
            !screenshot-1.png|thumbnail!
             # Then use the below functions on the variable name:
            {noformat}
             {{datevar.toDate.jqlDate}} {noformat}
             We have an example listed on this kb: [https://confluence.atlassian.com/display/JIRAKB/Update+Insight+object+attribute+values+using+automation
            Nicole made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 793938 ]
            Mohamed Hassan made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: In Progress [ 3 ] New: Closed [ 6 ]
            Mohamed Hassan made changes -
            Status Original: Long Term Backlog [ 12073 ] New: In Progress [ 3 ]
            SET Analytics Bot made changes -
            UIS Original: 46 New: 51
            Swati Kahol made changes -
            Link New: This issue relates to JSDCLOUD-12834 [ JSDCLOUD-12834 ]
            Swati Kahol made changes -
            Link New: This issue relates to JSDCLOUD-12831 [ JSDCLOUD-12831 ]
            Swati Kahol made changes -
            Summary Original: Assets Automation: Automation smart value date time functions do not work on the Assets attributes New: Automation smart value date time functions do not work on the Assets date time attributes
            Swati Kahol made changes -
            Link New: This issue relates to JSDCLOUD-12734 [ JSDCLOUD-12734 ]

              90325da67d46 Mohamed Hassan
              skahol Swati Kahol
              Affected customers:
              63 This affects my team
              Watchers:
              37 Start watching this issue

                Created:
                Updated:
                Resolved: