allowFreeText(false) with server side filtering

Suite and Optimus Suite 5
#1

My dhtmlxCombo has more than 10000 options and so slow.
That’s why I want to use server side filtering.
And I do not accept free text input.

cmb.load(“…/…/combo/cmb.jsp”); // only first 100 options
cmb.allowFreeText(false);
cmb.enableFilteringMode(true, “…/…/combo/cmb.jsp”, true);

When I enter a char in combo, the input is canceled before the response from the server comes back.
I think it’s because of allowFreeText(false)

How can I use allowFreeText(false) with server side filtering?

#2

Unfortunately the issue cannot be reconstructed locally. allowFreeText() function is turned off by default and cannot influence your server-side filtering.
Please, try to use:
cmb= new dhtmlXCombo(…)
//cmb.load("…/…/combo/cmb.jsp"); // only first 100 options
cmb.allowFreeText(false);
cmb.enableFilteringMode(true, “…/…/combo/cmb.jsp”, true);

If the problem still occurs for you please, provide with a complete demo, where the problem can be reconstructed locally.
Here you can find a tutorial about creating a complete demo:
docs.dhtmlx.com/tutorials__auxi … pport.html

#3

It doesn’t work.
It’s difficult to send demo because I use database for combo options.

//cmb.allowFreeText(false);
I input “123”. It works fine.

cmb.allowFreeText(false);
I input “1”. The input is canceled. And I can’t input “123”.

server side code is below.

String where = "";

if (request.getParameter("mask") != null) {
   where = " where id like '" + request.getParameter("mask") + "%'";
}

String sql = "select id, name from TokuiSakiMst" + where;

// create combo xml

What’s wrong my code?

#4

Please, try to update your dhtmlx files. If the problem still occurs after that please, provide with a complete demo or share with a demo link, where the problem can be reconstructed.

#5

I created demo.
http://piece.bz/dhtmlx/

#6

Nobody can help?
Should I check the value on onBeforeUpdate event or something?

#7

I apologize for the delay.
The problem is confirmed. It is related to the mutlicolumn combo feature.
We’re working on a solution.

#8

The problem is fixed.
Please, try to update your dhtmlx to the latest one (5.1). It will solve the problem.

#9

Thank you!