KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Why isn't my searchable report showing the up/down arrows in the columns ? #889

Open paulo opened this topic on on May 24, 2019 - 5 comments

paulo commented on May 24, 2019

If I look at the example, each column has an up/down arrow. But when I implemented this, the arrows don't show up. Please help. thank you

KoolReport commented on May 24, 2019

Are you using DataTables widget or normal Table? Only DataTables has arrow to sort data.

paulo commented on May 27, 2019

thanks, I am using this: use \koolreport\datagrid\DataTables;

<?php

DataTables::create(array(
    "dataSource"=>$this->dataStore("searchabletours"),
    "options"=>array(
        "searching"=>true
    ),
    "columns"=>array(
        "tourid"=>array(
            "type"=>"text",
            "label"=>"id",
            "formatValue"=>"<a href='https://my.ellisontravel.com/tour/tours/@value'>@value</a>"
        ),
        "tourname"=>array(
            "type"=>"text",
            "label"=>"Tours"
        ),
        "planner",
        "CountryName",
        "startDate",
        "endDate",
        "insurance_number"

    )
));
?>

thanks

David Winterburn commented on Jun 4, 2019

Hi Paulo,

Does this searching problem remain with the DataTables widget? Thanks!

paulo commented on Jun 4, 2019

yes, this is the datatable I have always used. It is not a searching problem, it is just the arrows don't show up. So users don't know they can resort. thanks

David Winterburn commented on Jun 5, 2019

Hi Paulo,

Please try to set the DataTables widget "ordering" option:

            "options" => array(
                    "ordering" => true,
                    ...
            )

Let us know if this shows the column sorting icons for you or not. Thanks!

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
None yet

None