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

Kranthi Kumar4
Tera Expert

KranthiKumar4_0-1723524699791.png

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

5 REPLIES 5

Trupti94
Tera Guru

Hi @Kranthi Kumar4 ,

 

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

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

KranthiKumar4_0-1723538787198.png

 

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

Trupti94_0-1723551616240.png

 

Dnyaneshwaree
Mega Sage

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...


Please accept my solution if it works for you and thumps up to mark it as helpful.
Thank you!!

Dnyaneshwaree Satpute
Tera Guru