how to add choice options from another table dynamically on an ui page

[hemanth_alapati]

how to add options to a choice list/drop down dynamically from table in an ui page.

[Ankur Bawiskar · Accepted solution]

Hi Hemanth,

can you share your code here? also from which table and what field you want to fetch

you can use html select tag to create drop down based on the choice values

sample script here

for example I have used incident table and state column

<g:evaluate var="jvar_gr" object="true">

var gr = new GlideRecord('sys_choice');

gr.addQuery('element', 'state');

gr.addQuery('name', 'incident');

gr.quey();

gr;

</g:evaluate>

<select>

<j:while test="${jvar_gr.next()}">

<option value="${jvar_gr.value}">${jvar_gr.label}</option>

</j:while>

</select>

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[hemanth_alapati]

Hi Ankur,

thanks for the response. i wanted to fetch from a custom table that is created in our instance. i wanted to set the choice values based on the value selected in a particular field. 

i will try the soultion given by you and let you know.

thanks,

hemanth

[Juan Miguel]

There is a typo where says "gr.quey();" is gr.query(); instead. 

Thanks

[Avinash_Patil1]

@Ankur Bawiskar  this is not working for me I am getting just dropdown Icon on the UI page. 

Could you plz help in this?