Metadata Browser Companion
This companion tool in XrmToolBox allows you to view the properties
(metadata) of the tables, columns, relationships and keys (developed by
Tanguy Touzard).
With the out-of-the-box solution explorer, we can only see a limited
number of properties of those components (tables, columns, relationships
and keys). And we can only search through a list of tables or the list of
components within a table.
To query and search through all table definitions (metadata) within the
whole environment, you can use this tool to query all properties of the
components and copy the information from this companion tool on the side
panel to use in other tools.
- Tool Information
- Blog post
- Functionalities
- Search through the list of tables
- Check the Tables checkbox (Fig. 1, Pt. 1)
- Filter the list of tables by display name or logical name (Fig. 1, Pt. 2)
- Copy the table logical name, entity set (logical collection) name, and schema name by right-clicking on the table (Fig. 1, Pt. 3)
- View the properties of the selected table (Fig. 1, Pt. 4)
- Search through the list of columns
- Check the Columns checkbox (Fig. 2, Pt. 1)
- Filter the list of columns by logical name and filter further by table display/logical name (Fig. 2, Pt. 2)
- Copy the column logical name, schema name, and name for web API (e.g. _column_value for lookup) by right-clicking on the column (Fig. 2, Pt. 3)
- View the properties of the column (Fig. 2, Pt. 4)
- Search through the list of relationships
- Check the Relationships checkbox (Fig. 3, Pt. 1)
- Filter the list of relationships by logical name (Fig. 3, Pt. 2)
- Copy the schema name, Web API parent navigation property, parent navigation property with binding, and child navigation property by right-clicking on the relationship (Fig. 3, Pt. 3)
- View the properties of the relationship (Fig. 3, Pt. 4)
- Search through the list of keys
- Check the Keys checkbox (Fig. 4, Pt. 1)
- Filter the list of keys by logical name and filter further by table display/logical name (Fig. 4, Pt. 2)
- View the properties of the key (Fig. 4, Pt. 3)
- Additionally, the tool can refresh metadata from the environment if there is any update since the tool was opened (Fig. 1, Pt. 5)
- Similar Tools
Fig. 1 - Tables
Fig. 2 - Columns
Fig. 3 - Relationships
Fig. 4 - Keys
Comments
Post a Comment