index > Team Foundation Server - Work Item Tracking > 'Custom' parameters in queries

'Custom' parameters in queries


Hello,

Is there a way to add a custom parameter to a query so it will be prompted to the user when he/she double-click the query to open it.

To give you more details, we are looking for creating a query that will accept a list of work item IDs and return all the issues that matches these IDs.

A convenient way will be for us to specify this kind of condition when building the query:

...

And ID In @myIDList

...

We tried that, but it seems to be not supported.

Thanks for your help,

Gaetano.

GDigrego

Unfortunately this is not supported.

Thanks,

Alex

Aliaksei Baturytski - MSFT

OK.

Any chance you will add this feature in a future release? I will vote for it if this is the case.

Thanks,

Gaetano.

GDigrego

The ability to specifiy query parameters that would prompt for user input on query execution is already being considered for a future release.

Just so I understand more fully why you want this feature, can you provide examples of how you would use this feature?

NOTE: Any future readers of this forum posting are welcome to provide their examples as well.

Thanks!




Team Foundation Server
Gregg Boer MSFT

Great.

My first example will be to be able to create a query that will prompt for a list of IDs (comma separated for instance) and that will return the corresponding work items as the result.

GDigrego

I'd like to vote for this feature too. The first and foremost use of this for me would also to be to type in a work item ID (although, I'd be happy with entering just one ID - but a comma separated list would be fine too). There may be other things that would be nice to be able to prompt for as well (like the username for the assigned to, etc.), without needing a separate query.

-Daniel

Daniel_Bowen

Daniel,

A colleague just discovered that the "ctrl + g" keyboard shortcut allows you to jump to a work item by prompting for the item ID. Hope this help

I would like also to add another example of a query with custom parameters: specifying a query that will prompt for some text to find in work items description field.

Gaetano.

GDigrego
I was trying to do this today as well... Mainly to provide equivalent functionality to the current support system being used.
William Bartholomew

Responding to the last few posts...

The input you've provide is great. Its helpful to know *why* you would use a feature, so we can implement it correctly.

I'll make sure that this information is logged, so when we implement this feature we have this supporting customer evidence.

Thanks again,




Team Foundation Server
Gregg Boer MSFT

Our current environment provides an almost query by example filtering to allow searching work items. They could filter by root cause, area, environment, practically anything and I believe this is useful because different users will have different filtering requirements. For example, someone might decide that they want to knock over a heap of small issues and filter by the estimated time.

Similar functionality to what is available in Reporting Services for providing parameters would be ideal.

William Bartholomew
I would like users to be able to search for a list of resolved work items by build number - which would be specified by them.
DQM
This is great input on how you would use this feature! Keep this kind of information coming! It really helps.


Team Foundation Server
Gregg Boer MSFT
reply 12

You can use google to search for other answers

 

More Articles

How to autofill field value from other field value during transit...
What Is the Difference Between a Task and a Work Item
How to Import/Export WorkItems in TFS-RTM
Work Item Classification and Project Hierarchy
Entering Work Items Thru Project Portal Page
Contents of Dropdowns not read only?
Where is the Authoring Work Item Types.doc?
MS Project stops leveling after getting of TFS work items
How to get the email body from an email using pop3 adapter
Getting Email body part from an email using pop3 adapter
Welcome to Bokebb   New Update   Joins the collection  
 

New Articles

Web Bug Tracking for TFS
How to allow to modify a field during sp…
Problem logging in Team Foundation Serve…
Implementing ExecuteDefaultAction
MS Project synchronization
Unhelpful witexport errors. What's actua…
How to adjust the height of a field.
Extending Upload Documents Functionality
Limit the allowedvalues list by validuse…
Email notifications for other bugs than …
How to autofill field value from other f…
How do I specify dependancies (and impor…
Is there any way to assign two resources…
Estimate Extensibility
Customized Fields on WorkItemChangeEvent

Hot Articles

Synchronizing workitems with 3rd-party d…
Build Integration clarification
MS Project Integration and Assigned To F…
Subscribing to events
Getting Email body part from an email us…
Work items problem
Set new field - Owner inside of WI and p…
Creating a Custom query programmatically…
MS Project stops leveling after getting …
VS 2003 client plugin to TFS
Exception using TFS client in Web App
workitem issues after upgrade to RTM
No way to update AreaPath dropdown throu…
Can't browse work items
Work Item Add/Updates Not In Reports

Recommend Articles

Problems in mapping fields into project
Query for all items that've had been ass…
Description query fails when trying to r…
Methodology for publishing work items
How can I add a work item whose type is …
Managing project and resource names
Opening WI Attachments Requires Username…
Query Date-Time granularity
More Resources
How do I specify dependancies (and impor…
Customize the history tab to give more i…
End Date for Iterations
TFS VersionControl SQL transaction Log S…
Start Date is read-only from MS Project
Adding Areas and Iterations via the obje…