I’ve worked with Yajra DataTables in Laravel before, and setting up an advanced search popup in Metronic is totally doable. You can use a modal for the popup and pass the search parameters to your DataTable via AJAX. As for querying multiple tables, you’ll need to use eloquent joins or raw queries in your DataTable query builder to fetch related data efficiently.

It’s kind of like managing Qatar ID Renewal — you need the right documents from multiple sources (residency details, sponsorship info, etc.), and everything must be processed correctly to avoid delays. I found a detailed guide on QatarAlive that simplifies the renewal process. Similarly, structuring your DataTable queries the right way ensures smooth data retrieval without performance issues!

Hi,

The relation needs to be done in the Laravel model. For example in Visa model file,

Visa.php modal file;

public function customer()
 {
 return $this->belongsTo(User::class, "user_id");
 }

public function query(Visa $model)
 {
 return $model->newQuery()->with("customer");
 }

public function dataTable($query)
 {
 return datatables()
 ->eloquent($query)
 ->editColumn("customer", function (Visa $model) {
 // access customer data here for columns
 // $model->customer
 })
//...