Solved

Increase records returned from project oData query

Posted on 2014-09-10
2
397 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

773 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