Date
1 - 3 of 3
need help with sql filter
|
Jamie WW3S
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?
[Non-text portions of this message have been removed] |
|
|
|
Dave AA6YQ
-----Original Message-----AA6YQ comments below 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? (qslrdate<>#4000-01-01#) and (qslsdate=#4000-01-01#)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 73,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. Dave, AA6YQ |
|
|
|
Jamie WW3S
thanks Dave, that’s exactly what I needed....
toggle quoted message
Show quoted text
-----Original Message-----
From: Dave AA6YQ Sent: Sunday, October 21, 2012 3:11 PM To: dxlab@... Subject: RE: [dxlab] need help with sql filter -----Original Message-----AA6YQ comments below 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? (qslrdate<>#4000-01-01#) and (qslsdate=#4000-01-01#)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 73,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. 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. |
|
|