Recently we were working on OData based report for one of our customers and was running into issue. Later we found that its a bug in on-premise version of Project Server where Odata fails to evaluate expressions containing Boolean field. For example, the below Odata query will not return any records due to use of Boolean expression TaskIsMilestone eq true or TaskIsMarked eq True

http://ServerName/PWA/_api/ProjectData/[en-US]/Tasks?$Filter eq true or TaskIsMarked eq True

Note: This issue doesn’t exist in Project Online.

PPM Works is a full service Microsoft Project and Portfolio Management consultancy, focused on Microsoft Project Server and Microsoft SharePoint platforms.  We believe in partnering with our clients to exceed expectations and build long lasting rewarding partnerships. We are continuously building a knowledge base of multiple tips, tricks and solutions to make your use of Microsoft Project Pro as quick and easy as possible. Contact us for more information.

Stay updated with the latest of Project Online/Server 2013 with us: Subscribe. Check our future events!

Subscribe to our webcast email list for updates on our upcoming webinars! 

Visit our FAQ Page for access to our tool box.