I have my models as so
```kotlin
@dao
interface ChatMessageRecordDao {
...
@Query("SELECT * FROM chats AS c WHERE c.senderId IN (SELECT userId FROM chat_users WHERE chat_users.userName LIKE :query ) OR c.message LIKE :query")
fun searchMessages(query: String): List<ChatMessageRecord>
...
}
```
```kotlin
class ChatMessageRecord {
@PrimaryKey(autoGenerate = true)
var id = 0
var uId: ID? = null
@ColumnInfo(index = true)
var senderId: ID? = null
var message: String = ""
@Embedded(prefix = "photo_")
var photoRecord: PhotoRecord? = null
var sentTime: Long = 0
@ColumnInfo(index = true)
var chatReplyId: ID? = null
var forwardedFlag: Boolean = false
...
```
```kotlin
@entity(tableName = "chat_users")
class ChatUserRecord(@PrimaryKey var userId: ID, var userName: String, @Embedded var photo: PhotoRecord) {
fun toChatUser(): AppUser =
AppUser(userId, userName, photo.toPhoto())
}
```
When I compile, am getting this error
ChatMessageRecord has some fields [id, uId, senderId, message, sentTime, chatReplyId, forwardedFlag, photo_url, photo_type] which are not returned by the query
```kotlin
@dao
interface ChatMessageRecordDao {
...
@Query("SELECT * FROM chats AS c WHERE c.senderId IN (SELECT userId FROM chat_users WHERE chat_users.userName LIKE :query ) OR c.message LIKE :query")
fun searchMessages(query: String): List<ChatMessageRecord>
...
}
```
```kotlin
class ChatMessageRecord {
@PrimaryKey(autoGenerate = true)
var id = 0
var uId: ID? = null
@ColumnInfo(index = true)
var senderId: ID? = null
var message: String = ""
@Embedded(prefix = "photo_")
var photoRecord: PhotoRecord? = null
var sentTime: Long = 0
@ColumnInfo(index = true)
var chatReplyId: ID? = null
var forwardedFlag: Boolean = false
...
```
```kotlin
@entity(tableName = "chat_users")
class ChatUserRecord(@PrimaryKey var userId: ID, var userName: String, @Embedded var photo: PhotoRecord) {
fun toChatUser(): AppUser =
AppUser(userId, userName, photo.toPhoto())
}
```
When I compile, am getting this error
ChatMessageRecord has some fields [id, uId, senderId, message, sentTime, chatReplyId, forwardedFlag, photo_url, photo_type] which are not returned by the query
Facebook
Twitter
Instagram