Unapproved Ideas not being pulled in Ad Hoc Reporting

Document ID : KB000120676
Last Modified Date : 09/11/2018
Show Technical Document Details
Question:
I created Ad Hoc View using idea Domain. When I filter by Status "Unapproved" no results. When I filter by other Status no results are displayed. Why? 
Answer:
Your Ad Hoc View has Column "Team Total Allocation Hours". When you filter by Status "Unapproved", the results will show Ideas with Status "Unapproved" that have have Resources in Team - Staff page with Allocation. If they don't have resources with allocation then they won't be displayed in the report.  The behavior you are seeing is expected.