Unable to find custom table in choice table under dictionary

[Ramu8]

Hi Team,

I want choice field and want to use reference table as custom table in Choice list specification tab on dictionary 

But required custom table is not visible on Choice table field so please advice 

[Dr Atul G- LNG]

Hi @Ramu8 

Make sure you are accessing in the right scope and with right name. Also check the table accessibility as well

Please share more details to helpyou. 

[Rene El Hamzh]

Hi @Ramu8,

does the reference table's choice field have choices? If the choice field has no choices it won't be shown in the list. 

Best regards,

Rene

[Ramu8]

Thanks for response

It has choices it is mainly due to  attributes which is in default value and it is OOB configurations 

[Rene El Hamzh]

Could you clarify this please?

The available tables in the choice table field are coming from this script include DictionaryChoiceTables. 

Check if your choices are active and try to run this in a background script to see if your table name shows up in the list.

    process: function(tableName) {
        var glideAggregate = new GlideAggregate('sys_choice');
        glideAggregate.addQuery('inactive', false).addOrCondition('inactive', '');
        glideAggregate.addAggregate('MIN', 'name');
        glideAggregate.query();

        answer = new Array();
        answer.push("");
        while (glideAggregate.next())
            answer.push(glideAggregate.name + "");
        return answer;
    },