Opened 7 years ago

Closed 6 years ago

#12236 closed defect (fixed)

Can't find any way to search test cases in a certain custom workflow state

Reported by: ning_zhang Owned by: Roberto Longobardi
Priority: normal Component: TestManagerForTracPlugin
Severity: normal Keywords:
Cc: Trac Release: 1.0


I have created a custom testcase reviewing workflow, and have several testcases in "under_review" state and assigned to "user1".

Now I want to search for all testcases which are in "under_review" state or are assigned to "user1", but how?

current result

Both the the filtering textbox above the tree view or Trac internal search enginee can't do this.

Attachments (2)

screenshot.PNG (18.1 KB) - added by ning_zhang 7 years ago.
screenshot2.PNG (47.9 KB) - added by ning_zhang 7 years ago.

Download all attachments as: .zip

Change History (6)

Changed 7 years ago by ning_zhang

Attachment: screenshot.PNG added

comment:1 Changed 7 years ago by Roberto Longobardi

Hi Ning, I'm glad someone out there actually uses the workflow engine (you're the first one I'm aware of)!

I guess the answer to your problem may be to create a specific report to list all test cases in a particular state.

You can create a new ticket report and use the following SQL query:

select 'wiki' as realm, testcase.page_name as id,  from resourceworkflowstate, testcase where resourceworkflowstate.res_realm = 'testcase' and resourceworkflowstate.state='under_review' and = '{''id'':''' || || '''}'

By omitting the resourceworkflowstate.state='under_review' you can list the test cases in any step of the workflow, or you may change the condition to filter a different state as well.

Let me know if this works for you.

Ciao, Roberto

Changed 7 years ago by ning_zhang

Attachment: screenshot2.PNG added

comment:2 Changed 7 years ago by ning_zhang

Hi seccanj,

Thanks for your quick response!

Yes I need a way to list all test cases in a particular state, and I have tried your SQL query, it can generate a report but included all test cases and every single testcase have 3 more duplicated items in the list....(A screenshot has been attached)

I've got your point and I will try to tweak the query to make the report shows correctly. Will feedback any progress if I have.

comment:3 Changed 7 years ago by Roberto Longobardi

Hi Ning, the repetitions are most probably related to the different versions of the wiki pages that stand behind any test case.

Refer to the Trac database schema for the Wiki table to tweak the SQL and get only version 1 of any wiki page (the generated link will anyway always refer to the latest version):

Ciao, Roberto

comment:4 Changed 6 years ago by Roberto Longobardi

Resolution: fixed
Status: newclosed

Hope you found this information useful.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Roberto Longobardi.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

E-mail address and name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.