Searching by content in a combo of the lightbox section

Scheduler Javascript
#1

Hello,

We are using a combo in the lightbox section ( We load the data of the combo from a PostgreSQL db). It shows the suggested items which start from the letters, that are entered into the search field.

Is it possible to search the items by content?

Like:
Item “Marcel Proust” should appear in the suggested items list when you type “Pro”.

Thank you

Jorge.

#2

The simplest approach will be to modify combo_connector.php

locate in it

$this->request->set_filter($this->config->text[0]["db_name"],$_GET["mask"]."%","LIKE");

and replace with

$this->request->set_filter($this->config->text[0]["db_name"],"%".$_GET["mask"]."%","LIKE");
#3

Ok, Thanks. It works fine!!

#4

one problem…

its there any way to disable the “autocomplete” combo text with the first match?? when you are searching with the combo and press a key, it proposes all matches, but complete the combo with the the first match and delete the text introduced by the user…its very dificult to use…

#5

Solve…

I coment this code in dhtmlxcombo.js

/* if(b) { var h = this.getComboText(); h != f[1] && (this.setComboText(f[1]), dhtmlXRange(this.DOMelem_input, h.length + 1, f[1].length))} else this.setComboText(f[1]); */

#6

Yep, this feature is designed for “match-by-start” and useless in your case.
The code which you have commented is not necessary for any other task, so it must not cause any side effects.