The CreatorCon Call for Content is officially open! Get started here.

Important points :Configuring/Using Decision Tables for Choice output in ServiceNow

Ashwini Asarkar
Tera Contributor

If we want to configure output as choices in Decision Tables(DT):

1. Make sure you enter the choices in DT  and validate them in the sys_choice table, with the used element.

(For Example: If we have an output column in DT(say, Results) of choice datatype, you can verify in sys_choice table by filtering element=u_results, it should give all the choices in the DT).

2. If you want to make a choice as default, make sure you set the value in sys_decision_question table as default_answer=true. (These default choices will be returned when it won't find any specified/required inputs in DT  input records.)

3. If you want to upload bulk records in DT, add the choices in the DT(or sys_choice table, with required element, in case of bulk data). Then take an export of the file, and this file can be edited. Save the file and upload. Then save the DT. Note that, an import will upload/save only imported data from excel file and previous data in DT will be eliminated.

Washington DC is capable of importing more than 200 records(tested, around 500 records) at a time.

Utah version is limited to less than 200 records.

2 REPLIES 2

Its_Azar
Tera Guru
Tera Guru

Good one

☑️ If this helped, please mark it as Helpful or Accept Solution so others can find the answer too.




Kind Regards,

Mohamed Azarudeen Z

Developer @ KPMG

 Microsoft MVP (AI Services), India

Mukesh Khanna P
Tera Expert

@Ashwini Asarkar 

I'm having hundreds of choices that needs to be imported to the result choice field, but when I export the decision table excel file and update it with choice label and then try to import it, I'm getting the following error, the error is showing bcos the values are not there in the decision table, but how can we create hundreds of choices and then align that in decision table, kindly help me with this requirement.