Grails: How do I create filter like the ones in MS Excel??

Question

I want to sort the elements in my list and have the option of filter them the same way MS Excel does.

So it should be able to keep the filtered elements in the table and apply a filter within those results as well. Also be able to sort them without refreshing the whole table.

Any help is greatly appreciated!

FG

Answer 1

you can do it with a criteria in you list action of your controller

def result

if ( params?.filter && params?.filterVal) {
    result = Book.createCriteria().list(max: params?.max, offset: params?.offset) {
         eq(params?.filter,params?.filterVal)
    }
} else {
    // normal list retrieval code
}

where params?.filter is the property to filter on and params?.filterVal is the value