Retrieve all the record in a dropdown box.

[sunil kumar biswal, modificado 11 Anos atrás.]

Good evening all of my liferay friends.I hav to retrieve all of my records of a column and that should be placed in a drop down box.

[Jay Patel, modificado 11 Anos atrás.]

Hi Sunil,

This depends on your exact requirements.

If your table is created with service-builder then you can use XXXLocalServiceUtil & get the desired value in your Portlet class & then can pass it on to JSP.

-Jay.

[Tonu Sri, modificado 11 Anos atrás.]

Hi Sunil,

Get the list from the database either using Liferay Service Builder Approach or you can use your own class.
Display List content in Select box.

Thanks:

[Rewati Raman, modificado 11 Anos atrás.]

Hi Sunil,

sunil kumar biswal:

Good evening all of my liferay friends.I hav to retrieve all of my records of a column and that should be placed in a drop down box.

if u have created the table using service builder
You just need to fetch the table content by

<select name="">
<option value="">-------Select-----</option>
&lt;%
List  list=entityNameUtil.findAll();
for(entityName item:list){
%&gt;
      <option value="<%=item.getColumnName()%>">&lt;%=item.getColumnName()%&gt;</option>
&lt;%
}
</select>
%&gt;

it works for me

Regards,
Rewati Raman