KoolReport's Forum

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

Why is this filter not working? #2134

Open Richb201 opened this topic on on Jun 8 - 3 comments

Richb201 commented on Jun 8
        ->pipe(new Filter(array(

        "table"=>"table table-hover"

I get "No data available in table". Those two filters are being 'anded", right?

Sebastian Morales commented on Jun 9

You can't pipe a datastore in a widget like that. Do not invent your way. Either pipe filter in your report's setup or in a function in a widget's `dataSource, or filter a datastore like this:

    $filteredDatastore = $this->dataStore("ius")

Then use $filteredDatastore for your widget. Rgds,

KoolReport commented on Jun 9
Richb201 commented on Jun 9

I got it to work by using this in the setup.

    SELECT *
    FROM business_components
    WHERE email='$email' AND campaign='$campaign' AND IUS='1'
        ->pipe($this->dataStore("ius"))  ;


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
help needed