Swisslog's Forum

Hello

i need a statistic for working wae countries each year.
So this year I need a stat with confirmed lotw,eqsl,paper-qsl for qso made only in 2018.

I made a self defines stat as defined in the WAE-stat.
I added a filter like this:
  SELECT Logbook.L_DATE
    FROM Logbook
   WHERE (((Logbook.L_DATE >= #01/01/2018#)))

If I click on "view" in the stat defining window all seems to be good.

A detailed view in the statistic windows shows only one qso...

What's wrong here?

Torsten, dg7ro[attachment=110]

Hello Torsten,

P_WAE is a field from the PQTH table and you are adding a filter in another table (LOGBOOK). You have to join first PQTH and Logbook tables. Edit the WCA statistic and see the example. In WCA:

SELECT Logbook.L_DATE,
PQTH.P_DXCC
FROM Logbook
INNER JOIN PQTH
ON Logbook.L_CALLID = PQTH.P_CALLID
WHERE (((Logbook.L_DATE >= #01/01/1995#)
AND (PQTH.P_DXCC <> '%')))

In your statistic, select WAE instead of DXCC field and set the same filters so that the final SQL is like this:

SELECT Logbook.L_DATE,
PQTH.P_WAE
FROM Logbook
INNER JOIN PQTH
ON Logbook.L_CALLID = PQTH.P_CALLID
WHERE (((Logbook.L_DATE >= #01/01/2018#)
AND (PQTH.P_WAE <> '%')))

Best 73

hi,

work after a very bad misstake on my side a... arg. how sad....:
I used often the new mode FT8 and this was NOT included in the mixed field in the stastik selection window!

I have to use "All modes".

73 es tnx for helping and pointing into the right direction regarding the sql-statement.

Torsten