When searching a view, there is a particular column(field in the form) that cannot be searched using the advanced search (magnifying glass). I can sort on the column then use a simple search but the users want to be able to use the advanced search for everything.
Is there something in the form design that needs to exist?
Thanks in advance, Paul
Subject: Search this view tool might help
There are ways to search fields for indexed views it’s best to use the tool to get the syntax correct.
When in you inbox under the “View” menu there is “Search this view”
This will bring up the search control. If your view is indexed you can expand the more section.
Here you will see that you can specify a field on the documents to search.
Once you’ve searched using this, the searches will be under advanced / magnifying glass search.
Just click on the down arrow (before the edit field of the magnifying glass) for the “Select a search scope”->“Recent Searches”
So if you where to choose the “From” field and search for Paul the “Recent Searchers” would now contain:
([From] CONTAINS (Paul))
You can see from above that the field search is pretty easy to do on your own. You can now add things like an “OR” statement
([From] CONTAINS (“Paul M Gaschke” OR “Paul Gaschke”))
If for instance you wanted to search subjects for “Summer vacation” instead you’d use the following
([Subject] CONTAINS (“Summer vacation”))
However not all the fields are the same format which is why i’d use “Search this view” for instance date would be something like this:
([_CreationDate] = 20100707)
Now these can be copied to the advanced / Magnified glass search.
Again please note that this will not work on indexed dbs.
Subject: thanks but not what I was looking for.
Anders, thanks for the info but I’m afraid this is not working either. Users need a simple way to search. Press the magnifying glass search, type the search data and find their document.
Interesting that I can sort on the column then without the advanced search, just type the search number and it finds the record.
Also, I tried to used the advanced search by form but the form I want to search is not is the list. Any ideas why not? Other forms are there.
Thanks again, Paul
Subject: Search Form
A form can be excluded from the search builder if the developer so chooses.
For your search problem try rebuilding the view index and\or the full text index.
Subject: Thanks
Thanks Carl, I got it working now.
Take care, Paul