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.