我需要创建一个不那么简单的Sql选择查询。
像这样:
@Query("$SELECT_FROM $PRODUCT_TRANSACTION_TABLE WHERE write_status == ($SALE || $AUDIT)")
fun loadProductSaleTransactions(): LiveData<List<TransactionProductTable>>
该字段可以是Sale
或"审核">
但房间什么也没回来。你能帮我正确写吗?
我建议将查询更改为:
@Query("$SELECT_FROM $PRODUCT_TRANSACTION_TABLE WHERE write_status IN ($SALE, $AUDIT)")
fun loadProductSaleTransactions(): LiveData<List<TransactionProductTable>>
让我知道这是否可以解决问题。干杯!
只需在 WHERE 子句之后更改,如下所示
@Query(
"$SELECT_FROM $PRODUCT_TRANSACTION_TABLE WHERE
write_status = $SALE OR write_status = $AUDIT"
) fun loadProductSaleTransactions(): LiveData<List<TransactionProductTable>>
@Query("$SELECT_FROM $PRODUCT_TRANSACTION_TABLE WHERE write_status IN ($SALE, $AUDIT)")fun loadProductSaleTransactions(): LiveData<List<TransactionProductTable>>