How To Get A List Of All Your Custom Fields

Have you ever wanted to know how many Custom fields you have in your system, when they were created or what is the data type of each one?

You can get a full list of all the Custom fields that you have in the system using a simple query as shown below.

The query will call a predefined, Table-Valued function for us called MFN_Epm_GetAllCustomFieldsInformation().

For this blog I am going to query the Custom Fields Names , Lookup Table Members View Names, Data Type and Lookup Table that have MultipleLevels.

 

SELECT a.CustomFieldName

,a.LookupTableMembersViewName,

a.LookupTableHasMultipleLevels,

a.DataType

FROM MFN_Epm_GetAllCustomFieldsInformation() as A

WHERE EntityName = ‘Project’

 

If you execute the query you will get a list of your Project Level Custom fields where you can change the Resource, Task, Assignment and Timesheet custom fields by change the EnitityName value in the query.

Hope you found this blog useful.

Hungry for more?

Would you like to learn more about how to effectively use Microsoft Project, Microsoft Project Server, or Microsoft Project Online to manage your projects? If so, please consider enrolling in one of our upcoming open enrollment training classes at the following URL:

http://www.epmainc.com/epma-institute/course-listing

You can take our training classes “in person” in our EPMA training center in Houston, Texas or “live-virtual” over the Internet.

…And don’t forget to follow us on Twitter, LinkedIn, and Facebook.