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

The community will undergo maintenance on October 16th at 10:00 PM PDT and will be unavailable for up to one hour.

Need help creating a query

Software
3-Visitor

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

ACCEPTED SOLUTION

Accepted Solutions
uminet
12-Amethyst
(To:Software)

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

View solution in original post

1 REPLY 1
uminet
12-Amethyst
(To:Software)

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

Announcements


Top Tags