sys_script, sys_script_include tables are not showing on field attribute using tableChoicesScript

[kyciranne]

I tried to filter the available tables in my field (source_table) with a table_name type. I am using tableChoicesScript attribute with the below codes in my script include but the drop-down field is empty, it is working for other tables though.

process: function(tableName) {

answer = new Array();
answer.push("");
answer.push("sys_script");
answer.push("sys_script_include");
return answer;
},

[Tony Chatfield1]

Hi, Why do you pass the parameter 'tableName' into the function and not utilize it anywhere?
Perhaps you clarify your issue\requirement\functionality as your post is not very clear, and the partial script snippet doesn't help much.

[kyciranne]

Hi Tony,

In my table field, I would like to only display business rules, client script, script include tables.

These tables are available if no attribute is set on the field where type is table_name. I initially used the "based table" attribute for sys_metadata, this is the extending table of the above, but it did not show these tables on drop-down thus I tried tableChoiceScript attribute but the result seems the same.

Thanks

[Guillaume11 · Accepted solution]

Hey @kyciranne ,

I experiencied the same issue as you and finally get a solution (from ServiceNow Support)

Table fields seems to use the property glide.ui.permitted_tables to display system tables (tables starting with sys_).

Then if you want to display Business Rule (sys_script) & Script Include tables in your source_table field, add sys_script,sys_script_include to the glide.ui.permitted_tables property.

Don't hesitate to mark this answer as helpful if it helped you 🙂

Guillaume