Create column with Field List type

[Dang Van]

I would like to create a column of a table with the Field List type, but I can not

[Danish Bhairag2]

Hi @Dang Van ,

I don't understand, what do you mean by cannot?

Can u tell or show how r u creating it?

Thanks,

Danish

[Tai Vu · Accepted solution]

Hi @Dang Van 

There's an existing Reference Qualifier for the field Type in Dictionary [sys_dictionary]. See below.

We can not see the script but it's because of this checkbox.

So there's a couple of way you can create a field with this type Field List.

1. Try to enable this checkbox. Sample below

var grFieldClass = new GlideRecord('sys_glide_object');
if(grFieldClass.get('0cdefe530a0a0b5b229b360018220859')){
    grFieldClass.visible = true;
    grFieldClass.update();
}

2. Remove the Reference Qualifier of the field Type in the Dictionary Entry [sys_dictionary] table.

URL: https://<instance_name>/nav_to.do?uri=sys_dictionary.do?sys_id=d4aa0020d9313110cedf7dffddb48f74

3. Just leverage the SNUtils. Open an existing field under this type "Field List" (you can find more than 100 fields in Dictionary for this type). Then update the Table, Field Label and Name as you prefer. => Insert new one

There might be more other ways around. You can figure it out by yourself.

Let me know if it works for you.

Cheers,

Tai Vu

[Ashu_8871]

While creating a Data Certification Policy in the CMDB Workspace, I selected the Software Entitlement table (alm_license), which extends the Assets table (alm_asset). I noticed that the Display Fields and Certification Fields—both of type Field List—only show fields from the alm_license table and not from its parent table alm_asset.

Is there a way to include fields from the parent table (alm_asset) in these field lists?