Thread

Now I preface with the knowledge that Date fields are not supported by the exp:channel:entries search parameter, but in my case, I’m attempting to display a list of entries where a specific custom date field is actually empty (ie. is yet to be set).

This is the code I’m using:

{exp:channel:entries
    channel="members"
    dynamic="off"
    status="Open"
    search:cf_members_card_printed_date="IS_EMPTY"
    category_group="11"
    group_id="8"
    limit="50"
}

Now I’ve had a squizz at the channel module code and can’t seem to find any fieldtype checking for this parameter per se, so wondering why if the field data doesn’t exist, why the above would be returning nothing. I guess the real question is, does the channel entries tag really exclude any date fieldtypes specifically.

Thanks
Brendan

Hey Brendan,

Good question.

The answer took a bit of digging into the code and testing. I appreciate questions like this.

So basically the field is not empty, since it’s a date there is a 0 entered. So searching for IS_EMPTY will no work since there is actually a value in the date field.

I hope this helps. Anything else I can help you with?

Cheers,

Shane

That did the trick. Changing the search parameter to check for ‘0’ instead gives me the desired returned listing:

{exp:channel:entries
channel="members"
dynamic="off"
status="Open"
search:cf_members_card_printed_date="=0"
category_group="11"
group_id="8"
limit="50"
}

Thanks again.

Cheers
Brendan

Hey Brendan,

Glad to hear it!!!

If you need anything else, please just let me know by opening a new thread.

Cheers,