3.2. Fop Expression Builder Order (Sorting)

Order

PS: Currently we only support order by 1 column (It will be improved!)

Our order query is quite easy

order=Midterm;desc

; is our separator

The first part represents which column we are gonna orderby.

the second part represents asc or desc -> default is asc

Fop Query	SQL
?order=Midterm	select * from Students Order By Midterm
?order=Midterm;desc	select * from Students Order By Midterm desc