search

microsoft / wiql-editor

Search work items with wiql queries.
https://marketplace.visualstudio.com/items?itemName=ms-devlabs.wiql-editor
MIT License
4 stars 1 forks source link

Error when querying with dates #45

Open johan-byggtjanst opened 1 month ago

johan-byggtjanst commented 1 month ago

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:

Screenshots Here is a screenshot of the error.

devops-Changed last 45 days-error

To Reproduce Steps to reproduce the behavior:

  1. Configure DevOps to use European date formats (2024-12-01)
  2. Create a query against the work items and use a date value
  3. 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.

AminTi commented 1 month ago

Hi, I will take a look at it and get back to you.