How can I execute query with subquery and join with specification?
I have method is like this
public static Specification foo(Root root, Quety query, CriteriaBuilder criteriaBuilder) {
};
Specification is from package org.springframework.data.jpa.domain.Specification;
and I need execute sql query is like this
select a.id as action_id from actions a
where a.id not in
(select a.id as action_id from actions a
inner join action_categories ac on a.id = ac.action_id
inner join categories c on ac.category_id = c.id
where c.name = '{id}');
