Do you want to post your code somewhere so we can have a look at the sql statement? i have written 2 or 3 dashlets that i can adapt to maybe do what you want. If i understand you want to see all incidents from all users in one window? What columns do you need in this dashlet? Something like "id, Title, owner, status"?
Plugin Developer, Contributor, Tester, Obscure Bug Finder
aka "The Bushman", aka "NiceDev"
Life is too short to worry about the things you don't have or cannot do...