Filter/View

How to Build Filter to Query from DMS Item History

OVERVIEW

In some cases, you may wish to collect items based on historical changes that happen to the item. Once you identify the change in the history of the item then you can query specifically that change.

In case you wish to retrieve all the DMS items that a change in new revision occurred to the item during a certain period of time, you may need to build your filter in 2 stages.

CREATE FILTER
  1. Filter with Projects=Document Control and Item Type = DMS Item
  2. User defined Criteria: id in (select obj_id from sys_history where tablechanged=’objects’ and FieldName in (‘revision’,’change no’) and timedone>= DATEADD(day, -7, GETDATE()) )

    Note: DATEADD = will be the number of days since the event occurred on that specific historical event.

ADD DASHBOARD PANEL
  1. Create a new Grid panel that select only work items of DMS Item
  2. Select the special filter you have created in the previous setup
RELATED LINKS

How to create View

How to add Grid Panel in the Dashboard

Related Articles