Ktorm 'Contains' aggregate about ktorm

[vincentlauvlwj]

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

[Kotlin-GDE]

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

[vincentlauvlwj]

You might have forgetten the % symbols. Try this:

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

[Kotlin-GDE]

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

[vincentlauvlwj]

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") }