Basically what you need to do to lock a table for everyone or at least make
the default selected something other than All:
- Open the JSP rendering the packages table. Look at it descriptor
so you know what the view ID is. You can cross reference this in the
database table TableViewDescriptor. Find out what it's ida2a2 is and write
it down, you'll need it in the next step.
- Inside the JSP, set on the tablemodel configurable=true to
configurable="false" if and only if you want to prevent users from
customizing the table altogether.
- Select and delete all entries from the ActiveViewLink table
matching that description. There is NEVER any harm in deleting these, all it
does it delete the user's last customized or default view used for that
table description.
- Create an insert sql statement that has a subselect for all
wtuser rows. For each wtuser, you will insert an entry into the
activeviewlink table that associate an tableviewdescriptor (and its ida2a2)
with a wtuser. (This effectively is the same as every user logging in,
going to that packages table, and changing your selected view to something
other then the default.
If you need more help on exact specifics, I can guide you a little more when
I'm actually in front of a Windchill system.
I have done this before, it is quite sweet and could be "scripted" Keep
in mind the view does has to be visible to everyone i.e. share with all
users must be checked or java code must be written to define a new one as
stated in Customizer's Guide.
Dave DeMay
%201.jpg){kind=link}
