title: How can I Sort data Case insensitive with Spring Data Rest?
body: <p>I like to have a findAll Method in my SortimentRespository, which allows Sorting and Paging and where I can pass a parameter with the current page and the size of the page and the name of the column which I want to sort case insensitive.</p>
  
  <p>The request shall look something like:</p>
  
  <p><a href="http://localhost:8081/x/rest/sortiments?size=20&amp;page=1" rel="nofollow noreferrer">http://localhost:8081/x/rest/sortiments?size=20&amp;page=1</a></p>
  
  <p>or
  <a href="http://localhost:8081/x/rest/sortiments?size=20&amp;sort=name,desc&amp;page=1" rel="nofollow noreferrer">http://localhost:8081/x/rest/sortiments?size=20&amp;sort=name,desc&amp;page=1</a></p>
  
  <p>I tried the following methods in my Repository</p>
  
  <pre><code>    @Transactional
      public interface SortimentRepository extends JpaRepository&lt;Sortiment,         RootKey&gt;, SortimentRepositoryCustom {
          List&lt;Sortiment&gt; findAll();            
          // Query 1
          Page&lt;Sortiment&gt; findAllIgnoreCase(Pageable pageable);
  
          // Query 2
          Page&lt;Sortiment&gt; findAllByOrderByNameAscIgnoreCase(Pageable pageable);
  
          // Query 3
          @Query("select s from Sortiment s order by LOWER(s.name)")
          Page&lt;Sortiment&gt; findAllOrderByNameIgnoreCase(Pageable p);
      }
  </code></pre>
  
  <p><strong>Results</strong></p>
  
  <p>Query 1:
  Error while running: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sortimentRepository': Invocation of init method failed; nested exception is org.springframework.data.mapping.PropertyReferenceException: No property find found for type Sortiment!</p>
  
  <p>Query 2 :
  org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sortimentRepository': Invocation of init method failed; nested exception is org.springframework.data.mapping.PropertyReferenceException: No property ignoreCase found for type Sortiment!</p>
  
  <p>Query 3:
  I even can't see this method in the hal browser under link search</p>
  
  <p>Does anybody has an idea, how I could achieve the case insenstitive sorting? It would be as well be really nice, if I had something globale because several repository will need the case insensitive method for findAll...</p>