3.4. Fop Expression Builder With Mixed Queries (Filter, Order, Page)

?filter=Midterm>90;Name~=A;and // Filters

&order=Midterm;desc // Ordering

&pageNumber=1 

&pageSize=10

Explanation

Find students which has more score than 90 and which names start with 'A'

Then order by midterm desc

First page with 10 size

---

?filter=Midterm>90;Name~=A;and$Final>=90

&order=Final

&pageNumber=2

&pageSize=10

Explanation

Find students which has more score than 90 and which names start with 'A' or whose final more and equal than 90

Then order by final asc

Second page with 10 size

---

?filter=Midterm>92;Name~=A;and$Final>=90;Name!|=A;Birthday<2012-06-07

&order=Midterm;desc

&pageNumber=1

&pageSize=10

Explanation

Find students which has more score than 92 and which names start with 'A' or name is not ends with 'A' and birthday less than 2012-06-07

Then order by Midterm desc

First page with 10 size