Hello,
I've been trying to pull a report for a particular review and decisions made on the entitlements present in that review. However, it was not showing those details in the report result. It's pulling the old review details for the same review definition but not this year's review result's data which was created after the upgrade to 6.9.1.
Could someone please help?
Thanks,
DG
You can start with below query and extend it as required...
select rv.name as review_name, usr.name as user_name, rc.ent_name, rc.ent_type, states.display_name as Action,
reviewer.name as last_reviewed_by, rc.last_reviewed_date
from v_av_review_components rc
join pv_review rv on rc.review_id = rv.id
join v_master_enterprise_users usr on rc.component_id = usr.id
left join v_master_enterprise_users reviewer on rc.last_reviewed_by = reviewer.id
left join V_ER_ITEM_STATES states on rc.state = states.state
where rv.review_type = 'User'