Fog Creek Software
Discussion Board




Who's subscribed?

Is it possible to see who is subscribed to a given case?

Jim
Friday, December 13, 2002

SELECT sFullName from Person, Subscriptions where Subscriptions.ixPerson = Person.ixPerson and Subscriptions.ixBug = xxxx

Michael H. Pryor
Saturday, December 14, 2002

Not to be dense :-), but what tool are you using to issue SQL queries against the DB?

(We obviously have FogBUGZ installed an on XP machine, but aren't a windows shop - the server is the only windows box...)

Thanks,
Jim

Jim
Saturday, December 14, 2002

If you have SQL server installed, then you can use Enterprise Manager or Query Analyzer.  If you are using Access as your backend (the .mdb file) then you need access to open up the database.

Michael H. Pryor
Saturday, December 14, 2002

Thanks. I'll look into the access solution.

Jim
Saturday, December 14, 2002

We like a tool called WinSQL, http://www.indus-soft.com/winsql/ ; it runs against any ODBC DSN. It's really handy for quickly running queries.

David Thompson
Monday, December 16, 2002

*  Recent Topics

*  Fog Creek Home