Violetta, In Oracle (and I assume other DB's) a "View" is a way to allow users to "See" specific data on a database without allowing them to "See it all" nor to change the data. It is "Realtime". By using SQL, I create a VIEW to RT Data. Meaning, a "psuedo-table".LEt's say I have 3 fields from table 1, 2 fields from table 2, 8 fields from table 3 that I want some users to see. I do NOT want them to see "other" information, nor do I want these users to be able to modify any of the table data. So, I create a "view" of these fields from the various tables and it is accessed much like one would access a table in a DataBase. Hence the term "View". Your DBA could tell you if your environment has such a thing. IF so, they can tell you how to create it. It is ALWAYS accessible (via userid and password) as long as the DataBase is up and the dat is NOT loaded, it is "filetered" so to speak. Think of it as a WINDOW to the DataBase. You can't see it all, you can only see what is specified. Hope this helps.
Kenn LBNL On 6/22/2009 2:03 AM, Violetta J. Wawryk wrote: > 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 _______________________________________________ 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