cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

Get the date when an Issue entered in a given state

oostoia
1-Visitor

Get the date when an Issue entered in a given state

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.

ACCEPTED SOLUTION

Accepted Solutions
mrump
16-Pearl
(To:oostoia)

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

View solution in original post

2 REPLIES 2
mrump
16-Pearl
(To:oostoia)

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

oostoia
1-Visitor
(To:mrump)

Thank you very much, @Matthias.

Announcements


Top Tags