First, let's search for a keyword.
1. In the "description" box type in gift
2. Click "Make Search String" ,
3. Click "Run Search"
See how easy that was!
Try another one.
Scroll down to the search box at the bottom of the page.
Let's search for a credit card holder.
1. Click on "Select Spender".
2. Use the alphabet keys to jump to last names starting with that letter, click on the spender you want.
3. Notice the search engine automatically puts the person's name in the search box.
4. Click "Make Search String.
5. Click Clear next to description text box to clear out your old keyword
6. Click "Run Search"
7. Your search results should come up.
Let's say you want to search for two people or two vendors.
1. Click "Select Spender"
2. Select the first person by clicking on their name.
3. The first person you chose is now automatically in the "name" box.
5. Click "Select Spender"
6. Select the second person by clicking on the name.
7. The second person is now automatically added in the "name" box.
8. Click "Make Search String"
9. Click "Run Search"
Your results should come up.
Find all records that contain the word "lunch" in the description field from Sept 2007 until Aug 2008.
1. Set
"From: Month/Year:" to Sep 2007.
2.
Type lunch into the
description textbox
3.
Click on Make Search String .
Look at the search string:
select amount as GTOTAL, name, description, merchant, posted from tbl_abc_1234 where description like '%lunch%'
Click RUN SEARCH and see the results.
Now lets look for records that contain the word "lunch" in the description field and also contain the word DOMINO in the merchant field for the same date Range.
1. Type DOMINO into the merchant textbox
2. Click on Make Search String
Look at the Search String:
select amount as GTOTAL, name, description, merchant, posted from tbl_abc_1234 where merchant like '%DOMINO%' and description like '%lunch%'
3. Click on "ors" radio button.
4. Click on Make Search String.
Look at the query: See the difference?
select amount as GTOTAL, name, description, merchant, posted from tbl_abc_1234 where merchant like '%DOMINO%' or description like '%lunch%'
Click RUN SEARCH and see the results.
Now lets say you want to order the results above so that the results are ordered alphabetically by name.
The Search String looks like this:
select amount as GTOTAL, name, description, merchant, posted from tbl_abc_1234 where merchant like '%DOMINO%' and description like '%lunch%'
Add this to it "order by name asc", so that it looks like this (type it right into the text box where the Search String is)
select amount as GTOTAL, name, description, merchant, posted from tbl_abc_1234 where merchant like '%DOMINO%' and description like '%lunch%' order by name asc
Click RUN SEARCH and see the results.
Now lets say you want to look for descriptions that have either lunch, dinner, or breakfast and merchant that have DOMINO.
Type the following into the description box.
lunch~~~dinner~~~breakfast
Type the following into the merchant box.
DOMINO
Click on Make Seach String (note I depend on the fact that the "ands" and "ors" always defaults back to ands after each search.)
Add the following at the end of the Search String in the text area where the Search String is. Make sure you leave a space in front of the string.
order by name asc
The Search String now looks like this:
select amount as GTOTAL, name, description, merchant, posted from tbl_abc_1234 where merchant like '%DOMINO%' and description REGEXP '.*(lunch|dinner|breakfast).*' order by name asc
This one is a bit uglier with the description REGEXP '.*(lunch|dinner|breakfast).*' clause in it. Yep I admit it that's a tough one to figure out on your own. I'm not even going to try to explain it. If you really want to know you can try this link but I'll warn you unless you know a little about regular expressions your not going to like what you find.