locked
Timephased data Odata query RRS feed

  • Question

  • Hi,

    I am querying Timephased Assignment data from project server 2013. There are too many rows and it take very long to refresh data. Can I group days to week and get output at month level. This way number of rows fetched will decrease and hopefully query will run faster.

    Thanks!!Kunal

    Thursday, November 16, 2017 11:03 AM

Answers

  • Hello,

    The source data is by day so the query at the source will still take the time. Can you filter the date range? For example, if you only need this years data, filter this at the source using a filter query:

    {PWAURL}/_api/ProjectData/{timephased end point / feed}()?$filter=TimeByDay ge datetime'2017-01-01T00:00:00' and TimeByDay le datetime'2018-01-01T00:00:00'

    Also use a select to select just the columns you need, for example:

    {PWAURL}/_api/ProjectData/{timephased end point / feed}()?$filter=TimeByDay ge datetime'2017-01-01T00:00:00' and TimeByDay le datetime'2018-01-01T00:00:00'&$select=AssignmentId,TimeByDay

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    • Marked as answer by PWMatherMVP Friday, December 15, 2017 9:09 AM
    Thursday, November 16, 2017 1:25 PM