{"id":764,"date":"2022-08-30T15:06:47","date_gmt":"2022-08-30T15:06:47","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2013\/11\/09\/filtering-a-view-by-a-checkbox-field-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:06:47","modified_gmt":"2022-08-30T15:06:47","slug":"filtering-a-view-by-a-checkbox-field-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/filtering-a-view-by-a-checkbox-field-collection-of-common-programming-errors\/","title":{"rendered":"Filtering a view by a checkbox field-Collection of common programming errors"},"content":{"rendered":"

My site has a node type called “Resource”. This node type has a field called “Reviewed”; this field is a single on-off checkbox:<\/p>\n

<\/p>\n

I’ve created a view that lists all of the nodes of node-type “Resource”. I’d like to filter that view so it only displays nodes that have the “Reviewed” checkbox checked. However, when I try to add that field to my view, I’m shown the following:<\/p>\n

<\/p>\n

I would expect the “Options” select box to be a checkbox that I could either check or leave empty. Instead, I’m given a select box with “Select all” in it. Whether I select this or not, I’m then presented with an error message saying that there are “No valid values found on filter: Content: Reviewed.”:<\/p>\n

<\/p>\n

I’ve tried the “exposing the master display trick” at http:\/\/technology.blue-bag.com\/top-tip-drupal-views-no-valid-values-found-filter, but that hasn’t worked: there’s no “unknown” filter in the master display, so there doesn’t appear to be anything to fix.<\/p>\n

Any idea as to how I can achieve the result I’m looking for? And what’s the deal with the strange UI with the select box rather than a checkbox? Would be good to know if there’s some logic to it; if not, I’ll post an issue to the appropriate drupal.org issue queue.<\/p>\n

    \n
  1. \n

    this is some sort of a bug \/ incosistency of how the boolean field is made. if you leave it in default, without any 0 \/ 1 values, it wont show them in places like this filter. But : the values are there \ud83d\ude42 under “Select all” you have 2 rows that just dont have captions. When you pick one of them, you can see that the SQL for your view is changed.<\/p>\n

    The workaround would be to add some captions to the values in the field defintion.<\/p>\n<\/li>\n<\/ol>\n

    Originally posted 2013-11-09 22:40:38. <\/small><\/p>","protected":false},"excerpt":{"rendered":"

    My site has a node type called “Resource”. This node type has a field called “Reviewed”; this field is a single on-off checkbox: I’ve created a view that lists all of the nodes of node-type “Resource”. I’d like to filter that view so it only displays nodes that have the “Reviewed” checkbox checked. However, when […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-764","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/764","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=764"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/764\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}