3 Replies Latest reply on Dec 11, 2019 4:07 AM by Gaspare Provenzano

    Issue when using custom filter macro

    Poppy Maxwell
      Share This:

      I am using a custom filter macro in a SQL data mart to filter by entname, the macro I am using is "WHERE 1=1 ${CUST_FILTER(ENTNAME, AND t0.ENTNAME = ?)}".

      I am using this SQL data mart in a data mart explorer page in the presentation server and have added an entname filter to the page.

      There are no issues if I choose one system in the filter but if I try to choose two or more systems no data is displayed on the graph. Can I change the macro to handle multiple systems?