tiagomacul
Giga Sage

sn_flow_designer.allowed_system_tables property

We're trying to use flow and on the "look up record" the "sys_choice" table doesn't appear, we can't select this table and this behaviour occured because isn't a best practice select record in many sys tables (performance issues, simular to Reporting on system tables).

Sometimes we'd a controlled environment that it's necessary or about business requirements and we need to do, or be how do it?

 

 

See below the image how was howing for us before the change

find_real_file.png

 How to configure:

ImageDescription
 find_real_file.png

 01. Search on the Filter Navigator by "sys_properties.list"

Faça um busca no filter navigator por

find_real_file.png

02. Search by property sn_flow_designer.allowed_system_tables

 

Busque pela propriedade sn_flow_designer.allowed_system_tables

find_real_file.png

03. Will be opened the property form

 

A propriedade irá abrir no novo form

find_real_file.png

04.update the value field the default value is "sys_attachment,sys_data_source" you need to add the new table "sys_attachment,sys_data_source,sys_choice"

 

Atualize o conteúdo do campo value com a tabela sys_choice

find_real_file.png

05. Click Update

 

Clique em update

Resulting the new behaviour 

find_real_file.png

image

summary

Conteúdos Servicenow em Português

Connect Chat administration

Comments
William David
Giga Guru

Heads up to anyone experiencing the same issue. The above steps work BUT ... you will either have to wait 5 to 10 minutes for the underlying platform to update itself with the System Property modification, or you will have to reload the Flow Designer environment into your browser (or both - I cannot tell with certainty).

Version history
Last update:
‎11-29-2021 06:58 AM
Updated by: