I suspect the reason that you do not see your checkboxes filter is that your posts do not have any checked options (so there is no data saved for the field in the posts themselves), and you have the default View search option set to "Show only filter options that would produce results".
Because no posts have checked options, there are no options to show that would produce results.
Once you start checking options in the posts the filter should appear, or you can remove the above option from the View Search settings.
Can you show a screenshot of what you mean by the bad field names you want to remove?
ok .. the page where I am adding the view, only shows products where the checkbox in question is located. and I know they've been checked because when I added another checkbox field with only 1 option, that item shows up in the view query filter list.
The multi option CHECLBPXES field, that's won't show up in the query filter list, is named SKU Attribute
The single option CHECKBOXES field, that does show up in the query filter is named SKU Show Stocked in USA?
Screenshots:
2 x bad data in the query filter list that I would like to be rid of (the tall skinny ones)
1 screen shot showing the query filter section (good values have SKU prefix) (working single option checkboxes are located amongst the bad data and are not listed with the other SKU prefixed items.
1 screenshot showing the checkboxes field set up for SKU Attributes
1 screenshot showing the checkboxes field set up for SKU Show Stocked In USA?
Again, no CHECKBOXES field fields are listed in the query filter menu ... only CHECKBOXES fields with single options are.
Would you mind allowing me admin access to the site so that I can have a more detailed look at this one for you.
Secondly you can delete the custom fields that are no longer being used by going to Toolset -> Custom Fields and scrolling down and clicking on Post Field Control.
Just search for the custom field that you want to delete and you can permanently delete it from there.
SKU attributes should be showing up now. What I did was to set the field to "When unchecked, don't save anything to the database" then go into one of the sku posts and then just resave the post.
If you check your view you should see the SKU attributes field showing up now.