67
Table 2000000207 "Application Object Metadata" can be used to determine what extension app a table lives in.
However, there is no such virtual table at the field level. If I want to know what app “owns” a field (either in a table object or a table extension object in an app), there are no system tables I can use to quickly determine that.
Currently the only way around this is to interrogate the Application Object Metadata table records and parse it’s XML metadata record-by-record. This workaround is not very performant , especially when the metadata table can have thousands of records and developers will want to filter against that result set.
An “Application Field Metadata” table would make life much easier for the developer community. Discovering what fields live in what app is currently a very tedious process from VS Code (especially for more complex tenants who have 20+ extensions installed).
However, there is no such virtual table at the field level. If I want to know what app “owns” a field (either in a table object or a table extension object in an app), there are no system tables I can use to quickly determine that.
Currently the only way around this is to interrogate the Application Object Metadata table records and parse it’s XML metadata record-by-record. This workaround is not very performant , especially when the metadata table can have thousands of records and developers will want to filter against that result set.
An “Application Field Metadata” table would make life much easier for the developer community. Discovering what fields live in what app is currently a very tedious process from VS Code (especially for more complex tenants who have 20+ extensions installed).
STATUS DETAILS
Needs Votes
Business Central Team (administrator)