Extended Tables - Parent/Child
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2022 11:31 AM
The OOB Business Application (BA) table does not contain a field for all of the information that we are collecting. We are trying to stick with best practices and not add custom fields directly to the Business Applications table. Instead, we have created an extended/child table off of the BA table. The problem that we are now facing is that we cannot dot walk/add fields from the extended/child table to the BA table so the data is on two different tables. To support several processes in development, we need to be able to access all of the needed data from the BA table. Is there anyway to accomplish this without adding custom fields directly to the BA table?
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2022 12:47 PM
Instead of extending the BA table, create a new related table.
Table Name: Business Applications Additional Info
Fields:
Business Application (make this a reference field to the BA table) *this step is very important
Add all your other custom fields.
Once created, add this as a related list to the Business Application table.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2022 12:50 PM
Because of the importance of the Business Application table for CSDM and how products utilize that table, I would not recommending extending the cmdb_ci_business_app table.
As part of your Tech Governance, you would want to evaluate the value of any new field versus development, manageability, usability, etc.