springbootJpa Specification实现mysql中json字段查询

需求

SELECT
	order0_.id AS id1_53_
WHERE
	JSON_EXTRACT ( order0_.ext_obj, '$.type' ) = 1 

jpa写法

predicateList.add(criteriaBuilder.equal(
     criteriaBuilder.function(
       "JSON_EXTRACT",
        String.class,
        root.get("extObj"),
         criteriaBuilder.literal("$.type")
), 1)

使用的是function方法