Hi Kenn, I might not understand your concept. What does such a view look like? Our customner wants to check anytime which tickets are new, open and resolved which I thought is the quickest via browsing the RT. Of course I am happy to get more infomation about your views, but to be honest, in my opinion RT should offer me that requirement.
Regards Violetta Ken Crocker schrieb: > Violetta, > > I just thought of an idea, but it would require a bit of work. Why > not try create some views that have only the info you want these user to > see and then remove them from RT. They can still get to the RT info thru > the views, which SHOULD suffice, since they are gonna be creating > searchs and reports. I'm not sure how your infrastructure is where you > work, but we have many users that do NOT access RT, but create their own > SQL reports all the time thru the views. We're on Orcale, but I'm sure > the same concept is doable with other DB's. I even have some SQL that I > use to create the views. I'd be MORE than happy to send it to you and > you can modify the info as per your needs. They even have comments, > which you can't get to in RT Query. Just a thought. > > Kenn > LBNL -- Vorstand/Board of Management: Dr. Bernd Finkbeiner, Dr. Roland Niemeier, Dr. Arno Steitz, Dr. Ingrid Zech Vorsitzender des Aufsichtsrats/ Chairman of the Supervisory Board: Michel Lepert Sitz/Registered Office: Tuebingen Registergericht/Registration Court: Stuttgart Registernummer/Commercial Register No.: HRB 382196 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com