We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!

Answered Migxdb filtering

    • 44580
    • 189 Posts
    I want to create a simple filter:
    where user_id is NULL
    in my Migxdb CMP. I want this filter applied before the grid is displayed rather than a post-display filter (I hope that makes sense).

    I'm sure this is simple, but for the life of me I cannot see where/ how it is done.

    Robert.

    This question has been answered by Bruno17. See the first response.

    • discuss.answer
      • 4172
      • 5,888 Posts
      In the MIGXdb Setting tab there is a field 'where'

      put there:
      {"user_id":null}
        -------------------------------

        you can buy me a beer, if you like MIGX

        http://webcmsolutions.de/migx.html

        Thanks!
        • 44580
        • 189 Posts
        Thanks again Bruno. I thought it would be that easy - just needed the syntax. Works perfectly.