AnsweredAssumed Answered

Is it possible to get monitors for each review?

Question asked by Pradeep Kadambar Employee on Jan 6, 2017
Latest reply on Jan 9, 2017 by Pradeep Kadambar

Is it possible to query the AVDB and retrieve the monitors for each review?

 

I tried the review definition table which has a monitor but that value is same as the review owner even though the review has multiple monitors set.

 

SELECT 
       user_id, first_name, last_name
FROM
       PV_USERS
WHERE ID IN (SELECT monitor FROM T_AV_ENTITLEMENTREVIEWDEF)

Outcomes