RTC report REST API: how can I query all items which are not finalized for a year or more?
![]() Hi!
I do some reporting stuff by the help of RTC's REST API.
For performance reasons, I want to skip all items which are finalized for a year or more.
In other words, I need to query for all items which are not finalized OR which has been finalized after a specific date.
So I need a positive filter like
resolutionDate > xxxx-xx-xx or resolutionDate is undefined
or
!(resolutionDate < xxxx-xx-xx)
The latter one doesn't work because there seems to be no logical negation.
The first one doesn't work because I have no idea how I can query for items whose resolutionDate is undefined.
Does anybody has an idea how I can query all items which are not resolved OR are not resolved for more than a year?
Thanks!
Daniel
|
One answer
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.