Forum Discussion

feric80's avatar
feric80
Copper Contributor
Oct 21, 2023

Azure Devops Analytics and filters on Iteration/EndDate on a snapshot

Hello,   I have the following query:    let Source = OData.Feed("https://analytics.dev.azure.com/isaac-rd/ISAAC%20Platform/_odata/v4.0-preview/WorkItemSnapshot?" & "$apply=filter(" ...
azure devops
PiotrK's avatar
PiotrK
Copper Contributor
Jul 23, 2024

feric80 I have found solution to add this in query filter:

https://analytics.dev.azure.com/{organization}/{project}/_odata/v3.0-preview/WorkItemSnapshot?$filter=(DateValue eq Iteration/StartDate or (day(DateValue) eq day(Iteration/EndDate) and month(DateValue) eq month(Iteration/EndDate) and year(DateValue) eq year(Iteration/EndDate))) and Iteration/StartDate ge datetime'2024-01-01T00:00:00Z'

Resources