Reference qualifier on table_name type field

Community Alums
Not applicable

Hi,

i want to add a Reference Qualifier to a field, which has type "table_name", but apparently I can't do it for some reason.

Basically I'd like to list only those tables, which are extensions of "task".

Is anyone has experience w this?

1 ACCEPTED SOLUTION

Sangeeta Choudh
Giga Expert

Hi Matyas,

You can list only Task extended table in field has type table-name as follows step-

  1. Navigate to Configure dictionary of table-name type field
  2. Create new attribute as

        Attribute- Base-table and Value- task

 

Refer image for details-

                                                        image 1

find_real_file.png

                                                                image 2

find_real_file.png

                                                                image 3

find_real_file.png

 

 

 If you have any query feel free to ask.

Please mark as Correct Answer/Helpful, if applicable.

 
Regards,

Sangeeta Choudhary.

 

View solution in original post

4 REPLIES 4

Brian Lancaster
Tera Sage

This should do it if you are look at all tables table.

super_class=02d4fc456f3203008a470f1aea3ee41d

Sangeeta Choudh
Giga Expert

Hi Matyas,

You can list only Task extended table in field has type table-name as follows step-

  1. Navigate to Configure dictionary of table-name type field
  2. Create new attribute as

        Attribute- Base-table and Value- task

 

Refer image for details-

                                                        image 1

find_real_file.png

                                                                image 2

find_real_file.png

                                                                image 3

find_real_file.png

 

 

 If you have any query feel free to ask.

Please mark as Correct Answer/Helpful, if applicable.

 
Regards,

Sangeeta Choudhary.

 

Jules Edwards
Giga Expert

I have a related question, I would like to limit the selection to just three tables in the selection:

1) cmdb_ci_business_app
2) cmdb_ci_service
3) cmdb_ci_datacenter


Hello @Jules Edwards , you can choose dictionary attribute "Table choices script" & in the value field write a name of script include.

in this script include you must have a function of name process that has return type an array of string ( table names you want to view)

Check below images this is what worked for me:

MelodyMW_0-1697555718309.png

MelodyMW_1-1697555756059.png