You would define a query while browsing the Test Case Execution Record records. See http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m1/topic/com.ibm.rational.test.qm.doc/topics/c_tables.html.
There is also the My Tasks widget that can be used in the dashboard.
Bartosz Chrabski selected this answer as the correct answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means.
Learn more here.