@Transactional(readOnly = true)
public Page
        
          getNewsWithContent(Map
         
           parameters, Pageable page) {
    // Fetch the news (without content clob) using the search parameters
    // run distinct if we want to fetch distinct news
    String title = parameters.getOrDefault("title", null);
    Specification
          
            distinctNewsSpecification =
            Specification.where(NewsSpecification.titleEquals(title))
                         .and(NewsSpecification.distinct());
    Page
           
             pagedNews = newsRepository.findAll(distinctNewsSpecification, page);
    // get the news ids which are fetched
    List
            
              newsIds = pagedNews.getContent().stream().map(news -> news.getNewsId()) .collect(Collectors.toList()); // fetch the news (with content clob) of the news ids Specification
             
               newsWithContentSpecification = Specification.where(NewsWithContentSpecification.newsIdIn(newsIds)); List
              
                newsWithContent = newsWithContentRepository.findAll(newsWithContentSpecification); return new PageImpl
               
                (newsWithContent, pagedNews.getPageable(), pagedNews.getTotalElements()); }