Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
WAE yearly stats
12-01-2018, 07:33 AM,
#1
WAE yearly stats
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    
Reply
12-01-2018, 08:15 PM,
#2
RE: WAE yearly stats
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
Jordi, EA3GCV
Current developer of Swisslog
Reply
13-01-2018, 01:52 AM,
#3
RE: WAE yearly stats
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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)