Choosing the right framework for your website sets you up for success as your business grows and can save you money throughout its lifetime.
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.