I'm using Room database.
I have a case where I want to show number of unread messages to the user.
I've created SQL QUERY
@Query("SELECT COUNT(${Notification.COLUMN_ID_LOCAL}) FROM ${Notification.TABLE_NAME} WHERE ${Notification.COLUMN_IS_READ} = :arg0")
fun getUnreadedNotificationsCount(unread: Boolean = false): LiveData<Int>
Changes of the column Notification.COLUMN_IS_READ
don't propagate to update my LiveData<Int>
This case is not handled or is it a bug of Room Library?
EDIT: please close this question