Issue in query parameters:An Annotation argument must be a compile time constant

user_4061644 0
Viewed 362

I am trying to set room query parameters by Enum:

enum class Status(val status:Int){
    NOTANSWERED(1),
    ANSWERED(2),
    WRONGANSWERED(3)
}

the query:

@Query("SELECT * FROM questions where status=${Status.NOTANSWERED.status}")
    suspend fun getNotAnsweredQuestions()

IDE get error:

An Annotation argument must be a compile time constant

I have also read this topic but not solved my issue

android-room kotlin android
1 Answers

Look at this recent issuetracker discussion; like the IDE error says, your value is not a compile time constant; using an enum value or an enum value property directly in a query annotation is not possible: https://issuetracker.google.com/issues/170235802

The final comment #5 (https://issuetracker.google.com/issues/170235802#comment5) suggests a fairly straightforward workaround: create another function that passes the value:

@Query("SELECT * FROM questions where status=:status")
protected suspend fun getQuestions(status: Int)

suspend fun getNotAnsweredQuestions() = getQuestions(Status.NOTANSWERED.status)

In addition I recommend using a @TypeConverter, so that you can pass your enum values directly (Status.NOTANSWERED) instead of their properties (Status.NOTANSWERED.status).

user_4364170
Related