I'm working on a views integration where the table and its fields are exposed to views. I want to give users the ability to filter on results of this view based on 1 of 3 fields.
I want each of the three fields in a drop down, and one text field where the user can input search terms.
Then once submitted, views will filter on the specific field and terms entered.
Is this possible? I found this discussion which has no resolution: https://drupal.org/node/732458
I'm thinking I may need to just create exposed filters for each of the three fields, and then alter the form a bit to get it how I need it.
To clarify further:
I want to expose three filters, each one searches a field by the text a user entered. I can do this in Views no problem, and it produces three distinct text fields for each of the three filters. Instead, I want the user to have just one text field, and a drop down to select which one they want to search on.