When I create a query and select the Status field as a condition I see
all the states for each Work Item type as well as the Unresolved and
Resolved checkboxes. When I check any of the states, the query
result is correct.

However, when I check Unresolved box, the query returns everything,
including the records in Closed states. When I switch to
"Status in not" and check Resolved, it works and returns
all records not resolved. These basically are the same queries.

Where should I look to see why it's including Closed as Unresolved in
my queries? Is this somewhere in the Workflow definitions?

You can check if the states were configured for the correct state group
in the 'Workflows' section of the process configuration:

http://dl.dropbox.com/u/2663305/ScreenShots/2010-01-26_1522.png

--
Regards,
Patrick
Jazz Work Item Team

I checked the Workflows section and and the Closed state group is selected, but they're still appearing under Unresolved. The only Work Item type that works correctly is one I created.

I created Defect 105522 because it seemed very close to resolved Defect 88253. Below is my Defect Workflow:





<configuration-data xmlns="http://com.ibm.team.workitem/workflow" id="com.ibm.team.workitem.configuration.workflow">
<workflowDefinition id="com.ibm.team.workitem.defectWorkflow">
<workflow description="This workflow is appropriate for defects." name="Defect Workflow" reopenActionId="com.ibm.team.workitem.defectWorkflow.action.reopen" resolveActionId="com.ibm.team.workitem.defectWorkflow.action.a1" startActionId="com.ibm.team.workitem.defectWorkflow.action.confirm">
<resolution icon="processattachment:/workflow/unconfigure.gif" id="r4" name="Unreproducible"/>
<resolution icon="processattachment:/workflow/wontdo.gif" id="r3" name="Works as Designed"/>
<resolution icon="processattachment:/workflow/duplicate.gif" id="r2" name="Duplicate"/>
<resolution icon="processattachment:/workflow/close.gif" id="r1" name="Fixed"/>
<resolution icon="processattachment:/workflow/red.gif" id="r0" name="Usage Error"/>
<resolution icon="processattachment:/workflow/reiterate.gif" id="r8" name="Environmental"/>
<action icon="processattachment:/workflow/open.gif" id="com.ibm.team.workitem.defectWorkflow.action.stopWorking" name="Stop Working" state="s1"/>
<action icon="processattachment:/workflow/open.gif" id="com.ibm.team.workitem.defectWorkflow.action.confirm" name="Open" state="s1"/>
<action icon="processattachment:/workflow/resolve.gif" id="com.ibm.team.workitem.defectWorkflow.action.a1" name="Resolve" state="s2">
<resolution id="r1"/>
<resolution id="r2"/>
<resolution id="r8"/>
<resolution id="r3"/>
<resolution id="r4"/>
</action>
<action icon="processattachment:/workflow/reiterate.gif" id="com.ibm.team.workitem.defectWorkflow.action.a2" name="Returned" state="s3">
<resolution id="r8"/>
<resolution id="r2"/>
<resolution id="r1"/>
<resolution id="r4"/>
<resolution id="r0"/>
<resolution id="r3"/>
</action>
<action icon="processattachment:/workflow/inprogress.gif" id="com.ibm.team.workitem.defectWorkflow.action.a3" name="Start Working" state="com.ibm.team.workitem.defectWorkflow.state.s7"/>
<action icon="processattachment:/workflow/verify.gif" id="com.ibm.team.workitem.defectWorkflow.action.a4" name="Verify" state="com.ibm.team.workitem.defectWorkflow.state.s8"/>
<action icon="processattachment:/workflow/reopen.gif" id="com.ibm.team.workitem.defectWorkflow.action.reopen" name="Reopen" state="s6"/>
<action icon="processattachment:/workflow/close.gif" id="com.ibm.team.workitem.defectWorkflow.action.a5" name="Close" state="s2"/>
<state group="closed" icon="processattachment:/workflow/close.gif" id="s2" name="Closed" showResolution="true">
<action id="com.ibm.team.workitem.defectWorkflow.action.reopen"/>
</state>
<state group="open" icon="processattachment:/workflow/open.gif" id="s1" name="Open" showResolution="false">
<action id="com.ibm.team.workitem.defectWorkflow.action.a2"/>
<action id="com.ibm.team.workitem.defectWorkflow.action.a3"/>
<action id="com.ibm.team.workitem.defectWorkflow.action.a4"/>
<action id="com.ibm.team.workitem.defectWorkflow.action.a5"/>
</state>
<state group="open" icon="processattachment:/workflow/reopen.gif" id="s6" name="Reopened" showResolution="false">
<action id="com.ibm.team.workitem.defectWorkflow.action.a2"/>
<action id="com.ibm.team.workitem.defectWorkflow.action.a3"/>
<action id="com.ibm.team.workitem.defectWorkflow.action.a4"/>
<action id="com.ibm.team.workitem.defectWorkflow.action.a5"/>
</state>
<state group="inprogress" icon="processattachment:/workflow/reiterate.gif" id="s3" name="Returned" showResolution="true">
<action id="com.ibm.team.workitem.defectWorkflow.action.reopen"/>
<action id="com.ibm.team.workitem.defectWorkflow.action.a5"/>
</state>
<state group="inprogress" icon="processattachment:/workflow/verify.gif" id="com.ibm.team.workitem.defectWorkflow.state.s8" name="Verify" showResolution="false">
<action id="com.ibm.team.workitem.defectWorkflow.action.reopen"/>
<action id="com.ibm.team.workitem.defectWorkflow.action.a2"/>
<action id="com.ibm.team.workitem.defectWorkflow.action.a5"/>
</state>
<state group="inprogress" icon="processattachment:/workflow/inprogress.gif" id="com.ibm.team.workitem.defectWorkflow.state.s7" name="Working" showResolution="false">
<action id="com.ibm.team.workitem.defectWorkflow.action.stopWorking"/>
<action id="com.ibm.team.workitem.defectWorkflow.action.a2"/>
<action id="com.ibm.team.workitem.defectWorkflow.action.a4"/>
<action id="com.ibm.team.workitem.defectWorkflow.action.a5"/>
</state>
</workflow>
</workflowDefinition>