Populate record producer choice list variable field using Advance Reference Qualifier

[Saurabh8]

Hi All,

I am trying to populate a Record Producer choice variable field ( using sys_choice table ) as shared but can someone guide me as to where I am going wrong?

* I have created a Script Include and returning the choice list values using JSON.stringify

* After that I am calling the above using an Advance Reference Qualifier

I need to show the choice values returned from the script include in the Record Producer variable.

Regards,

Saurabh

[Soeren Maucher]

Hello Saurabh, 

the Advanced Reference Qualifier in the end must contain the entire filter. Currently your script is returning only a list. You must add the rest of the filter condition before your script, something like: 

javascript:"fieldnameIN" + new returnSubofferings().returnSubOff();

I hope this helped! 

Greetings, 
Sören

[Saurabh8]

Hey Soren,

I tried but it didn't work! 😞

Regards,,

Saurabh

[Mohith Devatte]

Hello Saurabh,

Can you please remove JSON.stringify and try 

please mark my answer correct if it helps you

also while returning can you try this 

return "valueIN"+arr;

please mark my answer correct if it helps you

[Dirk D]

Hi,
you can use the "Lookup Selectbox" referencing to the sys_choice.
And use in the "Lookup Value" the field Value.