creating database view for metric result aand hr case table

[poornima batchu]

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.

[Mohith Devatte]

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

[poornima batchu]

It is showing an error as mtr_id field is not visible

[Mohith Devatte]

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

[Mohith Devatte]

@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