64
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).
Category: Development
STATUS DETAILS
Needs Votes
Ideas Administrator

Thank you for your feedback. We are considering adding it to our longer term roadmap, please keep voting for this.

We have a related request to include extension origin in IntelliSense for a field. That is inline while developing, but would not support querying (for VSIX extensions) or see all fields for a given extension, what is more useful?

Your help is greatly appreciated,
Business Central Team

Comments

S

Both are needed.

The challenge right now is we need a summary view of where all our extension fields reside (our extensions are modular so our app is spread out across several extensions). Simple VS Code intellisense enhancements won't address this. What the AL Language Extension needs is a Field Viewer so when I open an .alpackages application symbol file in VS Code, it'll list all the fields present in that symbol. The application symbol viewer also needs an export to CSV feature (both for fields and objects). Another issue is that viewer can only view one application symbol .app file at a time. It would be helpful if there were a command pallete to show all objects from all downloaded symbols without opening up one .app at a time (our core extension depends on 20 other boilerplate extensions)

By augmenting VS Code enhancements with a new Virtual table in Business Central itself, we can do our own field analysis via reports and pages with the help of a virtual table. The problem with the virtual table approach is our extension needs to be published and installed for it to be useful (not helpful for fields still in the development pipeline). So adding this kind of visibility in both BC and VSC are equally important.

Category: Development

S

Both would be helpful, but the support to query would be best for our needs.

Best regards

Category: Development