Dynamic Load Combo From Server

Suite and Optimus Suite 5
#1

Hi all,

i alredy have a question

I have a grid and i set a “combo” column for products

var combo = grid.getColumnCombo(3);
combo.enableFilteringMode(true);
combo.loadXML("comboOptions.php?list=product&etc=" + new Date().getTime() );

that woks fine with 200 products, but if i have 20,000 products the load is very slow…

how can i filter the products and show only the rows with the mask what i typing

the query in server is like

SELECT DISTINCT id,descripcion FROM articulos WHERE descripcion LIKE '%%'  ORDER BY id,descripcion

but i need the query is updating while type a mask for faster results

thank you

#2

Please, try to use the autocomplete mode:
docs.dhtmlx.com/api__dhtmlxcombo … plete.html