You are missing some Flash content that should appear here! Perhaps your browser cannot display it, or maybe it did not initialize correctly.
View Related Blogs
Utilizing views as a theme layer to a custom query
Monday, October 19, 2009 - 2:50pm - Kurt Vanderwater
We had a client requirement that a single view be the combination of:
- a random list of attorneys with offices in a given state
- a random list of attorneys that are licensed in a given state.
There should be no duplications and all of list 1 must precede list 2. We could not accomplish this with views alone. After talking to Earl, we were able to access the created SQL statement within views. Here we built each of the two queries. Then, we defined a 'pre' exit and replaced the query in our view with a new one.
Drupalcon DC Sponsorship
A proud sponsor of Drupalcon DC!
Feed Options:
Blog Tags
AEgir
Branson Area
Content Management System
CSS
Drupal
Drupalcon
Drupalcon Boston 2008
Drupalcon Szeged 2008
Drupalcon Washington DC 2009
Drupal training
Drupal User Group
drush
Firefox
Imagefield_gallery
Modules
MySQL
Oklahoma web
Open Laszlo
Open Source
script
The Worx Company
Web Design
Web Development
Web Hosting