What can we help you with?

e.g. Getting Started, Build Dashboards

Optional filter selection in Direct Query filters

1 comment

  • Official comment
    Avatar
    Jay

    You can use something like this in the where clause

    AND (delivery_region.name in ($c9_region$('')$[Region]${list|'|,}$) or $c9_region$('ALL')$[Region]${list|'|,}$ = 'ALL')

    When  Region is specified in the filters, Region is applied. Otherwise the condition is always true (skipping the and in effect). 

    Comment actions Permalink

Please sign in to leave a comment.