Upgrade Your Drupal Skills
We trained 1,000+ Drupal Developers over the last decade.
See Advanced Courses NAH, I know EnoughViews Or Filters Drupal 6 tutorial
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
About Drupal Sun
Drupal Sun is an Evolving Web project. It allows you to:
- Do full-text search on all the articles in Drupal Planet (thanks to Apache Solr)
- Facet based on tags, author, or feed
- Flip through articles quickly (with j/k or arrow keys) to find what you're interested in
- View the entire article text inline, or in the context of the site where it was created
See the blog post at Evolving Web