CODE EXAMPLE FOR JAVA

spring jpa query with union all

Pageable pageable = PageRequest.of(pageQueryDto.getPage() - 1, pageQueryDto.getSize(), Sort.Direction.fromString(pageQueryDto.getDirection()), propertie);Page<Map<String, Object>> page = projectRepository.find(projectId, pageable);