对象里的 集合json字段,查询的时候 怎么对集合json的字段进行条件查询 需要两个条件查询 返回
SqlSugar
沟通中
3
465
悬赏:0 飞吻
public class TmTransaction
{
/// <summary>
/// 订单表uid
/// </summary>
[SugarColumn(ColumnName = "tm_order_uid")]
public string TmOrderUid { get; set; }
/// <summary>
/// 业务进度
/// </summary>
[SugarColumn(ColumnName = "tm_progress",IsJson=true)]
public JArray TmProgress { get; set; }
}TmProgress === [{"uid": "17c81fbec5704d259eb7b0126b08d03a", "type": "PlaceOrder", "status": 1, "createTm": "2025-10-18T16:46:26", "updateTm": null, "tmOrderUid": "62e9125bed354edfa864e6a57c2646b9", "createUserId": 1, "updateUserId": null, "createUserName": "管理员", "updateUserName": null},
{"uid": "67d26bd7be6e4a359373fed245647a91", "type": "InformationEntry", "status": 1, "createTm": "2025-10-18T16:46:26", "updateTm": null, "tmOrderUid": "62e9125bed354edfa864e6a57c2646b9", "createUserId": 1, "updateUserId": null, "createUserName": "管理员", "updateUserName": null},
{"uid": "cc48bcc6b1994e12ae7f7d154f44d7c2", "type": "mandate", "status": 1, "createTm": "2025-10-18T16:46:26", "updateTm": null, "tmOrderUid": "62e9125bed354edfa864e6a57c2646b9", "createUserId": 1, "updateUserId": null, "createUserName": "管理员", "updateUserName": null},
{"uid": "feb77d23b91641ccba8248cdbbfdfe03", "type": "InformationConfirmation", "status": 1, "createTm": "2025-10-18T16:46:26", "updateTm": null, "tmOrderUid": "62e9125bed354edfa864e6a57c2646b9", "createUserId": 1, "updateUserId": null, "createUserName": "管理员", "updateUserName": null},
{"uid": "506ec1c758814d2da1a00bd9921d28a3", "type": "MaterialsComplete", "status": 0, "createTm": "2025-10-18T16:46:26", "updateTm": null, "tmOrderUid": "62e9125bed354edfa864e6a57c2646b9", "createUserId": 1, "updateUserId": null, "createUserName": "管理员", "updateUserName": null},
{"uid": "b545ca7012ce4d67b91a13502f84a41e", "type": "InformationReview", "status": 0, "createTm": "2025-10-18T16:46:26", "updateTm": null, "tmOrderUid": "62e9125bed354edfa864e6a57c2646b9", "createUserId": 1, "updateUserId": null, "createUserName": "管理员", "updateUserName": null},
{"uid": "be255a62436940418d6759c54ace895a", "type": "InfoSub", "status": 0, "createTm": "2025-10-18T16:46:26", "updateTm": null, "tmOrderUid": "62e9125bed354edfa864e6a57c2646b9", "createUserId": 1, "updateUserId": null, "createUserName": "管理员", "updateUserName": null},
{"uid": "2ec862e4e6af4048b133955c9f75227b", "type": "payment", "status": 0, "createTm": "2025-10-18T16:46:26", "updateTm": null, "tmOrderUid": "62e9125bed354edfa864e6a57c2646b9", "createUserId": 1, "updateUserId": null, "createUserName": "管理员", "updateUserName": null},
{"uid": "f5af22687126409eb2b084f42712c457", "type": "acceptance_notice", "status": 0, "createTm": "2025-10-18T16:46:26", "updateTm": null, "tmOrderUid": "62e9125bed354edfa864e6a57c2646b9", "createUserId": 1, "updateUserId": null, "createUserName": "管理员", "updateUserName": null},
{"uid": "605e805456cb4f52b9d549616794dbf2", "type": "substantive_examination", "status": 0, "createTm": "2025-10-18T16:46:26", "updateTm": null, "tmOrderUid": "62e9125bed354edfa864e6a57c2646b9", "createUserId": 1, "updateUserId": null, "createUserName": "管理员", "updateUserName": null},
{"uid": "c0e2dda6283f4b5c82597dd645c8539e", "type": "announcement", "status": 0, "createTm": "2025-10-18T16:46:26", "updateTm": null, "tmOrderUid": "62e9125bed354edfa864e6a57c2646b9", "createUserId": 1, "updateUserId": null, "createUserName": "管理员", "updateUserName": null},
{"uid": "68cc8e4ee57240429907753b403b585b", "type": "pause", "status": 0, "createTm": "2025-10-18T16:46:26", "updateTm": null, "tmOrderUid": "62e9125bed354edfa864e6a57c2646b9", "createUserId": 1, "updateUserId": null, "createUserName": "管理员", "updateUserName": null}]
需要 查询 TmTransaction 的 字段 TmProgress 里的参数 where =status=1 and type =InformationReview
热忱回答(3)
-
清风 VIP0
1个月前使用过 SqlFunc.JsonField(it.JsonObj,"obj","id") 和 SqlFunc.JsonArrayAny(it.Json, "a") 达不到 像单表查询的 where a and b 那种效果
0 回复 -
清风 VIP0
1个月前
这个帖子试过 也不行
0 回复 -
fate sta VIP0
1个月前@清风:看文档:扩展函数 通过自定义函数实现
0 回复