Dynamic query in Mysql

If your table contains small amount of data (and will always contain small amount) then of course you can filter in JavaScript. This is true, for example, if you always select from DB only one "page" of data (LIMIT 10,20). But in real application you want to LIMIT and FILTER the same time as user wants to see filtered results but only 10 of them at once. He doesn't want to load 10 results and then filter it to 3. So you will almost always use the server side filtering.

If you using Mybatis read about Dynamic SQL and The SQL Builder Class. You can read filter parameters from HTTP request and set values of variables to test by Mybatis Dynaimc SQL if method. Of course you first need to write that xml with if for any filter condition.

For example if you want to filter SALES by amount (>100) and name (contains "Goo") then you can pass from JS your filter options like this:

{
    "filterBy" : [
        { field: "amount", op: "gt" }
        { field: "name", op: "contains" }
    ]
}

In Java code you can read this JSON to Map (with Jackson for example) and assign values to variables for MyBatis Dynamic SQL expression.

I can't explain more as I am not expert of Mybatis.