Forum Discussion
feric80
Oct 21, 2023Copper Contributor
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("
...
PiotrK
Jul 23, 2024Copper Contributor
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'