creating database view for metric result aand hr case table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2022 08:16 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2022 08:20 AM
hello
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2022 08:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2022 09:23 AM
hello
mtr_source_id = hrc_sys_id
and give order for HR case tabel as 200
mark my answer correct if it helps you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2022 03:21 AM
if it worked please mark this answer correct and close the thread so that i t goes to solved queue