10. Doing a search

10.1 Some WILDCARDS

I first want to give you an idea of the wildcards you can use. There are a lot more wildcards, but the following ones are the most important.

% : general wildcard ; very often this is "*".

"____" : lenght. Here 4 underscores, between "" : 4 characters long.

>= : Bigger then or equal to ; <= : smaller then or equal to.

= : equal to

!= or <> : not equal to.

The use of like : like 'item' .

10.2 SEARCH

Please note : the "call field" is no longer "CALL", but "CALL_NAME" due to technical reasons. This has to do with the fact that in MySQL 5 CALL is a function.

10.2.1 On which items can you search ?

Press "Perform query" and you'll see the qso's you made on 40m, cw,with CQ-zone 18 for which you did receive a qsl-card.
Maybe it's a good idea to re-read this page after a few days of logging. When there's nothing in your DB, it's difficult to get something back .... . And most of it is obvious.

NOTE: You can open a second browser window (usually CTRL + N), direct the new one also to localhost/LiHaLo and press "SEARCH & STAT". Now let's say 6m is open. Press 1 time on "MORE". Let the first one be "BAND" and fill-in "6m" , the second one "LOC". Fill-in the locator you hear. You will see whether you worked that locator or not. (use JO20% e.g.). If there is some return, you worked it. If not : you didn't. Now press you browser"s back-button. You check a new locator. You can also press 3 times on "MORE" ans select QSLR "Y" to only display the locators that you have confirmed.

10.2.2 Some examples of search

• In the CALL-field you fill in the call. You then get all qso's with that call. Please notice that "CALL_NAME" is the default thing that is selected.
You can use wildcards : % e.g. ON% will give you all qso's with Belgium stations.
ot__ will give call's from Belgium that are 4 digits long , e.g. OT[0-9][A-Z].
• ADLIB : type what you are looking for. See also More about ADLIB
• DATE : type the date, e.g. 2003-11-06 . Or try : 2003-05% --> THis give you all qso's made in May,2003.
• LOC : typing the LOCATOR will give you the qso's with that locator. (yeah right,what else ...) Remember the wildcards. If you type e.g. "jo20__" , you get the qso from jo20, for whom you filled in 6 digits. You can play with this.
• IOTA : Same principe as LOC. try (e.g) na% --> All IOTA's from North America.

10.3 CMD-SEARCH

Clicking CMD-SEARCH will give you this :

This is powerful. It is the MySQL Command Line made graphic ..... .

10.3.1 Select statements

The query starts with : "select * from " ....

This means : Select all fields from ..... You can change this be overwriting the "*":
Select CALL_NAME, BAND, MODE, QSLR from " ....

Please note : CALL_NAME,BAND, MODE MUST be in CAPITALS

Then you choose the TABLE, which will be in most cases : QSO .

you have the choise of : sat_name_, sat_mode, qso, party, modes, config, bandlist, adifdxcc, PROPA and PFXTOADIF.

• "SAT_NAME" holds all the defined satellites.
• "SAT_MODE" holds all the defined satellite-modes.
• "QSO" holds all info of a qso : call, band, mode, name, date ... .
• "PARTY" holds the info of a group-qso.
• "MODES" holds all the defined modes.
• "CONFIG" is the place to hold your preferences, your call etc.
• "BANDLIST" is the place were all bands are defined.
• "ADIFDXCC" holds the adifnumber, deleted, Continent, cq-zone, itu-zone, locator.
• "PROPA" holds the propagation modes : NORM, AURORA, TROPO ,..., the Satellite NAMES.
• "PFXTOADIF" links the prefix to an adifnumber.

10.3.2 Examples of a cmd-search

1. where DATE = "2003-10-13"
This gives you all qso on date 2003-10-13, if that day you logged something .... .

2. But you can do more .... where DATE >="2003-10-21" and DATE <="2003-11-03" This gives you the qso's between 2003-10-21 and 2003-11-03. Sometime 00 is ok in a date : 2003-10-00 . Find thisone out ....
3. where ADLIB like "DOC%" Gives you the qso's where the adlib field starts with "DOC".This if for if you want to keep track of the DL-DOC's. You can chooce to fill-in whatever you want. If you want to keep track off OBLAST : >>> add OBL/ to adlib.
   To mention that a OM is member off BAFARA : ADD BAF/. Whatever you imagine is ok.
