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

P
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

K
KoolReport commented on May 24, 2019

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

P
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

D
David Winterburn commented on Jun 4, 2019

Hi Paulo,

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

P
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

D
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