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

Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X

Need help creating a query

Software
10-Marble

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
13-Aquamarine
(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
13-Aquamarine
(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