Individual column Search is not working

bmcbride1991

I am having a issue where the table will not update with an individual column search. I have a category dropdown <select> that i want to use to filter the data. the request looks good but i dont get the response i want.

test here:
https://interlakesgaragesale.com/

here is the code im using.

"initComplete": function () {
$('#category').on('change', function () {
oTable
.columns(7)
.search(this.value)
.draw();
});
}

any suggesstions on getting this to work?

tangerine

.columns(7)

Your table only has 6 columns.

bmcbride1991

The 7th column is hidden.
{"visible": false, "targets": [0, 7]},

kthorngren

I would suspect something in your server side code is not processing the request properly. It looks like your code would work if you were doing client side processing. Since you have 74 records in your test, try turning off server side to test your code. Once you get it working then troubleshoot your server side code.

I think you can simplify your search from what I see in your code now to what you have in your first post.

Kevin

bmcbride1991

Well I wasn't even thinking about the server side code i assumed it was good but turns out that was the problem. Thanks