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 ]

            Hello Team 👋 - I am happy to announce that the fix has been rolled out to production. Please note that we have limited the scope of this ticket to the date/time functions. The rest are included in the following tickets, please follow them for further updates:

            Apologies for the inconvenience this has been causing and looking forward to working on the rest soon. 

            Please let us know if you have seen any issues with the fix.

             

            Thanks,

            Mohamed Hassan

            Product Manager | JSM Assets

            Mohamed Hassan added a comment - Hello Team 👋 - I am happy to announce that the fix has been rolled out to production. Please note that we have limited the scope of this ticket to the date/time functions. The rest are included in the following tickets, please follow them for further updates: https://jira.atlassian.com/browse/JSDCLOUD-12831 https://jira.atlassian.com/browse/JSDCLOUD-12834 https://jira.atlassian.com/browse/JSDCLOUD-12733 https://jira.atlassian.com/browse/JSDCLOUD-12734 https://jira.atlassian.com/browse/JSDCLOUD-10081 Apologies for the inconvenience this has been causing and looking forward to working on the rest soon.  Please let us know if you have seen any issues with the fix.   Thanks, Mohamed Hassan Product Manager | JSM Assets
            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

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

                Created:
                Updated:
                Resolved: