Field Type: sys_class_name ??

[bbarnard]

How are the drop-down choices for Class field on cmdb_ci records populated? From the dictionary I see that the field type is 'sys_class_name' which I have used in scripts before to get the table that the record exists in. In the drop-down's I see other tables that extend cmdb_ci listed, and if I create a new table that extends cmdb_ci it is listed there as well.

Thanks,
Bryan

[CapaJC]

It's done on the back end in Java. A sys_class_name field will display existing classes in a "composite" (a set of tables that all extend from one base table, like cmdb_ci or task).

Are you looking to accomplish something specific?

[bbarnard]

thanks for the explanation! I don't have a use for it yet, but wanted to better understand how it worked and if I could use it in another table at some point.

[martijn3]

It would be nice to be able to limit the list of classes that you see in a lookup. Out of the box you get a huge amount of CI Classes that you will probably never use. The only options that I have seen so far are:
* Delete the CI table for the class that you don't want to see (just marking the collection as inactive doesn't do the trick unfortunately).
* Delete the appropriate record from the sys_db_object table.

[Mark Stanger]

You can de-activate the dictionary entry for a given table. That's probably the best solution.