populate select box from glide record

[techies]

Hello all,

        So I am creating a UI page that requires a select box to become populated with values that are stored inside a custom table. The custom table

        has a column that contains a 'choices field' with several different choices. I am wondering if there is a way to get an array of these values into the

        jelly script and use it in the select box. An example would be lovely too.

Thank you for any help.

[techies]

It is called Subcategory and has four different choices.

[techies]

Sorry the table name is called u_sales_order_ui

[Abhinay Erra]

What is field name of it not the label and also the table name

[techies]

The table name is u_sales_order_ui and column name is u_subcategory. Sorry I do not see a field name option.

[Abhinay Erra · Accepted solution]

Here you go

<g:evaluate var="jvar_test" object="true" jelly="true">

var obj=[];

var gr= new GlideRecord('u_sales_order_ui');

  gr.query();

  while(gr.next()){

obj.push(gr.u_subcategory.toString());

  }

  obj;

</g:evaluate>

<select>

  <j:forEach var="jvar_item" items="${jvar_test}">

          <option value="${jvar_item}"> ${jvar_item} </option>

  </j:forEach>

</select>