Custom report that pulls tests with no steps or 1 step only

  • Questions
  • Custom report that pulls tests with no steps or 1 step only
Question ID: 107546
1
0

I would like to add a report that could pull results for tests in test plan that have either zero or 1 step only in them. Not sure of best method to attempt this as the regular project reports don't seem to have any filter option for such a thing.

Marked as spam
Posted by (Questions: 26, Answers: 22)
Asked on April 18, 2017 7:26 pm
3 views
Answers (1)
1
Private answer

Hello,

Your best bet for this would be to create a custom business view. In the project you want the results in, enter the project customization and select Business Views from the left hand list. Here you will see the default list of current business views. We will want to create a new one.

Steps:

At top, click on ''Add View'' button.

Add a label (more accurate name, descriptive) and Technical Name (short name, less descriptive).

Example name could be **''Tests with less than 2 steps**''

New screen will open for blank view. Add to the bottom, in the DQL window, below code:

Select test.id,
test.name,
test.subtype_id,
test.base_test_id,
test.exec_status,
test.status,
test.bpta_change_detected,
test.dev_comments,
test.creation_time,
test.description,
test.owner,
test.estimate_devtime,
test.storage_path,
test.protocol_type,
test.steps,
test_folder.name As test_folder,
test.parent_id,
test.template,
test.runtime_data,
test.service_test_mode,
test.working_mode,
test.last_modified
From test
Inner Join test_folder On test_folder.id = test.parent_id
Where test.subtype_id = 'MANUAL' And test.steps < 2 Once code is added, at top in the Query Designer tab, click on first ''Validate View'' and ensure it passes with no error. After then click on the Status drop down and change Not Published to Published. Then click on Save on top menu left option. Exit customization with saved changes. Now open excel and use the Business Views Excel add-in to view your business views for the project. If you don't have the add-in, can get it from the Tools option just like any other add-in. I generally just do ''New Report'' and get my list of business views from the connected to project via Add Worksheet pop up window. Here you would see your newly added view from the list. Select it and it will generate your desired output.

Marked as spam
Posted by (Questions: 1, Answers: 116)
Answered on April 18, 2017 7:31 pm
That is super easy. Thanks for the detailed explanation. I didn't know it was that easy to create custom business views. This will make me rethink a lot of the project reports that we trudge through. Business views might just be a heck of a lot easier.
( at April 18, 2017 7:40 pm)