For example, the search above is looking for records that were created on a Monday, in June, of any year. The
search found 10 records out of the 246 records that were searched.
Now if we wanted to know which of these records were created in 2020, during the AM hours, we could run two
more consecutive searches, on the records above to find them. Here's one way of doing these searches.
Start by erasing the 'monday, june' keywords in the Search field, and replace them with a blank space
and then the letters 'am'.
Then click the Search hyperlink. This new search finds 7 matching records,
from the 10 records that were searched.
Now to find which of these were created in 2020, we clear the ' am' keywords and replace them with
'2020',
and then click the Search hyperlink again. Now we have 1 matching records out of the 7 that were
searched.
The important thing to remember about regular searches, and especially consecutive searches, is that
they're
always searching just the set of records being displayed by the window.
The only time they'll
search
all of the Idea records in the Ideas database, is if you start the search by clicking on the Reset
hyperlink
(or the All Ideas hyperlink, in the Sort Ideas section of the hyperlinks list) first. Doing that,
loads all
the Idea records in the database into the window.
You'll see an Advanced Search Settings dialog box pop up, and you can use it to select the fields you
want
searched, and then configure the rules for what's to be searched in that field, how comparisons are
made,
and how many of the keywords have to be found in each searched field.
In this image the dialog box is configuring a search on the Creation Date field of a Idea
record.
This
search is doing the same type of search that we used the set of consecutive, regular searches above,
to do.
But this time, it's only the Creation Date field, not all the fields in the record that are being
searched.
Also, we get to use, in one place, all the keywords we used in the consecutive regular searches
above.
After the Search hyperlink in the dialog box is clicked on, only 1 record, out of the 246 that were
searched,
started on a Monday in June of 2020, during the AM hours.
For more details about how to do Advanced Searches on Idea records, click here.