DataAssist Search Feature - multiple conditions not filtering
Hi - I have a site where we will be searching on members' credentials.
We are searching First upon their Interests,
Second upon Age groups treated,
Third upon their geographic location.
I am hoping that this feature, using the Search asisstn wizard from within Data Assist, will help me achieve this.
However, the search seems to only work to filter one criterion, the first one.
If a keyword exists within the first field Interests, but the following two conditions are not true, it will still return the results as long as the first result is true.
Search terms are taken from a drop down list and if they are included in the field being searched, the result gets returned. There are manytext words within the field being searched, so it is OK to return a lot of results.
Each search term uses the drop down list, and if that term is contained within the field being searched we want the result.
However, we are getting results when one or two conditions are true, not all three. That's bad.
Say I want a doctor who treats depression in children in syracuse new york, I do not want to see the doctors in New York city, yet that is what I get.
In the data assist search screen I am using Filter on Keyword, included in field and the AND connector for the other two criteria.
How can I refine my searches so that all conditions are true, only returning those results, and giving an Empty results reply when the results are false?
AND, if that doesn't work, how can I apply a second search behavior on a results page?
thanks. URLS are:
SEARCH PAGE:
search_by_INTERESTS.php
RESULTS PAGE:
results_matrix_interests.php
elizabeth