At one point, this table was grouping by the Status field (as well as hiding the status column). Now neither of those are working. Can you help me pinpoint why it no longer groups and hides?

<?php
    DataTables::create(array(
        "dataSource"=>$this->dataStore('client_tasks_by_project_id'),
        "options"=>[

          "order"=>array(
            [3,'asc'],
            [0,'asc']),
          "ordering"=> false,
          "rowGroup"=>array(
            "dataSrc"=>[3]),
            "columnDefs"=>array(
                array("visible"=> false,"targets"=>3),
                  )
        ],


        "columns"=>array(


                      "ID"=>array(
                        "label"=>"",
                        "formatValue"=>"<button type='button' class='deletebtn'>Omit @value</button>"
                      ),

            "Task"=>array(
                "label"=>"",
                 "autoWidth"=>true
            ),

            "Description"=>array(
                "label"=>"",
                 "autoWidth"=>true,
                "formatValue"=>function($value)
                  {
                   if($value!="-")
                   {return $value;
                   } else {
                     return "";
                     }}
              ),

              "Status"=>array(
                  "label"=>"",
                   "autoWidth"=>true
              ),

            "File"=>array(
              "label"=>"",
               "autoWidth"=>true,
              "formatValue"=>function($value)
                {
                 if($value!="-") {return "<a href='https://teamkrs.com/uploads/attachments/".$value."' target=_blank><img height='auto' width='450px' src='https://teamkrs.com/uploads/attachments/".$value."' /></a>";

                 } else {
                   return "<img height='auto' width='450px' src='https://reports.teamkrs.com/assets/images/no-image-available.jpg'/>";
                   }}
            )
        ),

        "cssClass"=>array(
            "table"=>"table-bordered table-striped table-hover table-responsive",
            "td"=>function($row,$columnName){
              return ($columnName=="ID")?"noprint":"";
    }

        )
    ));
    ?>

Thank you!

Hi, David,

I'm on Version 3.0.0 of Datagrid. Screenshot attached.

Hi, David,

Updated Datagrid but still having the same issue. Here's a copy of the datasource code, just in case that's doing something it shouldn't be doing:

//Creates datastore tasks_by_project_id; used for displaying tasks and associated comments and files
       $this->src('teamKRS')
       ->query(MySQL::type(DB::table("tasks")
         ->where([
           ['tasks.projects_id',$projID],
           ['tasks.in_trash',NULL]
         ])

 ->leftjoin("tasks_status",'tasks.tasks_status_id','=','tasks_status.id')
 ->leftjoin('tasks_comments', function ($join) {
 $join->on('tasks.id','tasks_comments.tasks_id')
          ->where('tasks_comments.in_trash',NULL)
          ;
        })
 ->leftjoin('attachments',function ($join) {
 $join->on('tasks_comments.id','attachments.bind_id')
          ->where('attachments.bind_type','comments');
        })
   ->select('tasks.id')->alias('Task ID')
      ->addselect('tasks.id')->alias('ID')
   ->addSelect('tasks.name')->alias('Task')
   ->addSelect('tasks_status.name')->alias('Status')
   ->addSelect('attachments.file')->alias('File')

   ->leftjoin('extra_fields_list',function ($join) {
   $join->on('tasks.id','extra_fields_list.bind_id')
            ->where('extra_fields_list.extra_fields_id', '111');
          })
     ->select('extra_fields_list.value')->alias('Description')
      ))


      ->pipe($this->dataStore("client_tasks_by_project_id"));

Sent!

The koolreport folder is up one level from the report's php page and is at the root of the public directory. I checked and the KoolReport.js file is in the right path. The one thing I can see is that the source should be at '/koolreport/...' rather than have the initial "reports" directory.

The rest of the DataTables is working correctly, though? Meaning the data is displaying in a table.

Here's the report's php file as well.

https://www.dropbox.com/s/vn7w3hld8xaktyn/ClientReport.view.php?dl=0&m=

If you need FTP access, please let me know and I'll email it that to you. Thanks.

https://www.dropbox.com/s/dmqmgqk1kwgu3fg/ClientReport.php?dl=0&m=

Any update on this? Thanks.

I'll email you the link since it has our connection information.

Any update?

Sent!

Works great; thank you!