Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

SD 5.0 and views

Highlighted
bad
Regular Collector

SD 5.0 and views

hello
In what db table information about all views is saved ?
Thanks
3 REPLIES
George M. Meneg
Honored Contributor

Re: SD 5.0 and views

Hello nera,

In 4.5 views are java objects. I think the same should also stands for sd 5.0. In 4.5 the table is rep_javaobjects, look for a table with a similar name to be sure.
menes fhtagn
bad
Regular Collector

Re: SD 5.0 and views

SELECT [jav_instance], [jav_entity], [jav_lockseq], [jav_oid], [jav_tem_oid] FROM [hpsddb].[hpsd50].[rep_javaobjects]
:( empty
George M. Meneg
Honored Contributor

Re: SD 5.0 and views

Hello,

I was wrong. The views are stored in three tables in service desk 4.5

REP_VIEW_ACCESS
REP_VIEW_TITLE_INFOS
REP_VIEW_TITLE_LOCALE

however I don't know where or how the filter definitions are stored.
menes fhtagn
//Add this to "OnDomLoad" event