Latest: ChronoForms v8.0.51 update

Select entries where NOT null or empty

Select entries where a field is not null or empty.

Overview

The issue is needing to filter database records to exclude empty or null values in a specific field.
Use a 'greater than' condition with an empty string as the value in the Where clause to retrieve all non-empty and non-null entries.

he healyhatman 28 May, 2018

As the title says - what do I put in the Where conditions to retrieve all entries where fieldname is NOT empty or null

he healyhatman 28 May, 2018

Answer

Never mind I got it

Where conditions:

fieldname/>:''

Will get me all the entries where fieldname is not NULL or an empty string.

This topic is locked and no more replies can be posted.