Query against multiple users at the same time.

[ryabenne]

Trying to run a single query on the dashboard based on open/assigned tasks against multiple users at once.

 

I can query against user 1, no problem (2 tasks assigned)

I can query against user 2, no problem (2 tasks assigned)

 

However, when I query against both users at the same time I can't get all of the open tasks (4 total) that should show up as expected.

 

Below is my query that I'm attempting to use. I've tried "AND" in various spots but nothing seems to work.

((Owner.UserName = "[e-mail]") OR (Owner.UserName = "[e-mail]") AND (State != Completed))

 

Thanks for your time,

 

Ryan

[bulmi01]

Ryan,

 

The paranthesis rules can get you in these types of queries.

 

You will need to just update your query to be:

 

(((Owner.UserName = "[e-mail]") OR (Owner.UserName = "[e-mail]")) AND (State != Completed))

 

Here is the information from this help page:

 

You can add as many conditions as you need. Parentheses rules may be different than what you expect. For each condition that you add, you need to put a new ( at the beginning, and each condition after the first must end with )). For example:

((((Project.Name = "Blue Team") AND (Owner.UserName = "[e-mail]"))
 AND (Iteration.Name = "October Phase One")) AND (Tags.Name = "Critical"))

 

Hope that helps!

 

Michael

[ryabenne]

Michael,

 

I thought that was the case as well yesterday but when I apply that query I get no value returned...only an error that states the following:

 

"Based on your selections, no work item data was found."

 

Ryan

[Sagi Gabay]

Hi Ryan,

 

I just tried what Michael suggested and it worked, but there are double quotes around the 'Completed' that are needed. The convention is:

 

(((A) OR (B)) and (C))

 

Where

A = Owner.Username = "UserName1"

B = Owner.Username = "UserName2"

C = State != "Completed"

 

Together it gives you:

 

(((Owner.Username = "UserName1") OR (Owner.Username = "UserName2")) AND (State != "Completed"))

 

 

Can you copy this and try. If not working, please send us a screenshot of the error.

 

Thanks,

Sagi

[ryabenne]

Sagi,

 

Thanks for info. I fixed the error and yes that's what I've tried last night but it only gives an output of 2 tasks not 4 that I actually need to track.

 

Ryan

[ryabenne]

It is showing the "user1" info or "user2" info...depending on who comes first within the statement you placed above, but not both at the same time.

[Sagi Gabay]

Here is what it looks like for me. You can see the query, then you see the results in the Custom List app, where I have a list that includes tasks of both owners. (I only erased the usernames used as this is a public page)

 

Can you please share these same screens so we see your query and results.

 

Thanks,

Sagi

 

 

[ryabenne]

Yes, I can see that as well but I only see 2 tasks where I should really see 4 total because each user currently has 2 assigned to them.

 

Are you possibly free to run a webex session to assist?

[Sagi Gabay]

Thank you for opening that support case. I took ownership of that case and replied to you about webex times. Let's continue there.

 

Thanks,

Sagi