topic Resetting table views to ootb in Windchill

Resetting table views to ootb

vmcdaniel — Wed, 02 May 2018 14:25:28 GMT

Anyone have a method to reset a table view to ootb settings?Or import export?Specially the ALL in the affected objects?I attempted to remove the disposition columns, and the comments column goes too, and is not selectable to add back in.-VaughnSent from my mobile.

Resetting table views to ootb

avillanueva — Tue, 27 Aug 2013 17:35:35 GMT

I believe tech support has this method. Check with them.

Resetting table views to ootb

SimonHeath — Tue, 27 Aug 2013 19:05:35 GMT

The customization guide shows some rather dangerous SQL to do this however if you know the table id this is better

DELETE FROM TableViewDescriptor WHERE TABLEID='xxxxx';
DELETE FROM ActiveViewLink WHERE TABLEID='xxxxx';
commit;

One easy way to find it is to create a new view in the UI, then check these tables and sort by the last updated column.

Here is my DB using DB Visualizer

BR
Simon

-----Mensaje original-----

RE: Resetting table views to ootb

Sriram_Rammohan — Wed, 28 Aug 2013 11:40:40 GMT

Deleting Table View from DB (2 sql's u mentioned)does not harm ur system. Ill be restored after Windchill Restart.

Resetting table views to ootb

MikeIbosh — Wed, 28 Aug 2013 11:42:30 GMT

True, but any custom table views will be lost.

Mike

Resetting table views to ootb

ddemay — Wed, 28 Aug 2013 13:57:35 GMT

I requested long ago to make custom derived views these exportable and
importable - fell on deaf ears and blind eyes.

Resetting table views to ootb

mkraegeloh — Wed, 28 Aug 2013 14:23:01 GMT

some of the changes (column order or hiding) are stored in the browsers local storage ...
try in javascript console:
for(var x in localStorage)
if(! confirm(x+"="+localStorage[x]))
break;

martin