How do I create a link in a global cmdb_ci form to a table created by a scoped application?

[clemens]

Before there were scoped applications I could login as admin, bring up the form and add a section with the content of another table and its fields. For example, I have a table with server details, model, make, hardware specifications etc. and instead of entering it manually into each cmdb_ci_server record, I just pick one from the list of predefined configurations and all details will be displayed from the reference table (read only) and the only linkage I have in the cmdb_ci_server is the unique identified for the item in the reference table.

With Geneva, I have a scoped applications creating the reference table. When I now login as admin in the global scope I can still change the form for cmdb_ci_server or any other cmdb_ci form but when I try to configure the form, none of the scoped application tables or fields show up. So I can create another Section but I cant get a selection box with the reference data into that section nor can I see any of the data from the scoped application table. Its like that scoped application table does not even exist.

Ideally I would like multiple sections in the cmdb_ci forms pointing to multiple tables in the scoped application for different purposes:

1. For reference data purposes, so you pick one element and the other values are displayed read only from the scoped application table.

2. For configuration data purposes so you have a section with some additional form fields that are stored within the tables of the scoped application along with the ID of the cmdb_ci... record. For example IP addresses, network protocols, username etc. While some can be kept in cmdb_ci_... table fields its not ideal as you have to verify each table rather than going to a single place for the information and put it all into one table, provided by the scoped application.

I tried reference fields - but scoped application tables dont show up in the list of available items. Is there a way to do this in Geneva with a scoped application from a 3rd party vendor?

[Pradeep Sharma]

Hi Clemens,

If I understand your question correctly then you have created a section in one of the system table. Post which you are not able to create a reference field which references to scope app table and do dot-walking..Is this the issue?

Can you please confirm. Sorry If I missed any thing

[clemens]

Pradeep, thanks for your answer but I dont think thats the problem. Let me give you the details. I have a scoped application, this application includes a table. When you install the application, the table is created as for example "x_t44t_tier44_em_8_par4_certificate" under the application scope and shows up in the system tables. This table contains reference information about servers like peak power consumption, efficiency metrics, cpu count, memory, disk details etc. plus information about manufacturer, make, model, version and so on.

As a global scope admin user (not an application developer of the scoped app) I want to add a section to the cmdb_ci_server form that lets me select a single entry from the   "x_t44t_tier44_em_8_par4_certificate" table and display the associated details read-only.

On fuji with an update set it looks like this, after creating a "Tier44" section:

and the associated server configuration looks like this and you can see the green "PAR4" field selector and the fields on the right.

So in this case I can add the fields and everything works fine.

When I create the same PAR4 table on Geneva with a scoped application, I cant find "PAR4" in the available fields for the form. Instead the configuration of the server form looks like this

I want to create the linkage outside of the application, so I pick "global application" and I can create the "PAR4 Details" section but I cant find the table or fields form the scoped application. So in the end I get an empty section in the form design like this.

And the PAR4 fields are nowhere to be found.

How do I link the table from the scoped application into the server form? This is rather strange as it came up correct when I use the update set on Geneva, just with the scoped application its not working.

Any help would be much appreciated.

Thanks, Clemens

[clemens · Accepted solution]

Pradeep just walked me through the integration of a scoped application table into a system table and here is how its done:

When in the "configure server form" you do the following:

1. Create the section you want, add and save

2. IMPORTANT: Create a field with the name, e.g. in this example, "PAR4 Data" with type "Reference" and pick your table "x_t44....." that you want to refer to, add and save

3. Go back into the form layout, pick your section and you now get the green PAR4 group as an available item. Expand it to see all fields and add as needed.

This allows you to link the scoped application table to any cmdb_ci table you want.