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

[ning_zhang]

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.

[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 resourceworkflowstate.id = '{''id'':''' || testcase.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

[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.

[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): ​http://trac.edgewall.org/wiki/TracDev/DatabaseSchema

Ciao, Roberto

[Roberto Longobardi]

Hope you found this information useful.