[Plugin: Contact Form 7 to Database Extension] Boolean Filtering for database

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    13 years, 7 months ago

    Yes, on your Database Short Code page, you can create a short code or an export link. Use the “filter” field like filter=”Column3!=null”
    Documentation

    Thread Starter Kerryfenn

    (@kerryfenn)

    13 years, 7 months ago

    Thanks Michael for getting back to me. What is the opposite of null? i.e. if there is data then get.

    Plugin Author Michael Simpson

    (@msimpson)

    13 years, 7 months ago

    Opposite of =null is !=null. Look at my last post again.

    Thread Starter Kerryfenn

    (@kerryfenn)

    13 years, 7 months ago

    Thanks Michael, sorry but I’m new to this, thank you for setting me straight.
    I am managing to get the filters working nicely but one question: My clients enter a date by which they require services, (often some time in the future and rarely the date they entered the data) . Can I filter them out once this date has passed? Thank you

    Plugin Author Michael Simpson

    (@msimpson)

    13 years, 7 months ago

    Not nicely no. The user is entering a date but it is treated as just text. The filter logic is not smart enough to convert to a date and do logic like > or <. Sorry.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘[Plugin: Contact Form 7 to Database Extension] Boolean Filtering for database’ is closed to new replies.