creating database view for metric result aand hr case table

poornima batchu
Tera Expert

Hi all, 

I'm try9ing to create a database view for metric result table and hr case table. I couldnot able find a proper where clause. Which where clause I have to give please comment.

4 REPLIES 4

Mohith Devatte
Tera Sage
Tera Sage

hello @poornima batchu ,

assuming your metric instance is in hr CASE TABLE 

YOU CAN TRY this clause in hr CASE VIEW TABLE 

Prefix : mtr

View Table : metric instance 

 

PREFIX : HRC 

View Table : hr case

clause : mtr_id = hrc_sys_id

please mark my answer correct if it helps you

 

 

It is showing an error as mtr_id field is not visible

find_real_file.png

hello @poornima batchu then try this 

mtr_source_id = hrc_sys_id

and give order for HR case tabel as 200

mark my answer correct if it helps you

 

@poornima batchu any luck on this ?

if it worked please mark this answer correct and close the thread so that i t goes to solved queue