在Android文档中创建Room数据库视图的代码是:
在
@DatabaseView("SELECT user.id, user.name, user.departmentId," +
"department.name AS departmentName FROM user " +
"INNER JOIN department ON user.departmentId = department.id")
data class UserDetail(
var id: Long,
var name: String?,
var departmentId: Long,
var departmentName: String?
)
但是我该如何创建带有动态条件的视图,比如用户ID=userID,其中userID可以是1或2或其他整数?