How to filter by resolutionDate in RTC plan view
I'm using RTC 4.0.2. I have an RTC plan with a particular view that I've created. I'm using the web client exclusively to access that view. I'd like to use a filter on that view to exclude any work items that have been resolved more than a month ago. I know how to do a "filter by" "expression" "resolutionDate:", but I don't know how to specify "more than a month ago" after the "resolutionDate:"
Ideally, I could say "more than a month ago" an leave just leave the view like that. If that's not possible, I could hard code a date and say "anything before such-and-such date" and just update the view periodically to change the date. But I don't even know how to do that.
Note that I understand that I can exclude resolved items easily. But that means that nothing that has been resolved shows up, whereas I want the things that have been closed in the last month to show up, and to exclude anything older than that.
Any help on this would be greatly appreciated.
Thanks,
Joe Gariano
Ideally, I could say "more than a month ago" an leave just leave the view like that. If that's not possible, I could hard code a date and say "anything before such-and-such date" and just update the view periodically to change the date. But I don't even know how to do that.
Note that I understand that I can exclude resolved items easily. But that means that nothing that has been resolved shows up, whereas I want the things that have been closed in the last month to show up, and to exclude anything older than that.
Any help on this would be greatly appreciated.
Thanks,
Joe Gariano
Accepted answer
Exclude Expression "resolutionDate : < today-30"
Comments
That is not working for me; it doesn't filter out anything. Are you able to get it to work? If, what version of RTC are you using? And are you doing that from the web client interface?
Thanks,
Joe
Yes it's the web UI. I can't remember whether it's 4.0.6 or 5.0. After adding the attribute name, there is a hint telling you what expression can be appended to the attribute. I don't have 4.0.2 handy but 4.0.1 does not work either. So you might need to move up to a new version to get it working.
Thanks. We'll be moving to 5.0 later this year, so I'll wait for that.
1 vote