Solved

Increase records returned from project oData query

Posted on 2014-09-10
2
378 Views
Last Modified: 2014-09-14
Hi, currently one of our reports uses the oData api to get a list of all projects, this currently only returns 100 projects, which apparently is the default for this.  However, I've ran the PS command:

Set-SPProjectOdataConfiguration -EntitySetName Projects -PageSizeOverride 300

And when I run (Get-SPProjectOdataConfiguration).EntitySetsWithMaxPAgeSizeOverride it shows that the Projects value is now 300 (previously it wasn't showing Projects at all) but when I go to http://server/PWA/_api/ProjectData/Projects it still only returns 100 records.  I know that our reporting needs to change to accommodate the limit of 100 however until we can get that done is there another way to increase this limit? Do I have to select the PWA instance before running the above command?

Cheers
0
Comment
Question by:lee_murphy
2 Comments
 
LVL 12

Accepted Solution

by:
thausla earned 500 total points
ID: 40316757
Hi,

too easy to ask for points: just run an "iisreset" to restart the IIS Service.

No points, please!

Thomas
0
 

Author Closing Comment

by:lee_murphy
ID: 40322169
All my questions are easy when you know how :) Thank you very much!
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now