Have a checkbox field in my profiles. In a User view, I added that field to the view and an exposed filter. It will find records w/a value of "true" but not records w/a value of "false." I suspect that these records actually have a value of null not "false," but there's no filter option to find null... and the table actually displays "false" rather than an empty space or "null."

So I can't filter to find users who have failed to check that box.

CommentFileSizeAuthor
#5 416178-profile_empty.patch442 bytesdawehner

Comments

dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Fixed

I guess with http://drupal.org/node/508124#comment-2044470 it works now.
Feel free to open the issue again.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

rsbecker’s picture

rsbecker commented

I am having this problem with the dev version of Views downloaded today, 6.x.2.dev. I also had it with 6.x.2.8.

It appears not to be fixed yet.

Offlein’s picture

Offlein commented
Version: 6.x-2.3 » 6.x-2.10
Status: Closed (fixed) » Active

I am experiencing this with Views 6.x-2.10.
I have a profile checkbox field saying "Opt out of user directory" and I want to include people that have not checked that box. But if no one has checked it, they seem to appear as null.

I think the simple fix is to modify around Line 152 in views/modules/profile.views.inc and, inside the 'filter' array for the 'checkbox' fieldtype (this is all in profile_views_fetch_field() ) simply add a key of 'accept_null' with the value of TRUE.

dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Needs review
StatusFileSize
new 416178-profile_empty.patch442 bytes

Here is a patch for the solution in #4

Profile is definitive not the module with the best datastructure/storage.

merlinofchaos’s picture

merlinofchaos commented
Status: Needs review » Fixed

Committed to all branches.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.