Table Name data type for ci class

[Community Alums]

Hi,

I created custom table and one column in it named CI Class with type table name. Now I should select only table names which are extensions of cmdb_ci table in that column with table name type. Can someone help me how to achieve this.

Thanks

[-O-]

This can be achieved using dictionary attributes. Have a look at field Child Table (child) of table CI Relation Filter (cmdb_rel_filter). It sports the necessary dictionary attributes:

note that the Dictionary Entry form needs to be in Advanced view - OOB only in that view the Attributes field is shown. Alternatively you can add the same attributes in related list on the same form even if in Default view:

[OlaN]

Hi,

It seems like using the field type Table Name has some limitations, it doesn't allow you to filter the list, it just shows all available tables in the instance.

A workaround, would be to instead create a field that is of type Reference, and have it reference the Table table, sys_db_object (..yeah, that sounds weird).

Then you can create your reference qualifiers as you want, for example name starts with cmdb_

[-O-]

As far as I understood the OP, the data type is Table Name, not Reference.

[Sagar Pagar · Accepted solution]

Add table_name field attributes as below.