I've moved this across from the Views issue queue following advice from merlinofchaos - #761530: Trying to filter a Node type view that uses Row Style:Node with a CCK Content field

Can anyone please tell me if this is a bug or if I'm doing something wrong...I'm trying to filter a view by the state of a CCK Field as Integer (Single On/Off Checkbox). The View is display is a Page and the Row Style: Node.

I've tried all sorts of combinations of settings for this but it just seems to ignore them all. I've tried both Content options as filters as well, both the "content field" and "content field - allowed values".

The view is attached if necessary.

Many thanks for any help in advance.

CommentFileSizeAuthor
homepage-view.zip1.48 KBaxel pressbutton

Comments

jdln’s picture

jdln commented

Subscribing

berliner’s picture

berliner commented

I found a similar issue using Views 6.x-2.11, CCK 6.x-2.8 and Drupal 6.19. I have a single select checkbox (Integer field) and I can filter for the checked state, but filtering for unchecked will only show nodes that actually have a 0 value in this field. It does not show nodes that have been created before this field has been added to the node, so where the actual value would be a NULL value.

anthonyR’s picture

anthonyR commented

subscribing

sam.hernandez’s picture

sam.hernandez commented

subscribing

guoli’s picture

guoli commented
Version: 6.x-2.6 » 6.x-2.9
Issue tags: +cck checkbox views

I've encountered the same problem!

gagarine’s picture

gagarine commented
Category: support » bug

same problem than #2

They are no way to filter by checked or unchecked because unchecked can be 0 or NULL.

Of course if you add your field before inserting node every things is all right because they will all have a value but that's not the case if you add a field after...

gagarine’s picture

gagarine commented

Linked #920176: Update "Default Value" for Old / Existing Node CCK Fields

todd zebert’s picture

todd zebert commented

subscribe