Skip to main content
V
vmcdaniel1-Visitor
1-Visitor
August 27, 2013
Question

Resetting table views to ootb

  • August 27, 2013
  • 6 replies
  • 2529 views
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.

6 replies

avillanueva
avillanueva23-Emerald I
23-Emerald I
August 27, 2013
I believe tech support has this method. Check with them.
S
SimonHeath1-Visitor
1-Visitor
August 27, 2013
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-----
S
Sriram_Rammohan1-Visitor
1-Visitor
August 28, 2013

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

M
MikeIbosh1-Visitor
1-Visitor
August 28, 2013
True, but any custom table views will be lost.

Mike
D
ddemay1-Visitor
1-Visitor
August 28, 2013
I requested long ago to make custom derived views these exportable and
importable - fell on deaf ears and blind eyes.






M
mkraegeloh1-Visitor
1-Visitor
August 28, 2013
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

Terms & ConditionsAccessibility statement