[ttran]

This is on the same issue. I have a new screen. I am using the same pattern. However, I am not seeing the display field.

Here is my code:

ListGridField productField = new ListGridField("product_id", CONSTANTS.productLine(),200);
productField.setEditorType(new SelectItem());
productField.setFilterEditorType(new ComboBoxItem());
productField.setDisplayField("productName");

And I can see from the RPC data that the productName is coming accross.

data:[
{
id:4144,
user_added:"ESD",
user_modified:"ESD",
user_modified_date:new Date(1288933200000),
product_id:711,
status:"A",
PS_PRODUCT_ID:"00025",
version_id:4061,
user_added_date:new Date(1288971999000),
productName:"StratWorks",
version:"5000.0.0.1"
},


What do you think the issue may be here?

Thanks,

[Isomorphic]

Use a "select distinct" to return only distinct rows. This is standard SQL.

One your other issue - the data you showed does include productName.