How to filter dynamically created columns based on foreign keys during server-side processing

Gulzar Ali

Hi All!
I am working with datatable server-side processing. My database table contains "id" of another table as a foreign key, which I use to get "name" column for datatable.
But I am unable to filter based on "name" column.
As "name" column corresponds to "id" column in target table.
How can I do this...

Main problem is that the search value to be posted is about "name" but target database table contains "id" for these "name".

colin

Hi @Gulzar Ali ,

There two threads, here and here, should help, they are asking the same,

Cheers,

Colin