DataTable Search in related table

DataTable Search in related table

CSharkCShark Posts: 3Questions: 2Answers: 0

Hello all,

I have 2 tables - parents and children. They are related using ParentID as primary key.

Only parents table is visible. Is it possible to search also in children table and if any match found, draw the related parent in parent table.
e.g. I am searching for child_name over parent table. So if I find such child, I will draw his parent in parent table.

I can do it in the backend, but datatables search in the frontend is much more interactive for me.

Thanks for your answer.

Answers

  • colincolin Posts: 15,142Questions: 1Answers: 2,586

    I suspect the place to do that would be search on the child table. You can check the results in the table, and use that to issue a search() on the parent table,

    Colin

This discussion has been closed.