Support Forums

Support Forums › Forums › Search & Filter Pro › Filter on a field that has various possible values

This topic is: not resolved

Tagged: 

Viewing 2 posts - 1 through 2 (of 2 total)
  • Mario Pérez
    (Private)  November 21, 2020 at 4:11 pm #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 Moderator
    (Private)  November 23, 2020 at 10:44 am #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
Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.