Resetting table views to ootb

[vmcdaniel]

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.


-Vaughn
Sent from my mobile.

[avillanueva]

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

[SimonHeath]

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-----

[Sriram_Rammohan]

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

[MikeIbosh]

True, but any custom table views will be lost.

Mike

[ddemay]

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

[mkraegeloh]

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