Skip to main content
O
oostoia1-Visitor
1-Visitor
February 10, 2015
Solved

Get the date when an Issue entered in a given state

  • February 10, 2015
  • 1 reply
  • 1457 views

Hi, guys. I am trying to generate a report containing in some columns the date when an issue entered in a given state. For example, if an Issue entered in Classified state today, the actual value will be 10/02/2015 or whatever date format is used by Integrity.

Can this behavior be achieved? The support team from my company told me that this isn't possible, but I want to hear other opinions.

What bothers me is the fact that the date that I want is available in the History tab of the issue, but I cannot get it.

I attached a file just to be more clear.

Thanks in advance.

    Best answer by mrump

    This is possible using a computed Expression:

    There are some usefull computed expression function classes available that should do the trick.

    dateFirstEntered(state-name)

    Returns date specified state first entered.

    Timestamp

    dateLastEntered(state-name)

    Returns date specified state last entered.

    Timestamp

    HTH Matthias

    1 reply

    M
    mrump16-PearlAnswer
    16-Pearl
    February 10, 2015

    This is possible using a computed Expression:

    There are some usefull computed expression function classes available that should do the trick.

    dateFirstEntered(state-name)

    Returns date specified state first entered.

    Timestamp

    dateLastEntered(state-name)

    Returns date specified state last entered.

    Timestamp

    HTH Matthias

    O
    oostoia1-VisitorAuthor
    1-Visitor
    February 10, 2015

    Thank you very much, @Matthias.

    Terms & ConditionsCookie settingsAccessibility statement