Is it possible to use GETDATE in SQL Queries with the Dashboard API
we need to filter our Query with a DateTime Timestamp from the actual date. We want to get alle Workitems which are last changed in the last 1 day.
SELECT DisplayName, LastModified
where LastModified >= (DATEADD(day, -1, GETDATE())
in Sql we get the right results but in the SQL Dashboard Widget we dont get any result. Dont know why. Can somebody give us a hint on that?