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

This is part of the #TooLDR series where I test and review the tools for Power Platform. You can check out the information for the other tools on this page.

Comments

Popular Posts