By krisvannest on

How does one test for an empty CCK field inside the Views module interface (not via php)?

I want my View to show only nodes that have a particular CCK field non-empty.

For instance, I have a CCK text field that is actually a URL (setup through CCK) and called:

  • Link: Tix (field_tix)

I want to add a Views filter that only shows nodes that do not have that field empty. I added the CCK field to my Views filter and it gives the option of "Does Not Contain"... but I'm not sure what to set it to for an empty/null value? I tried leaving it blank, entering "null" and "NUL" (both sans quotes), but none seem to work as the View always returns all nodes, even if that URL CCK field is actually empty.

BTW i searched the forum, but only found this reference to testing CCK for empty that was one via php (not inside Views interface).

Thanx,
KV

⋅ Categories: Drupal 4.7.x

Comments

chrisfab’s picture

chrisfab commented

Hey I'm facing the same issue these days.

Did you ever work out how to do this?

krisvannest’s picture

krisvannest commented

Alas, no... I ended up implementing the concept differently just to get around not knowing, but I'll repost if I visit it again (and please do likewise/if you find a solution).

Piyavkin’s picture

Piyavkin commented

Try this:

Operator = 'Contains';
Value = '_'; or Value = '%_';

Filtration use MySQL operator LIKE, and '_' is a wildcard that means exactly one any character.

See also my feature requests: http://drupal.org/node/164518 (but I'm not shure that my English is clear enough...).