Hi team

I'm new on Koolreport

I have try to build a simple example reading data from postgresql database to a table. But the result it is not too correct. At the end, koolreport prints:

            $this->dataStore('db_sql_data')

and the data as a table with all fields:

    $this->dataStore('db_sql_data')
    model	system	time_metr

Could you help me to looking for the issue?

Note:

I tried to do the same by php and pg connector, and the test was ok.

Thanks

Thanks for your reponse.

This is an output image

It never do the next step

I forgoten to write the code. I think it could be usefull. This is it:

class TestDB extends \koolreport\KoolReport
{

    public function settings()
    {
        return array(
            "dataSources"=>array(
                "logml_db_conn"=>array(
                    'host' => 'localhost',
                    'username' => '************',
                    'password' => '***********',
                    'dbname' => 'logmldb',
                    'charset' => 'utf8',  
                    'class' => "\koolreport\datasources\PostgreSQLDataSource"  
                ),
            )
        );
    }
    public function setup()
    {
        $select_query = "SELECT * FROM ml_log_table
            Where date_part('year', timestamp) = :pyear
            and time_metr = :ptime_metr
        ";

        $this->src('logml_db_conn')
        ->query($select_query)
        ->params(array(":pyear"=>2022,":ptime_metr"=>"SEC"))
        ->pipe($this->dataStore('kl_data'));
    }    
}

Yes!!!

Thanks Sebastian!!!

Muchas Gracias, has dado en el clavo!!!, era el nombre, mayusculas y minúsculas.!!! You are right, it was the name, the class name and the file name must have the same case sensitive