Hi

So I've been getting creative with my use of wpDataTables (love them!) but am having trouble with the URL Link column not filtering.  It could very well be what I'm attempting to do.

Here's my table query:

SELECT CONCAT('/Contract_DB/?p=', `wp_idw_contracts.post_id`, '||', `wp_idw_contracts.contracts_property`) as property_link,
       wp_idw_contracts.licensor_contracts,
       wp_idw_contracts.contract_imprint,
       wp_idw_contracts.contract_license_contract_number,
       wp_idw_contracts.contract_expires
FROM wp_idw_contracts

I then the column type on the property_link column to "URL Link" and tada!  I get a nicely formatted link to the relevant post without needing a filter and calls to the database or the user needing to understand pipebreaks and links.

The problem is that this column doesn't want to filter.

Thoughts as to why? Perhaps is just can't handle the concat, but I don't see why it shouldn't.

Thanks

Just a bit more info from tinkering some more with this.  I CAN filter this table when Advance Column Filters AND Filters in a form are both on.  Sorting on the cancat column does not work at all.

Non concat columns with URL Link can be sorted and filtered.

Disabling server-side processing allows filters to work.  Which I could do except that I'm going to be dealing with a database of over 5000 rows :O

Thanks!