Reports at a Point in Time

There are two special purpose filters, with data dictionary names of HIST_RANGE_START and HIST_RANGE_END, with default titles of Historic data filter (start) and Historic data filter. These allow the user to run a report as of a specific date / time, range of dates, in history. Simply use these fields as filter on a query and the results displayed will be shown as they existed at that point in time.

These filters have a special use, and may only be placed on a search layout for use in standard queries. There is no access to use this filter from advanced query screens.

It is important to note that the filters will only return reasonable results if the user sets HIST_RANGE_START to be less than or equal HIST_RANGE_END.

Other filters used in conjunction with a query that uses HIST_RANGE_START and HIST_RANGE_END are applied to the current values of these fields, not to the values that these issues had at any point in the past. It would not be logical to do otherwise, as the filter values may have changed many times during the history time range selected. One consequence of this is that it is never possible to return values for deleted issues, within the time period selected.