How can I get the fields a View contains?

M

Marco

Does any one knows how can I get the fields a view contains? I tried to
figure out a query in the SQL Server database but couldn't do it.

I´m trying to clean up all the enterprise fields that are not used any more
by any view.

Thanks
 
M

Marco

Yes Kevin, but the organizer just tells me what the fields are but doesn´t
tells me wich view they belong to. I´m just want to be sure I´m not deleting
a field that is being used by a custom view.

"Kevin W Flanagan" escribió:
 
D

Dale Howard [MVP]

Marco --

Microsoft Project defines a View as follows:

View = Table + Filter + Group + Screen

Based on the above, you will be most concerned about deleting custom Fields
that are contained in custom Tables, plus perhaps custom Filters and Groups,
if you created custom Filters or Groups. Focusing on custom Tables, you
will probably want to do the following:

1. Open the Enterprise Global for editing
2. Click View - Table - More Tables
3. Select the Task option at the top of the dialog
4. Select your first custom Table and click Edit
5. Examine the list of fields and look for custom fields
6. Click Cancel
7. Repeat steps 4-6 for each custom task Table
8. Click the Resource option at the top of the dialog
9. Repeat steps 4-6 for each custom resource Table

After ascertaining whether any custom Tables contain custom Fields, you can
safely delete those that do not using Tools - Organizer (while the
Enterprise Global is open for editing). If you created any custom Filters
or Groups that might contain custom Fields, perform a similar process for
each of them as well. Hope this helps.
 
D

Dean

Marco,
Once you get it cleaned up, you may want to create and maintain an Excel
file that contains View definitions, consisting of the standard view
definition information plus sort criteria, the purpose of the view, who needs
to see it etc. In the same Excel file, document your custom fields, tables,
groups and macros.
 
Top