Hi Marc,

Unfortunately you probably will have to reinvent the wheel .

As we understand you questions, you are interested in creating a kind of report on the technical metadata in the repository (like tables and columns) and combining it with functional descriptions of the different elements.

The function "Generate Diagram” in the Definer regrettably produces a fixed content. The other possibilities we offer to extract metadata (as you may already have found) are:

In the Definer: 

• Choose menu option "Tools”, menu item "Generate HTML reports ...”
• in SQL Commander, use the function "Repo meta ...”
• In SQL Commander, use the function “XML.SQLExport” to create a customized report on the repository tables (see: XML.SQLExport. This option offers you a lot of flexibility, but also requires a lot of "wheel reinvention” .

In the user application:

• Using the internal component "USMeta” (see: USMeta internal component). This component does not allow you to select additional metadata.
  In SQL Commander execute a statement like:
  
      INVOKE
         USMeta.Tables
      WITH
      SELECT
          'Yes'                        IncludeDatabaseTables
      ,    'application/json'    MimeType

Using USoft Blend:

• Using the Blend function "sql:DataTableSetExport” (see: DataTableSetExport)

Hopefully this gives you some avenues to explore, but at this point unfortunately there is no ready-made solution to what you want to achieve. Apart, of course, from writing your own queries on the repository tables (reinventing your wheel from scratch ;-)).

OK, thanks for the information!