Where in the database can we find an item's custom fields information?

Author: Riya Ray

Date: June 25, 2025

Audience: Everyone

Environmental details: Self-hosted customers

Summary

The custom fields defined for an itemType live under the table documenttypefielddefinition. The following queries will help you retrieve the details of the custom fields defined for any item type.

Solution

This will pull up the details from both the tables (documenttypefielddefinition and documenttype):

select * from documenttypefielddefinition dtfd
left join documenttype dt on dtfd.documentTypeId = dt.id
where dt.display like '%<nameOfItemType>%';

 
OR, for a cleaner result

Step 1: To get the details of an itemType's custom fields, you would first need to retrieve its documentTypeId:

select id from documenttype where display like '%<itemTypeName>%';

Step 2: To retrieve the details of the itemType's custom fields, run the below query (substitute the id value in the following command):

select * from documenttypefielddefinition 
where documentTypeId = <itemTypeIdFromPreviousQuery>;

Additional Information/Metadata

• Item Management
• Custom fields

References

• Success Programs
• Success Catalog
• Datasheets
• Request a Solution Offering or Training from the Success Catalog

Please feel free to leave feedback in the comments below.