Utilizing views as a theme layer to a custom query
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.