SQL to search common Bug system?
I am interested to know if anyone is using DBSight to search their existing bug system.
Usually, bug system is also a good knowledge base. It has solutions, work-arounds, etc. It'll be nice if the bug system is easy to search, without the complicated "Advanced Search", which is done by SQL, slow and no ranking.
DBSight is an ideal solution to search on bug systems. Actually, DBSight's testing environment is a database of a high-volumn constantly changing bug system.
It'll be nice if anyone can send us the SQLs and templates he/she uses on some popular bug system, like Bugzilla, Mantis, etc. If it's really good, we would like to post it public and find a non-cash way to thank you, like get a free copy of DBSight, put your name with the template, or anything reasonable.