Query not fetching any result #3425

Closed sabeeha opened this topic on on Mar 16 - 1 comments

sabeeha commented on Mar 16

$this->src("mysql")

    ->query("SELECT company_name_en, country_code FROM clients 
      WHERE type = \"supplier\" AND created_at > '2024-02-08 23:59:59' and status = 1 and supplier_type not like \"Association\"")
    ->pipe($this->dataStore("clients"));

Sebastian Morales commented on Mar 20

Pls copy your exact sql query in your database interface to see if it returns any data. Also try this simple sql query:

MyReport.php:

<?php
$this->src("mysql")
    ->query("SELECT company_name_en, country_code FROM clients")
    ->pipe($this->dataStore("clients"));

MyReport.view.php:

<?php
    print_r($this->dataStore("clients")->data());

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

Labels

help needed

Related package None

KoolReport's Forum

Query not fetching any result #3425

Build Your Excellent Data Report