• 4
    • 6
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      Is there a way to perform a search based on date/time of the latest transition without developing a plug-in? For example it would be useful to search for issues that were closed at a certain date, or for issues that were moved from one state to another within x number of days.
      This would be feasable if "Transition post function" "Update issue field" worked on date/time fields. Then I would have created a custom field called "Transition Time" and had it set to current date/time automatically during all transitions which I could easily perform a search on. Is it possible to extend "Update issue field" functionality to include the date/time fields?

      Thanks
      Ahmet

            [JRASERVER-8875] Transition timestamp

            I'm hoping that somewhere over the last 6.5 years, this was picked up.  If so, can someone point me to how to do it please?  Many thanks!

            Sharon Grimm added a comment - I'm hoping that somewhere over the last 6.5 years, this was picked up.  If so, can someone point me to how to do it please?  Many thanks!

            If you migrated to JIRA 4.3 or above I might propose you a solution by using the JJUPIN plugin

            Using the JJUPIN plugin one can set any system or custom field

            You may write the following code in a post-function (E.g. in resolved):

            SIL code
            // you may access a customfield by customfield_nnnnn, by name or by alias
              // E.g. Transition Time (a date and time CF)
              customfield_10000 = currentDate();
            
              // time-to-transition (since created) (an interval CF) 
              customfield_10023 = customfield_10000 - created;
            

            See here all JIRA standard fields available in SIL: http://confluence.kepler-rominfo.com/display/JJUP20/Standard+Variables
            Here is how you create a condition, validator or post-function: http://confluence.kepler-rominfo.com/display/JJUP20/Writing+Validators%2C+Postfunctions+and+Conditions

            Here is how you create a condition, validator or post-function: http://confluence.kepler-rominfo.com/display/JJUP20/Writing+Validators%2C+Postfunctions+and+Conditions

            You may download it from the Atlassian Marketlace or from here: http://jira-plugins.kepler-rominfo.com/x/product/id/3

            Florin Haszler (Alten Kepler) added a comment - If you migrated to JIRA 4.3 or above I might propose you a solution by using the JJUPIN plugin Using the JJUPIN plugin one can set any system or custom field You may write the following code in a post-function (E.g. in resolved): SIL code // you may access a customfield by customfield_nnnnn, by name or by alias // E.g. Transition Time (a date and time CF) customfield_10000 = currentDate(); // time-to-transition (since created) (an interval CF) customfield_10023 = customfield_10000 - created; See here all JIRA standard fields available in SIL: http://confluence.kepler-rominfo.com/display/JJUP20/Standard+Variables Here is how you create a condition, validator or post-function: http://confluence.kepler-rominfo.com/display/JJUP20/Writing+Validators%2C+Postfunctions+and+Conditions Here is how you create a condition, validator or post-function: http://confluence.kepler-rominfo.com/display/JJUP20/Writing+Validators%2C+Postfunctions+and+Conditions You may download it from the Atlassian Marketlace or from here: http://jira-plugins.kepler-rominfo.com/x/product/id/3

            Ian Daniel added a comment -

            Hi guys,

            What are the chances of this being implemented? We need to report against the time that a custom workflow transition occurred.

            Cheers,
            Ian

            Ian Daniel added a comment - Hi guys, What are the chances of this being implemented? We need to report against the time that a custom workflow transition occurred. Cheers, Ian

            Pavol Nagl added a comment -

            Any news on this one?
            Have you decided, if you are going to implement it?
            Do anybody know a solution on this?

            (I want to filter issues by current status and by time spent in this status. IE filter issues in status "open", that are in this status for more than 24 hours. I want to ensure that no issue is forgotten)

            Thank's for any piece of advice..

            Cheers

            Paul

            Pavol Nagl added a comment - Any news on this one? Have you decided, if you are going to implement it? Do anybody know a solution on this? (I want to filter issues by current status and by time spent in this status. IE filter issues in status "open", that are in this status for more than 24 hours. I want to ensure that no issue is forgotten) Thank's for any piece of advice.. Cheers Paul

            Using v3.13.1 - agree with the original author: it would be very helpful to have a field that would allow me to set the date/timestamp when a transition takes place. I need to chart when issues are verified by my QA team (similar to when my Dev team resolves an issue). In our flows, we do several steps after QA verification but before we close an issue. Exposing a searchable field(s) from the transition history would be useful.

            Ken O'Brien added a comment - Using v3.13.1 - agree with the original author: it would be very helpful to have a field that would allow me to set the date/timestamp when a transition takes place. I need to chart when issues are verified by my QA team (similar to when my Dev team resolves an issue). In our flows, we do several steps after QA verification but before we close an issue. Exposing a searchable field(s) from the transition history would be useful.

            Hi Mark,

            I have installed the toolkit here so I am familiar with the "Since Last comment" custom field, and I thought about a similar custom field to look up the last transition time, but I was afraid that it would perform poorly during a search as I would have to iterate through the change history collection for each issue. Also I find sorting by "Since Last Comment" field very slow.
            With the method I described above I would have wider range of options while searching too such as relative and absolute date queries.
            I will give it a shot at both plug-ins. I think it would have been nice to have this feature built-in.

            Thanks
            Ahmet

            Ahmet Goral added a comment - Hi Mark, I have installed the toolkit here so I am familiar with the "Since Last comment" custom field, and I thought about a similar custom field to look up the last transition time, but I was afraid that it would perform poorly during a search as I would have to iterate through the change history collection for each issue. Also I find sorting by "Since Last Comment" field very slow. With the method I described above I would have wider range of options while searching too such as relative and absolute date queries. I will give it a shot at both plug-ins. I think it would have been nice to have this feature built-in. Thanks Ahmet

            MarkC added a comment -

            Ahmet,

            The best way to achieve this functionality is to create a custom field that looks up its value from the change history. That way, you don't have to, keep using the post function to keep the field updated.

            The best places for examples of the CalculatedCustomField is probably in the toolkit. You can download the source form there. The "Last commented by user" custom field is an example of something that looks up a value/

            Cheers,

            Mark C

            MarkC added a comment - Ahmet, The best way to achieve this functionality is to create a custom field that looks up its value from the change history. That way, you don't have to, keep using the post function to keep the field updated. The best places for examples of the CalculatedCustomField is probably in the toolkit . You can download the source form there. The "Last commented by user" custom field is an example of something that looks up a value/ Cheers, Mark C

              Unassigned Unassigned
              1d8dd519e09b Ahmet Goral
              Votes:
              26 Vote for this issue
              Watchers:
              16 Start watching this issue

                Created:
                Updated: