How to set show only active RITM records in assessment metric questions - fliter condition

[Kranthi Kumar4]

How to set show only active RITM records in assessment metric questions - fliter condition or reference qualifier

[Trupti94]

Hi @Kranthi Kumar4 ,

asmt_metric table doesn't store any task id , you can find it in asmt_metric_result table as Source field

[Kranthi Kumar4]

Can please explain clearly how to show only RITM active records.

[Trupti94]

you can use below filter by dot walking instance field to get active record as follow,

[Dnyaneshwaree]

Hello @Kranthi Kumar4 ,

Tried but not found and exact solution for your issue so, refer below articles if helpful:
https://www.servicenow.com/community/developer-articles/filter-assessment-metric-reference-fields/ta...
https://www.servicenow.com/community/itom-forum/filtering-reporting-on-metric-results-by-assignment-...
https://docs.servicenow.com/bundle/washingtondc-servicenow-platform/page/administer/assessments/task...