GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → vijjayy81 → spring-boot-jpa-rest-demo-filter-paging-sorting

vijjayy81 / spring-boot-jpa-rest-demo-filter-paging-sorting

Licence: other
Spring Boot Data JPA with Filter, Pagination and Sorting

Programming Languages

java
68154 projects - #9 most used programming language

Labels

paginationsortingspringspring-bootspring-datafiltersortspring-mvcspring-data-jpafilteringfilter-pagination-sorting

Projects that are alternatives of or similar to spring-boot-jpa-rest-demo-filter-paging-sorting

Queryql
Easily add filtering, sorting, and pagination to your Node.js REST API through your old friend: the query string!
Stars: ✭ 76 (+8.57%)
Mutual labels:  pagination, sorting, filter, sort, filtering
Graphql To Mongodb
Allows for generic run-time generation of filter types for existing graphql types and parsing client requests to mongodb find queries
Stars: ✭ 261 (+272.86%)
Mutual labels:  pagination, filter, sort
Rummage ecto
Search, Sort and Pagination for ecto queries
Stars: ✭ 190 (+171.43%)
Mutual labels:  pagination, sorting, sort
Vue Bootstrap4 Table
Advanced table based on Vue 2 and Bootstrap 4 ⚡️
Stars: ✭ 187 (+167.14%)
Mutual labels:  pagination, sorting, filtering
Tablefilter
A Javascript library making HTML tables filterable and a bit more :)
Stars: ✭ 248 (+254.29%)
Mutual labels:  pagination, sorting, filter
ag-grid
The best JavaScript Data Table for building Enterprise Applications. Supports React / Angular / Vue / Plain JavaScript.
Stars: ✭ 8,743 (+12390%)
Mutual labels:  pagination, sorting, filtering
repository
[PHP 7] Implementation and definition of a base Repository in Domain land.
Stars: ✭ 26 (-62.86%)
Mutual labels:  pagination, filter, sort
pimpable
No description or website provided.
Stars: ✭ 102 (+45.71%)
Mutual labels:  sorting, filter, filtering
Filterable
Filtering from incoming params in Elixir/Ecto/Phoenix with easy to use DSL.
Stars: ✭ 83 (+18.57%)
Mutual labels:  pagination, sorting, filter
Library
Online Library Management. User can search, check in, checkout book. System adds fines automatically if the book is not checked in by due date
Stars: ✭ 27 (-61.43%)
Mutual labels:  spring-data, spring-mvc, spring-data-jpa
Gridify
Easy and optimized way to apply Filtering, Sorting, and Pagination using text-based data.
Stars: ✭ 372 (+431.43%)
Mutual labels:  pagination, sorting, filtering
Rummage phoenix
Full Phoenix Support for Rummage. It can be used for searching, sorting and paginating collections in phoenix.
Stars: ✭ 144 (+105.71%)
Mutual labels:  pagination, sorting, sort
React Table
⚛️ Hooks for building fast and extendable tables and datagrids for React
Stars: ✭ 15,739 (+22384.29%)
Mutual labels:  pagination, sorting, filtering
react-strap-table
react table (client and server-side) based on bootstrap.
Stars: ✭ 28 (-60%)
Mutual labels:  pagination, sorting, filter
express-mquery
Expose mongoose query API through HTTP request.
Stars: ✭ 37 (-47.14%)
Mutual labels:  pagination, filter, sort
Gridjs
Advanced table plugin
Stars: ✭ 3,231 (+4515.71%)
Mutual labels:  pagination, filter, sort
Angularjs Springmvc Sample Boot
A RESTful sample using Spring Boot, Spring MVC, Spring Data and Angular/Bootstrap.
Stars: ✭ 309 (+341.43%)
Mutual labels:  spring-data, spring-mvc, spring-data-jpa
Spring Mvc Thymeleaf Crud
Spring MVC CRUD Application with Thymeleaf, HTML5, CSS3 and Bootstrap
Stars: ✭ 14 (-80%)
Mutual labels:  spring-data, spring-mvc, spring-data-jpa
Sieve
⚗️ Clean & extensible Sorting, Filtering, and Pagination for ASP.NET Core
Stars: ✭ 560 (+700%)
Mutual labels:  pagination, filter, sort
Vue Table Dynamic
🎉 A dynamic table with sorting, filtering, editing, pagination, multiple select, etc.
Stars: ✭ 106 (+51.43%)
Mutual labels:  pagination, sorting, filtering
View All Similar Projects ➔

spring-boot-jpa-rest-demo-filter-paging-sorting

An example application using Spring boot MVC, Spring Data JPA with the ability to do filter, pagination and sorting.

Filter

REST APIs handles filter as followed in the demo application.

It parses and converts the following notions as org.springframework.data.jpa.domain.Specification. The operation and specification mapping are kept as operation to lambda functions.

Symbol Operation example filter query param
eq Equals city=eq:Sydney
neq Not Equals country=neq:uk
gt Greater Than amount=gt:10000
gte Greater Than or equals to amount=gte:10000
lt Less Than amount=lt:10000
lte Less Than or equals to amount=lte:10000
in IN country=in:uk, usa, au
nin Not IN country=nin:fr, de, nz
btn Between joiningDate=btn:2018-01-01, 2016-01-01
like Like firstName=like:John

Paging

The API's query params 'pageNumber' & 'pageSize' are converted to org.springframework.data.domain.PageRequest

Sample .....?pageSize=10&pageNumber=2

Sorting

'sort' query param with comma separated attributes prefixed with either '+' (ASC Order) or '-' (DESC Order) are converted to org.springframework.data.domain.Sort with org.springframework.data.domain.PageRequest

Example: .....?sort=+salary,+joiningDate

Technology stack

  • Spring Boot
  • Spring MVC
  • Spring Data JPA
  • Hibernate 5.x
  • Swagger
  • Spring Boot Test/JUnit/Mockito/RestAssured

Prerequisites

  • JDK 8
  • Maven

Run

mvn spring-boot:run

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].