KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Field type attribute values in catalog.4DCatalog
PRODUCT: 4D | VERSION: 19 | PLATFORM: Mac & Win
Published On: June 26, 2023

In a project application, the catalog.4Dcatalog is an XML file that stores the information of all tables and fields for the database structure. Each field node has an attribute called “type” that corresponds to the type of the field (Text, Date, etc.). The value of “type” does not explicitly state the name of the field type. Instead, the field type is indicated by a “number” (in quotes because the value is actually a string) in the XML. Below is a reference table that maps the “number” to actual field type:



This could be useful, for example, when manually reviewing catalog.4dCatalog during a git merge conflict. Note that Alpha and Text field types are both 10. The difference is that alpha fields have another attribute called “limiting_length” set to “255”.