Take the 2-minute tour ×
Software Quality Assurance & Testing Stack Exchange is a question and answer site for software quality control experts, automation engineers, and software testers. It's 100% free, no registration required.

Quality Center allows filtering in the defects view.

Is it possible to filter on column1 = "value1" OR column2 = "value2", showing the union of the two filters?

share|improve this question

2 Answers 2

As I know there is no possibility with the built-in GUI filter function as all filter conditions are combined with AND. But you can help yourself with Excel reports and writing your own SQL statements. This is very helpful, especially if you like to do something more sophisticated like metrics.

A very minimalistic example would be following. It selects all tests, which are either 'ready' OR the responsible user is 'pfarrhor':

SELECT TS_NAME
     , TS_STATUS
     , TS_RESPONSIBLE
  FROM TEST
 WHERE TS_STATUS = 'Ready'
    OR TS_RESPONSIBLE = 'pfarrhor'

Details about the DB-tables and -fields you will find in the "Database Reference", which is linked on the page "Help / Documentation Library".

share|improve this answer

Yes this is possible.

I tried in the below way.

I logged into the defects module of XYZ project.

Made sure the below options are checked in the view tab.

Grid Filters Indicator Columns Favorite Bar

Carried the below steps

Click on Filter/Sort -> Set Filter/Sort

All the fields in the defect module are shown in the Filter condition tab

Each field has a filter condition.

I selected column1 with condition(value) 60. I selected column2 with condition(value) passed.

This returned only rows having column1 field as 60 and column2 field as passed.

Hope this helps.

Please feel free to extend discussion if not clear I will be happy to assist.

Thanks, Srihari

share|improve this answer
2  
If I understand correctly, this explains how to filter on column1 AND column2. If so, it does not answer the question, which is about column1 OR column2. –  Bernard Vander Beken Jan 4 '12 at 14:35

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.