Re: need help with sql filter


Jamie WW3S
 

thanks Dave, that’s exactly what I needed....

-----Original Message-----
From: Dave AA6YQ
Sent: Sunday, October 21, 2012 3:11 PM
To: dxlab@...
Subject: RE: [dxlab] need help with sql filter

AA6YQ comments below
-----Original Message-----
From: dxlab@... [mailto:dxlab@...]On Behalf Of
Jamie WW3S
Sent: Sunday, October 21, 2012 2:53 PM
To: dxlab@...
Subject: [dxlab] need help with sql filter


I screwed something up, I knew I should have backed up the log before I started....I think I can recover what I’m after. I need a SQL filter to show the QSL date received is populated with anything, and qsl sent is blank.....is that possible?

If you mean filter the log page display to show all QSOs whose "Date Rcvd" item is non-empty and use "Date Sent" item is empty, then use
(qslrdate<>#4000-01-01#) and (qslsdate=#4000-01-01#)


In DXKeeper, 4000-01-01 is used to represent an unspecified date. Any of a QSO's date items that contain 4000-01-01 are displayed as being empty.
73,

Dave, AA6YQ



------------------------------------

Yahoo! Groups Links





-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.2740 / Virus Database: 2601/5829 - Release Date: 10/13/12
Internal Virus Database is out of date.

Join DXLab@groups.io to automatically receive all group messages.