Reference Qualifier for Table Name field

DrewW
Mega Sage
Mega Sage

So I have been looking for a way to filter a field that has the type of "Table Name" to only show tables that are an instance of CMDB and I'm not finding a way to do it.

I tried "nameINSTANCEOFcmdb" but that did not work.

Anyone have any thoughts on this?

1 ACCEPTED SOLUTION

The system does not show the fields on the form.  I'm/was hoping that I could find a way to do it.

Right now I'm using a reference field to sys_db_object then I used the Ref Qual of "nameINSTANCEOFcmdb".  Just not a fan of how it came out.

View solution in original post

16 REPLIES 16

Community Alums
Not applicable

Adding the solution for any future visitors of this post:

 

On the dictionary entry for a field of type 'Table Name', you may specify two attributes. 

Attribute labelAttribute nameValueDescription
Base tablebase_tableTable name (e.g. cmdb_ci_computer)This specifies the table from which all valid choices are extended
Skip rootskip_roottrue | false

If true, the base table will be excluded from the list and only extended tables are presented. 

If false, the base table is included. 

 

See Dictionary Attributes for official documentation. 

 

The Transform Map table has a great example of this behavior OOB. 

2023-10-25_18-22-23.png

 

Geni
Tera Contributor

Not sure if anyone is still looking for this but the skinny answer to it is add the following Dictionary Attribute:

tableChoicesScript

Where the Value is the name of the name of a Script Include

The Script Include MUST have a method called process (this is what this attribute calls)

The expected return of the method is an array of table names you want to show.