How to create metric report for HR case records

ramesh_r · ‎07-06-2022

Hi All,

I want to create metric report for HR case records. with below condition.

Whenever HR case changes to suspended state we need to create metric report.

and the report should contain following fields in the list view.

.Number, short description, state, priority

...-------------------

I have created the metric report but i am not able to display below fields

Number, short description, state, priority

Musab Rasheed · ‎07-06-2022

Hello,

You can't dot walk ID field so you need to create database view for that, Go through below links

https://community.servicenow.com/community?id=community_question&sys_id=dc7a584cdb11c0902be0a851ca9619d5

https://docs.servicenow.com/bundle/newyork-platform-administration/page/use/reporting/concept/c_DatabaseViews.html#c_DatabaseViews

Regards