Report ranges don't seem to work and I'm stuck
Hi,
I have a requirement to provide a list of work items in ranges, 30 days old and newer, 30 days old to 60 days old, and then older than 60 days.
the filter condition for equals 30 days works. However, when I try to create a range 30-60 days old, i only get the 30 days.
I've exhausted everything I can think of short of params, but I'm not sure that will be available as this will be a widget in the home screen similar to the work list or other report lists of items.
I've tried creating a data page that calculates the 30 to 60 day range to use as the filter, but errors on save.
I've tried creating properties with declare expressions on them to use as the filter criteria, but errors because it's not an exposed column... it's a calculated date... not part of the table...
I'm out of ideas at the moment. I looked up creating my own symbolic date ranges, but that appears to only be supported in the Customer Service Framework.
I'd appreciate thoughts of how to get those filter criteria without using params.
thanks,
scott
***Edited by Moderator Marije to add Capability tags***