Filter on a field that has various possible values

Anonymous

#267437

Hi folks,

I have a particular use case I was wondering if S&F can handle.

One of the ACF fields I´m trying to include as a filter in my search form has tons of possible values. Actually, the field in the database can have one of the following 2 options:
1. There could be content in the field. ANY content. Any possible string of characters could virtually be in the field.
2. Blank.

I would like to set up a filter in my search form, with a radio button for instance with a YES or NO, where my site visitor selects either YES or NO:
1. YES would throw every post where the said field contains ANY content.
2. NO would throw only posts where the said field was left empty.

Can you think of any particular work-around I may use to achieve this?

Thanks in advance,

Trevor

#267468

I understand. The problem is that, with WordPress, if the field is empty, it doesn’t actually exist in the database for that Post ID, so the only workaround would need to be a second field, which is a Logical (1/0, Yes/No, True/False) type of field, which you must set to always have a value. If you create such a field, you would need to go back to existing posts and edit them to have a value.

[Author]

Posts