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:

This is the definition for the second statement:

This is the definition for the third statement:

These are the default columns:

Best answer by uminet

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

Answer

13-Aquamarine

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

Sign up