1. Hugh (cheesegrits) here. Thank you for all the good wishes. My back surgery was a success, post-op recovery is going well, and I'm getting stronger and feeling better every day. I hope to be getting back in the saddle and working support again over the next few days.
  2. IMPORTANT NOTE - we have made some changes in our github branch naming. The 'master' branch no longer exists, and is now called 'joomla25' (which is Fabrik 3.0). The 'joomla3' branch (which is Fabrik 3.2) remains unchanged. We have also removed all the other testing branches which had accuulated over the last few years. I have posted a thread in the Community forum for 3.0 with some more information, feel free to as questions there.

Pre-filter with condition IS NOT NULL not working

Discussion in 'Table templates' started by productid, Apr 4, 2012.

  1. productid New Member

    Level: Community
    I want to filter records from my table view where the element "discharge date" is empty. In other words, I only want to see records that have a discharge date present.

    I have set up a table pre-filter with the following:

    WHERE: "Discharge Date"
    CONDITION: IS NOT NULL
    VALUE: No Quotes
    APPLY FILTER ON OR BENEATH: Everyone

    It is not filtering out the records without the discharge date present.

    Please help! Thank you.:)
  2. productid New Member

    Level: Community
    friendly bump

    It has been 5 days since I posted.
  3. troester Well-Known Member

    Level: Standard
    You should post in Bronze forum and it's Easter weekend.
    Empty is not necessarily NULL. You can check directly in the database (phpMyAdmin) if your dates are empty, NULL or 00:00:00.

Share This Page