|
Keeping in pace with my supporters, I decided to
contribute with a search tutorial, and use
John's great catalogue. I will Show you how easy
it is to use the powerful "like" criteria, one
you'll be using often as it narrows down the
long strings of text characters, even if you
don't know if it is in the beginning or middle
of the string.
|
|
|
First I bring you his 'Nissan' Category (John
decided he didn't need any Sub-Categories as you
know from previous tutorials), so I can show you
what he has there: 3 models of Nissan vehicles.
Notice that two of them have "GTR" in the model
name also.
|
|
|
I
Pick the Any Category (this is default by the
way)
|
|
|
Here I confirm that John has no Sub-Categories
|
|
|
Click the box to include the next set of items
to search for and criteria
|
|
|
from the first droplist I decided on the 'Name'
as the Item to search for. The Idea is to search
for the "GTR" text word. The thing is I am
pretending not to remember the main name
(Nissan) of the vehicle make which includes the
model name GTR (the only thing I remember), so I
am hoping that by searching for GTR I will get
the respective images brought up and in this way
see the main name of the vehicle make.
|
|
|
I
Pick the criteria operator "like"
("Like" is an operator that searches as the word
implies, that is, 'I remember it is something
LIKE this or that. In fact I can type the value
incomplete, such as instead of GTR, type GT and
it should bring all the GT and GTR references
up. So one could narrow searches for Images like
'Elephant at waterhole with Pidgeon' from all
those called 'Elephant at waterhole with
anything else' by using "Pi", "Pid", "Pidg",
"Pidge", "Pidgeo" and "Pidgeon" as the word one
remembers. Also, these words or characters can
be anywhere in the word (or text string), that
is, in the first, middle or last part of the
text string. So, searching for "BAR" OR "bar"
(note case difference) would pick up 'John bar',
'wooden bar model 77' and 'barcelona'). Okay,
back to this tutorial.
|
|
|
type the value to search for, GTR (all I
remember)
|
|
|
and only the TWO Models of Nissan vehicle with
GTR in the name appear. the
third
Nissan that does not contain the GTR word is not
brought up in the search.
|
|
|
Lower case or Upper case can be used in the
searches with the same results of course. In the
case scenario depicted in the left graphic, I
changed the criteria operator from "Like" to "="
(remember that equals is SPECIFIC, that is, it
searches for the EXACT value entered), and typed
'gtr' in lowercase. Clicked the Find button
|
|
|
and it popped a message that tells me there were
no values in the criteria 'Name' to be found
that EQUAL the value 'gtr'. This is how specific
the EQUALS symbol is.
To
help you, messages like this pop up constantly
whenever you used the wrong operator. To get a
proper result, In the left handside case
scenario, I would have to type in a value that
is EXACTLY what the name of the item I am
searching for is in the catalogue (Nissan
Skyline GTR), and it would ONLY bring that Image
not the two containing GTR.
|
|
|
By
simply changing the operator to "Like" and
keeping the lowercase value, I get the same
result as the Uppercase search.
|
bravenet.com
