Untitled

mail@pastecode.io avatarunknown
java
a month ago
295 B
1
Indexable
Never
@Query(
        value = "select count(*) from category_value cv inner join category c on c.id = cv.id_category where cv.id  = ?1 and c.code = ?3 and cv.status = ?2 and c.status= ?2",
        nativeQuery = true
    )
    Long existsByIdAndStatus(Long id, Integer status, String categoryCode);