[Resolved] Views custom field filter options are not all displayed

[Author]

Posts

[chrisF-19]

I am trying to: filter by category and media - these are both custom fields

Link to a page where the issue can be seen: hidden link

I expected to see: all categories and media items; when filtering by category, it should still show all media types

Instead, I got: only the categories and media; when you select a category and filter, it only shows some of the media (and vice versa). The only reason these are showing is because i manually went into each entry and updated it. For some reason these things aren't talking.

[Beda]

That sounds like a cache issue, or database corruption.

If it's the cache, you would have to make sure it's not happening without those cache softwares.
See here how to for example disable Total Cache:
hidden link

It's not possible to simply disable them - one needs to really remove the code and data cached.

If then the issue persists it could be a database corruption in the sense of:
- there is data saved, in the posts, that does not match what the view searches.

So this can either be because some wrong data was entered in a syntax or method that corrupts the actual value, or, due to a past BUG, the data was wrongly saved and now not read anymore as correct (hence, when re-saved, it works).

To know which is the issue of both, you can first test the steps for the cache (the simplest is to mirror the site to a staging test site, which is not cached)
If that doesn't help, I think the best is you send me a copy of the database, that should be enough to see what is wrong wit the data.
I will already enable a private reply.
In case your Database is Secured, let me know, so I am not blocked out due to some security plugin or any similar on the website.
If you cannot provide a database copy, maybe I can work with an export of all views and types in Toolset > Exports.

Please let me know if the issue persist after those steps and if possible include either of the data above mentioned in case it persists.

[Christian Cox]

Hi, please edit this View and go to the Custom Search settings. Choose "Let me choose individual settings manually", and you will find an option that tells the View to always show all values for inputs. If that option is not selected, only inputs that will produce results will be displayed in the filters. If adding an input would cause an empty result set, that input is hidden or disabled. I think what has happened here is this option is not selected, and the manual settings are not displayed so it's not obvious.

[chrisF-19]

Oh my goodness...how strange. The rest of the views don't have these options selected but worked fine. But this change worked!

Thanks so much!