Searching other tables when querying server-side processing

connorplumb

So my customers table includes their name, business name etc. However their address is stored in another table and loaded when the data is fetched.

With server-side processing am I able to search for the address, as when it queries it'll try to search for the address in the customers table where it only contains their first and last name, business name, etc.

Connor

rf1234

If your Editor instance contains a left join to the table with the address and the address is one of the fields selected and returned to the client it will work.

colin

Hi @connorplumb ,

This SO thread should help,

Cheers,

Colin