Problemes filtering with Server Side Script and formatter

Lord_Chrisi

Hy guys,

iam using datatables with a server side script.
It works, but i have some problems with the filtering.

I read some columns from a MySQL table, one of this columns contains a customer id.
I use this formatter to change the customer ids to the company names:

array(
    'db' => 'customer',
    'dt' => 1,
    'formatter' => function  ( $d, $row ) {
        some MySQL stuff..
        return $company_name;
}

The output is the correct company name in my table.
But if i type the company name in the search field, it doesn't search the customer id, it searches the company name.
So it doesn't find any results as the customers are stored as id in the table.

I thought a while, but couldn't find a solution to this.
Is there a solution to make this working?

Chris

FrancYescO

have you found a solution?