is it possible to use operators with the entity query?

[sombriks]

i was looking for some idiom like this:

val employees = database.sequenceOf(Employees).filter { (it.name like "%$search%") or (it.jobTitle like "%$search%") }.toList()

I saw https://www.ktorm.org/en/entity-finding.html#Get-Entities-by-Query-DSL, just looking for something different

[vincentlauvlwj]

Yes, of course.

[sombriks]

so how this code snipped can become valid? https://github.com/sombriks/rosetta-beer-store/blob/336add6e5a72298787b3b58d8cc5da656bcd5001/beer-store-service-kotlin-javalin-ktorm-liquibase/src/main/kotlin/beer/store/controllers/BeerController.kt#L25

[sombriks]

https://github.com/sombriks/rosetta-beer-store/pull/1/files rn it says it's invalid, how can i proceed?

[vincentlauvlwj]

It's a problem of Kotlin compiler, note the position of line breaking.

Fail:

val rows = Db.database.sequenceOf(Beers).filter {
    (it.descriptionBeer like "%$search%")
    or (it.titleBeer like "%$search%")
}

Works:

val rows = Db.database.sequenceOf(Beers).filter {
    (it.descriptionBeer like "%$search%") or
    (it.titleBeer like "%$search%")
}

Also works:

val rows = Db.database.sequenceOf(Beers).filter {
    (it.descriptionBeer like "%$search%")
    .or(it.titleBeer like "%$search%")
}

[sombriks]

i was so close, thank you so much!