Open zhangzhenhuajack opened 8 months ago
一: 根据json里面的某个字段进行查询的方法
@Query(value = "select * from workflow_template_node n where n.workflow_template_info_id=:#{#workflowTemplateInfoId} and JSON_CONTAINS(JSON_EXTRACT(n.parents, '$[*].parentNodeId'),JSON_ARRAY(:#{#nodeId}))", nativeQuery = true)
List<WorkflowTemplateNode> findByParentId(@Param("workflowTemplateInfoId") Long workflowTemplateInfoId, @Param("nodeId") Long nodeId);
json的一些函数参考:https://www.cnblogs.com/ivictor/p/16221712.html
参考: https://github.com/vladmihalcea/hypersistence-utils
jsonType的实体如下: