Code in sysSearch

Questions
1

Hi,

using the module “sysSearch” I get the in this code-part:

} else if (columnLength > 0 && matchMode == STRING_MATCHING.CONTAINS && textValue.length == columnLength + 1) {

				// searching for e.g. %1234% on a column with length 5

				// that could be a problem for DBs that do not accept search parameters longer than the column

				// turning that specific case into an extra AND

				**if** (sp.isCaseSensitive()) {

					**return** q.and.add(column.not.isLike(value + '%')).add(column.not.isLike('%' + value));

				} **else** {

					**return** q.and.add(column.upper.not.like(q.functions.upper(value + '%'))).add(column.upper.not.like(q.functions.upper('%' + value)));

				}

The Warning:
"The method like() is undefined for the type QBColumnComparable”

Any idea to change or ignore?
Thanks,
Ralf

2

Hi Ralph,

this sounds more like your version of Servoy and the version of the module are not compatible.
Also as in your other post ( Warning sysLogManager ) you describe an issue that seems to be related.
Can you post what these versions are?

3

Hi Marc,
I am sorry - I forgot these informations.
I am using Servoy 2025.9.0
modules:
svySearch: 2024.3.0
sysUtils: 2025.3.0
both latest versions….
Thanks

Ralf

4

Hi Ralph,

Ah I see it - this is a result of the new QBColumn subtypes in 2025.9, that are mentioned in the release notes and on the webinar. Now it sees like() being called on a generic column, when it is only supported on a TEXT column.

However, in the SvySearch module, it already checks that it is text, so this in short, I believe this warning can be safely ignored.

We will push an update to the SvySearch module to fix the warning (apply strong typing on the column in the JSDocs.)

Thanks for reporting this :slight_smile:

Sean

5

Hi Sean,

thanks for your answer and an updatet syssearch.
Will you also have a look at sysUtils or is a new version for Titanium coming ?

Thanks also for your webinars !

All the best

Ralf