Metrics are not visible under metric definition for sc_req_item table.

[Kartik Swaroop]

Hi ,
I've created a metrics for request item table but records are not visible.

and there one database view for request item table

Would you guys please help here,  i need to create a metric report for request item table.

[Community Alums]

It will work on previous records if assignment group changes now (after creation of definition)

But it doesn't work on records where assignment group is changed before definition is created.

For example,
- If definition created at 13-06-2022 10:15 AM, if assignment group changed at 13-06-2022 11:13 AM, then this record is captured under metrics.

-  If definition created at 13-06-2022 10:15 AM, if assignment group changed at 13-06-2022 09:13 AM, then this record is NOT captured under metrics.

I hope it's clear now.

[Kartik Swaroop]

Thanks bud.

[Kartik Swaroop]

Is there any other way to find out the assignment group duration or previously created records, whenever they changed to different group ?

[Community Alums]

Hello Kartik,

Unfortunately there is no way to find this duration. Assignment group changed is being captured in the table "sys_history_line". This is basically audit history table and having huge amount of data also didn't have duration calculation. 

But you can check once if it helps you.

[Kathrina Yvonne]

Hi, just wanna ask if it's possible for the sys_req_item table and sys_history_line table to be combined in a database view? Is it possible?