Error when querying with dates
Opened this issue · 1 comments
Describe the bug
When creating a work item query and using a date filter I get the error
"Operation failed: The string must have at least one character. Parameter name: wiql"
Environment:
- Browser firefox
- hosted (Azure Devops)
- If using a local installation what version
Screenshots
Here is a screenshot of the error.
To Reproduce
Steps to reproduce the behavior:
- Configure DevOps to use European date formats (2024-12-01)
- Create a query against the work items and use a date value
- See error
The wiql below was used
SELECT [System.Id], [System.WorkItemType], [System.ChangedDate], [System.Title], [System.Tags], [System.State] FROM workitems WHERE [System.ChangedDate] > '2024-07-07T00:00:00.0000000' AND [System.WorkItemType] = 'User Story' AND [System.State] = 'Closed' ORDER BY [System.ChangedDate]
I tried different formats like 5/7/2024 and 2024-07-05 and none of them works.
Even if I use the date selector through the UI I still get the same error. The editor must save the date value in some format the query engine can't understand. The wiql query looks fine including the date value (using ISO format).
Expected behavior
The query should work.
Additional context
Add any other context about the problem here.
Hi, I will take a look at it and get back to you.