ATF choice over 10,000 records

jnt-cnt
Mega Sage

Hi all,

I am creating ATF currently and facing an issue where the choice is not coming up on ATF.

The field (variable since its on sp) is referencing choice table, and reference qualifier is being set so only few choices are available for selection when creating forms manually.

 

However, on ATF, this reference qualifier is not applicable and seems as though only 10,000 records are available for selection on ATF so the choice I wanted to select is not available.

 

Are there any workrounds for this issue?

9 REPLIES 9

@jnt-cnt 

why are you allowing your end users to select sys_choice? not a good way

Another way and you can try this, not sure if this will work

1) try to use "Run Server Side Script Step" and store the sys_choice record sysId as output

2) then use this output in your Set variable value step

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Server side script is also no available for selection as a choice record unfortunately 😞 

jntcnt_0-1745317023588.png

 

Akiladevi Raje1
Giga Guru

@jnt-cnt 

 

As a workaround, use set field values Test step to set the required choice from the dropdown.

 

The dropdown has too many records, and the record i want to select is not available in the dropdown 

Somujit1
Tera Contributor

 @jnt-cnt ,

 

Were you able to find any solution for this issue.

I tried the below approach -

1. Create a Test step Config script querying the sys_choice table, and with input and output variables.

2. Add the custom step to my ATF Test.

3. Set variable values based on the output variable.

 

Step 1 and 2 was successful and the sys_choice value shows found. However, while setting the variable value i get the below error  -

FAILURE: Unable to set field '<variable_name>' to value '<choice_value>'. Value '<choice_value>' is not currently a valid choice.

 

Thanks,

Somujit