Stimulsoft Business Intelligence System | Forum

Posted: **Tue Jul 14, 2020 10:04 am**

I have the following filter for my graph,

(Reports.teamN == TeamN || All ) || Reports.teamN == "NOTEAM"

The query returns "NOTEAM" if the record is null. The All is a boolean variable. TeamN is a variable tied to a datasource and gets all team data from a datasource. I want the filter to consider "NOTEAM" if records are null but it does not look like it is doing it.

Here is a part of my mysql query for my datasource,

Code: Select all

SELECT 
    CASE
        WHEN r.teamN IS NULL THEN 'NOTEAM'
        ELSE r.teamN
        AS teamN

How can I be sure it is working as expected because right now I am not seeing records with "NOTEAM" in my chart

Thank you

Posted: **Wed Jul 15, 2020 9:32 pm**

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

Stimulsoft Business Intelligence System | Forum

Filter on graph datasource

Filter on graph datasource

Re: Filter on graph datasource