Ktorm 'Contains' aggregate about ktorm HOT 5 CLOSED

What's your use case? Could you explain it more detailed?

from ktorm.

for exemple:
in sql: select * from table where column-name like '%value%'
with ktorm: table.assequnce().filter { column-name like value } but not work like sql

from ktorm.

You might have forgetten the % symbols. Try this:

Employees.asSequence().filter { it.name like "%vince%" }

from ktorm.

thanks,
yes i don't use % because i expected the 'like' operator do that automaticaly

from ktorm.

If you want to automate that, write an extension function like:

fun ColumnDeclaring<String>.contains(argument: String) = this like "%$argument%"

Then you can do this:

Employees.asSequence().filter { it.name.contains("vince") }

from ktorm.