cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Need help creating a query

SOLVED
Highlighted

Need help creating a query

I have created a query that displays Defects for a project and their related change requests and I am having a problem.

I would like the query to display all Defects for the project whether or not they have related change requests - An Unmatched query.

The problem is that the query will only display Defects that have spawned change requests.

Any help anyone can provide would be greatly appreciated.

Thanks, Ginny

This is the definition for the first statement:

querydeffirststatement.GIF

This is the definition for the second statement:

querydefsecondstatement.GIF

This is the definition for the third statement:

querydefthirdstatement.GIF

These are the default columns:

querydefdefaultcol.GIF

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Need help creating a query

Hello,

I assume that the problem is the second statement in combination with the AND filters when following a relationship.

If you want to see all defects of a specific project you should start with a simple query like "Type = Defect AND Project = xxx".

(Or, for a start, disable the second statement and look at the result)

Hope that it helps

1 REPLY 1

Re: Need help creating a query

Hello,

I assume that the problem is the second statement in combination with the AND filters when following a relationship.

If you want to see all defects of a specific project you should start with a simple query like "Type = Defect AND Project = xxx".

(Or, for a start, disable the second statement and look at the result)

Hope that it helps