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
Can you provide more details on the query and the filters you are using for the report. The issue could mostly be with the filters that you have set.
Hi Ramana,
Even after removing the filter, it's not showing that review result.
This is the view I can see in the Query V_AVR_ER_ITEM_DETAIL.
Thanks,
DG
This view only lists items from user reviews and only items that have a reviewer assigned. Unassigned item would not show up. So, make sure both the conditions are true with your review. Otherwise, a custom query will need to be written to display the status of each item.
Thanks, Ramana. Understood.
Is there anyway you can provide the query if you already have one?
Query should show the Review result name with the list of entitlements, Action, Reviewer name and Reviewed date in the report.
I can open a ticket in case if you want me to.
I don't have a query. What type of review do you have?
Review type is User Access.
Did I answer your Question?
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'
Thanks a lot, Ramana. It worked. I really appreciate your help on this.
Regards,
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'