title: yajra/laravel-datatables search is not working with laravel 5.4
body: <p>I have used <strong>yajra/laravel-datatables</strong> to create data grid list. I have used joins to retrieve information as per requirement.</p>
  
  <p><strong>Here is join code</strong></p>
  
  <pre><code>$inquiryInvoice = DB::table('inquiry_invoice')-&gt;select('inquiry_invoice.*',DB::raw('CONCAT(inquiry_personal.first_name, " ", inquiry_personal.middle_name, " ", inquiry_personal.last_name) AS full_name'), 'inquiry_personal.id as inquiry_personal_id','branches.branch_name',DB::raw('CONCAT(users.first_name, " ", users.last_name) AS user_full_name'), DB::raw('CONCAT(counselor.first_name, " ", counselor.last_name) AS counselor_full_name'), 'inquiry_counselor.user_id as inquiry_counselor_user_id','inquiry_master.workflow_id',DB::raw(' "invoice" AS type'))
                  -&gt;join('inquiry_master', 'inquiry_master.id', '=', 'inquiry_invoice.inquiry_id')
                  -&gt;join('inquiry_personal', 'inquiry_master.id', '=', 'inquiry_personal.inquiry_id')
                  -&gt;join('branches', 'inquiry_master.branch_id', '=', 'branches.id')
                  -&gt;join('users', 'inquiry_master.user_id', '=', 'users.id')
                  -&gt;leftJoin('inquiry_counselor', 'inquiry_master.id', '=', 'inquiry_counselor.inquiry_id')
                  -&gt;leftJoin('users as counselor', 'inquiry_counselor.user_id', '=', 'counselor.id');
  </code></pre>
  
  <p><strong>Here is code for assign <code>Datatables</code></strong></p>
  
  <pre><code>return Datatables::of($inquiryInvoice)
              -&gt;escapeColumns([])
              -&gt;make(true);
  </code></pre>
  
  <p><strong>Here is jQuery code</strong></p>
  
  <pre><code>$dataTable = $('#data-table').DataTable({
              processing: true,
              serverSide: true,
              Filter: true,
              url:'{!! url("transaction_any_data") !!}',
              columns: [
                  { data: 'full_name', name: 'full_name' },
                  { data: 'branch_name', name: 'branch_name' },
                  { data: 'user_full_name', name: 'user_full_name' },
                  { data: 'counselor_full_name', name: 'counselor_full_name' }
              ]
          });
  </code></pre>
  
  <p>Now when i try to search something it is giving me <strong>alert</strong> with <strong>error</strong>
  Here is an error message,
  <a href="https://i.stack.imgur.com/QzYAY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QzYAY.png" alt="enter image description here"></a></p>
  
  <p>Now i want to know, </p>
  
  <p><strong>how can i quick search using <code>JOIN</code> and <code>CONCAT</code> columns?</strong></p>
  
  <p><strong>Is there specific way to do this?</strong></p>
  
  <p>please suggest me the best way...</p>