Stack Overflow
Stack Overflow

Questions tagged [wiql]

Work Item Query Language

TFS Work Item Query Language is the syntax used by TFS work item queries

143 questions
0
votes
1 answer

Is there a way to save a WIQL query on the TFS Server?

Hopefully the title says it all. I've retrieved the results of adhoc queries using the WorkItemStore.Query() method and created Query objects via the new syntax. However after examining the object model for Query objects, QueryFolders, QueryItems…
Alby
  • 27
  • 3
0
votes
2 answers

TF51005 Query columns other than workitem properties listed?

I'm trying to run this query and it keeps throwing a TF51005 The query references a field that does not exist. Caused by the [Microsoft.VSTS.Common.Severity], I don't know how i'm suppose to pull the severity select [System.Id],…
Sewder
  • 754
  • 3
  • 11
  • 37
0
votes
0 answers

TFS Query using mode(mayContain) does not "return all top level work items" when run through API

I create a query in TFS 2013 as follows: Choose "Work Items and Direct Links" instead of "Flat List" Team Project = @Project Remove all other clauses for source work item. Remove all "Filters for linked work items" Select radio button "Return all…
pabrams
  • 1,157
  • 10
  • 34
0
votes
1 answer

How to get all valid fields for WIQL query using TFS API C#?

I found this: https://msdn.microsoft.com/en-us/library/ms244668(v=vs.90).aspx But I think that may be in regards to the database copy or something? I just need to know if there is a way I can get a list of all the valid fields that can go into a…
Sewder
  • 754
  • 3
  • 11
  • 37
0
votes
1 answer

WIQL: Compare source field with target field

I try to create a WIQL query that compares field contents of a work item and its related (linked) work items, e.g. where the 'state' of the work item is different from the 'state' of the related work item. SELECT [System.Id], ... FROM WorkItemLinks…
Heinz Kessler
  • 1,610
  • 11
  • 24
0
votes
1 answer

WIQL query to return all test cases that have attachments?

Here's my current code to return all the TFS Test Case work items that have attachments, from a specific project: public IEnumerable TestCasesWithAttachments(ITestManagementTeamProject project) { return …
Matthew Watson
  • 104,400
  • 10
  • 158
  • 276
0
votes
0 answers

How to get planned work programmatically for TFS iteration?

We are following Scrum process and I want to calculate how many PBIs were actually considered or added during each iteration of release? For e.g. on day 1 of Iteration1 I have 10 PBIs and added 5 more till last day of Iteration 1. So I should get…
Maddie
  • 69
  • 1
  • 7
0
votes
1 answer

Update to TFS custom field - optimization

I wanted to access TFS data via TFS API and WIQL using a custom field in WIQL where clause: string wiqlQueryDoorsProxy = "Select * from WorkItems where ([Work Item Type] = 'DoorsProxy' AND [Object Id] = '\" + requirementId + "\')"; where [Object…
JukkaAakula
  • 13
  • 4
0
votes
1 answer

Access to TFS proprietary fields gives error code TF51005 for WIQL query

We are using TFS2010. We have a solution - developed by IBM - that synchronizes data between DOORS and TFS. This solution has created proprietary work items (DoorsProxy) with some proprietary fields DoorsTool.DoorsArtifactType.Module. I think this…
JukkaAakula
  • 13
  • 4
0
votes
1 answer

TFS WIQL report upload on report server

Which UI control should be used to display data using C# TFS APIs (WIQL) so it can be uploaded on report server or can produce .rdl file?
Maddie
  • 69
  • 1
  • 7
0
votes
1 answer

Is there a way to select WorkItemLinks with the TFS Java API?

I'd like to use the TFS Java API to run WIQL queries on the workitemlinks. I know how to fetch WorkItems via the WorkItemClient, but it seems to be missing the functionality to fetch WorkItemLinks. On the other hand, client.supportsLinkQueries()…
Fabian Streitel
  • 2,702
  • 26
  • 36
0
votes
2 answers

How to fetch WorkItem links with the TFS Java API

We use the TFS Java API to fetch WorkItems from a TFS server: TFSTeamProjectCollection collection = TFSTeamProjectCollectionUtils .openTeamProjectCollection(serverUrl, credentials, new…
Fabian Streitel
  • 2,702
  • 26
  • 36
0
votes
1 answer

Querying workitem tfs sdk - Timezone must not be null

I'm creating a query using the SDK for Java. I want to get the ID from 2 days ago until today. String wiqlQuery = "Select ID from WorkItems where System.ChangedDate >= @Today-2"; WorkItemCollection workItems = workItemClient.query(wiqlQuery); I've…
Edson Martins
  • 78
  • 1
  • 2
  • 8
0
votes
1 answer

Team Foundation Server 2012 (WorkItem object does not contain „AssignedTo“ property)

Code snippet: string WIQL = "SELECT * FROM WorkItems WHERE [System.AssignedTo] = @Me AND [System.State] <> '400 CLOSED' ORDER BY [System.WorkItemType], [System.Id]"; List w = getWorkItemsAsList(_workItemStore.Query(WIQL)); I have found…
Prosinac Decembar
  • 73
  • 7
0
votes
1 answer

TFS Query: get only topmost elements assigned to me

I am trying to build a tfs query, which will return only the topmost items that are assigned to me. Examples: UserStory (US) is assigned to me and contains tasks that are assigned to me => query returns only the US US is assigned to someone…
scigor
  • 1,603
  • 5
  • 24
  • 38
1 2 3
…
9
10