Thanks Teodor, I didn't realize this question fell under the same topic, but having read it again, I can see that it clearly does. Such a bummer...
I've been using the new database extensions since the day you released them, so I'm all too familiar with creating extra db Views, in order to keep the filtering done by the database connector at the basic level.
The problem in this case, is that I wanted to have one page which could be used to filter all report data.
- There's the search capabilities, which need to query several db fields with one search box.
- Then there's a status filtering mechanism. I am using a dropdown select to toggle between active and pending statuses.
To do this with views, I will need to create two of them; one view for each status (active/pending). On the front end, I guess I could use tabs to view each list and search, but that's not nearly as easy to use as one list would be with a dropdown for status and a search box.
Maybe this would work....
1. Build my two views for each status
2. Build the page with two identical lists (one after the other)
3. Use a dropdown at the top to select active/pending
4. Use the data.hide / data.show features to only show the list that is selected in the dropdown. (Each list will have it's own search tool)
Do you think it would like this? It would appear as if there was just one list (like I'm wanting). Can you help me out with how to bind the dropdown selection to displaying the correct <span> region?