4. where IOTTA like "na%" This will give all qso's with iota's in North America.
5. where LOC like "______" { 6 underscores inbetween "" } This is to find those qso's for whom you have all 6 digits in the locatorfield.
6. where BAND = "10m" and ADIF = "291" and MODE ="cw" and DATE >"2001-09-23"
   gives you all cw qso's on 10m with usa , after 2001-09-23

But you can even do more with this.

7. SELECT distinct(ADXCC) FROM QSO where BAND like '40m' and MODE like 'ssb' order by ADXCC .
   This gives you all dxcc's on 40m, ssb, ordered by ADXCC. But for this the "DXCC Stats" are better.
8. SELECT * FROM ADIFDXCC . That's all. You 'll get something like this (you'll get more then you see here):
   

   
   
   This is a list of all links between a dxcc and its adifnumber. So if you know the adxcc, you can find the adifnumber. And then you can find all the prefixes for that dxcc.

9. An example:
   SELECT * FROM ADIFDXCC where ADXCC like 'jap%' . This gives you :
   

   
   
   
   Now you know that the ADIFNR. for Japan = 339.
   So now you do : SELECT * FROM PFXTOADIF where ADIF = 339 and you get : (this is part of what you really see)
   
   

   
   

10. SELECT CALL_NAME,BAND, MODE, DATE, TIME, QSLR FROM QSO where CQ = 32 .
    This can give you :
    

    
    
    

10.4 DXCC Stats

The main thing this page is for, is to count ; to count how many "items" you have. To count how many different "items" you have in your logbook. Let's take a look at the start page (the default settings) :

At the outmost left you see "ITEM". This is the "thing" on which you're going to count.
ADXCC = DXCC // That "A" comes from ADIF
The other things, more to the right , are there to "narrow your question". Those are the "selection-criteria".
You see checkboxes (the squares, all of them are selected) , and you see the Radioboxes (the circles), only "ITEM" is selected.

The radioboxes are to select (or deselect) a criterion and the radioboxes are to select "order by" that criterion.
It must be said that if you have all 6 criteria selected, the "order by" will not be so clear ..... .

All checkboxes are standard SELECTED. So if you DO NOT want to limit your question e.g. to "CONTEST_ID", you have to UN-CHECK the CHECKBOX.
This counts for every selection-criterion.

If you un-check every checkbox, you get a list of all the dxcc's you worked, all band, all mode. If you then check QSL back in, you get the total dxcc's, all band & all mode that you have confirmed.

So by clicking on ITEM you have the choise of a few things :
ADXCC : will give you an answer to the question : how many different dxcc's do I have in my logbook ? You will get a list of all the dxcc's you worked and the number (count) of dxcc's..
Selecting LOC, STATE, IOTA, CQ, ITU, CALL_NAME and CONTEST_ID will do the same as described above for the resp. ITEM.

You can refine your search by selecting a specific BAND or a specific MODE etc. So you can , for example, count how many different CQ-zones you worked on 15 meter SSB.

Maybe at this point it's to soon to understand this. Maybe it's a better idea to start doing some logging and to re-try this after a few days, when there are some qso's logged in the DB. You don't get anything back if your DB is empty.

10.5 BAND Stats

So the BAND Stats are complementary to the other search-methods. So in some cases you must use the other search-methods. But BANDS STATS will give you a lot of information on your dxcc-, cqz-, ituz-status.
Maybe you know the spreadsheets some people have to keep track of their dxcc-status. It is with that in my mind that I started working on the BAND Stats ; to provide an easy overview of what you worked and have confirmd. But, as usually was the fact in LiHaLo, this grew out to a little bit more, and different, then meant at the start.

It doesn't do the same as those spreadsheets. It is different. But I found it very handy. Maybe I'll make a spreadsheet later.
I think the use of BAND Stats is easy.

Let's take a look on how it looks like : The whole thing can be devided in 7 parts, separated by a horizontal line.
As stated several times before : there must be something in your DB to get something back.

I think it's all very obvious. Just try it out !

10.5.1 BASICS

It is always best to narrow down your question, especially when you have a lot in your DB ~ many qso's.
"%" stands for : search on everything. "__" means : the lenght of that field is 2 , independent of its contents. So in this case : all contonents.

10.5.2 CQZ, ITUZ, LOC, STATE

This may also be the place for the V/U/SHF people.
When you select e.g. 6m (or 2m,70cm ...) and you do a search for the locator, you'll see the locators limited to the first 4 digits.
You'll see all modes, for each locator, and whether you have confirmd them, or not.

10.5.3 GENERAL ADXCC

With ADXCC you can choose a DXCC for one band.

10.5.4 GENERAL COUNT

10.6 QSO_ID