<Why android room database query doesn't work> Wha...

# stackoverflow

[user]

Why android room database query doesn't work
What I am doing wrong?
Model class
@Entity(indices = [Index(value = [ "id_mess"], unique = true)])
class MessengerModel (
@PrimaryKey
@ColumnInfo(name = "id_mess")
var id_mess: Int,
var id_fr: Int,
var id_to: Int,
var dt: Long,
var message: String
)

ModelDao class
@Query("SELECT * FROM MessengerModel
WHERE (
(id_fr = :his_id AND id_to = $MY_USER_ID) OR (id_fr = $MY_USER_ID AND id_to = :his_id)
)
AND id_mess < :id_message")

fun...