cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fiilen New Member
New Member

Project online - Timereporting data for limited period

Hi

We have a time registration report based on the OData feed to project online.

We extract the timesheetLines and use this to aggregate the required data. Unfortunately there are thousands of records in this table, and the extract runs quite slow.

We only need data for the last couple of months, but the table holds date for almost two years.

Is there any way to limit the extract to only pull current month + the last two months? I know I can filter this in the reports, but I want to get the data out already at the extraction point.

Regards

Michael

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Project online - Timereporting data for limited period

@fiilen,

You can add $filter parameter into your OData URL. For more details, please review the examples in the blog below.

https://pwmather.wordpress.com/tag/excel/
https://project-brain.com/2016/07/24/odata-reports-with-project-onlineproject-server-part2/

A detailed list about filter command is listed in this article.


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: Project online - Timereporting data for limited period

@fiilen,

You can add $filter parameter into your OData URL. For more details, please review the examples in the blog below.

https://pwmather.wordpress.com/tag/excel/
https://project-brain.com/2016/07/24/odata-reports-with-project-onlineproject-server-part2/

A detailed list about filter command is listed in this article.


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.