Issue when including view in a column with Yajra.

[mchourishi]

Hi I have been using Yajra Datables 9.18 on Laravel 6 and have a custom column where I include a view. There's something really weird happening that I cant figure out. When I include view in the column, datatables run multiple queries from lot of different tables and hence slows down the retrieval. Even if I keep the view an empty file I still see the same issue. I want to query on one table and my controller only has one query.

I see this issue only when I have this custom column which includes the view.

 $files = FileAttachment::with('creator')->latest();
 return DataTables::of($files)
                   ->addColumn('action', function ($files){
                        return view('fileAttachments.actions', compact('files'))->render();
                    })
                    ->rawColumns('action'])
                    ->make(true);

As I mentioned before even if the view is empty file it still execute multiple queries (around 4000+)from multiple tables but you can see I am only querying one table with relationship.

[yajra]

You might be lazy loading some properties inside the view.

On Laravel 9, you can enable strict mode to isolate this.

[mchourishi]

If I instead of calling view use inner html I dont see this issue. It only executes required queries.

->addColumn('action', function ($files){
                        // return view('fileAttachments.actions', compact('files'))->render();

                        $deleteBtn = '<form id = "form_delete_attachment_"'.$files->id.'"></form>';
                        return $deleteBtn;
                    })

However I would prefer to use view as otherwise it will bloat the controller.

[yajra]

Hmm, that's weird. Do you have any view composer by any chance?

[mchourishi]

Yeah you're right and probably that's causing the issue. Thanks a lot for giving me direction.
I have it in AppServiceProvider.
I want to exclude the view, I tried the following but that's not working for me.

View::composer('*', function($view){
		    if($view->getName() != 'fileAttachments.actions') {
                     // Queries to be executed on  views.
                    }
        });

Its still returning 4K queries .

[mchourishi]

Thanks a lot @yajra for your help, I got it working with your direction.
View Composer was causing the problem.

[yajra]

You're welcome. Glad we figured it out ^_^