Views Or allows you to define filter blocks with multiple alternatives in drupal views.
for the video inclined here’s the two minute walk through – http://www.youtube.com/watch?v=pWE78xQK3Z0
A bit sleepy this morning and forgot coffee. It shows, I know.
Use case: we have some old data – some of it comes in with the number 0 meaning blank, some of the rows contain the word NULL and some of the rows are empty. All three variations mean the same thing. We want to create a single view with all three options open – if it’s the number 0 OR the word NULL or simply empty.
Installation and usage: Install as usual – obviously you’ll need views installed…. To use you will need to add all three of the new fields into your filters block. First will be the “Begin alternatives” then the “Next alternative between your filters, (repeated for as many alternatives as you need) and lastly you’ll need to “end alternatives.”
As a lazy lad I like to just add them all at once and then move the options around afterwards, do whatever your gods tell you to…
Programmatically what this has achieved is
AND ((UPPER(node_data_field_er_acq_uid.field_er_acq_uid_value) = UPPER(‘NULL’)) OR (node_data_field_er_acq_uid.field_er_acq_uid_value IS NULL))
In any case it’s a pretty simple module – installs well and saved us from cruddy data. Merci a bunch to all