QBColumn like(pattern, escape)

Classic Servoy
1

It seems that nothing is escaped in the pattern nevertheless escape char is provided.
Does anybody have working example?

I have tried Servoy example against MS SQL Server. No success.

query.where.add(query.columns.companyname.like('X_%', '_'))

Here is a more descriptive source code of what I am trying to achieve:

    var escapeChar = '|';
    var value = '10' + escapeChar + '%'; // escape char
    var pattern = '%' + value + '%';    

    var dataSource = 'db:/test/test_table';
    var table = databaseManager.getTable(dataSource);
    var column = 'TestColumn'; // ntext in MS SQL Server
    var searchFoundset = databaseManager.getFoundSet(dataSource);
    
    var qbSelect = databaseManager.createSelect(dataSource);
    var qbColumn = qbSelect.getColumn(column);
    qbSelect.where.add(qbColumn.like(pattern, escapeChar));
    searchFoundset.loadRecords(qbSelect);
2

Vasil,

What is the sql being generated?
databasemanager.getSQL(foundset) shows this.

Rob

3

Having my previous post in mind the code:

var sql = databaseManager.getSQL(searchFoundset);
application.output(sql);

generates this output:

select test_table.test_table_id from dbo.test_table  where test_table.test_column like ?
4

I expect the generated sql to be something like:

select test_table.test_table_id from dbo.test_table  where test_table.test_column like ? escape '|'
5

Vasil,

This seems to be an issue in Servoy, please file a case in our support system.

Rob

6

Rob,

Does the following fix Jira cover the issue described in the current topic?

I did not receive email notification for your last reply and I missed to file a case in Servoy support system.

Vasil

7

Yes, this is he same issue and fixed in upcoming 6.1.3 release.

Rob