Adding a dynamic combo box to a data bound grid

Suite and Optimus Suite 5
#1

based on this sample, I started looking at adding Department as a combo selection to the grid in here with IDs and names for the department instead of using the name.
docs.dhtmlx.com/doku.php?id=dhtm … erver-side

I have now spun through a lot of different combinations, but I have not come up with a solution that works yet.
The closest, I’ve got is that I’ve got the grid options loading in a connector. and using loadxml() on the gird, to load it. It all loads fine, but when i call .sync() which binds the datasource to the grid, all that column shows is the IDs not the name that belongs with the combo. THe combo is still there, and if i click on the row to edit it, the correct options come back.

Any thoughts on this ?
thanks

#2

Hi All,

I am trying to add a combobox in the grid. Combobox should display the list of countries.
But Not able to see it. What am I missing in this.

Below is the code :
Html side code:-----------------------------------------------------
mygrid = new dhtmlXGridObject(‘gridbox’);
mygrid.setImagePath("…/common/imgs/");
mygrid.setHeader(“Column A, Column B”);
//mygrid.attachHeader("#connector_text_filter,#connector_text_filter")
mygrid.setInitWidths(“100,*”)
mygrid.setColTypes(“co,co”);
mygrid.setColSorting(“connector,connector”)
mygrid.enableSmartRendering(true)
mygrid.enableMultiselect(true)
mygrid.init();
mygrid.loadXML(“06_combo_connector.do”);
var dp = new dataProcessor(“06_combo_connector.do”);
dp.init(mygrid);

Connector code --------------------------

GridConnector c = new GridConnector(conn);

	BaseConnector filter1 = new OptionsConnector(conn);
	filter1.render_table("countries","item_id","item_id(value),item_nm(label)");
	c.set_options("item_nm",filter1);
	
	c.dynamic_loading(100);
	c.render_table("grid50000", "item_id", "item_nm,item_cd");

Regards,
Gene

#3

The same code works correctly locally, if issue still occurs - please try to update connector.js with the attached one.
connector.zip (1.52 KB)