Swisslog's Forum
Query Editor add country? - Printable Version

+- Swisslog's Forum (https://www.swisslogforwindows.com/forum)
+-- Forum: Swisslog version 5.x (https://www.swisslogforwindows.com/forum/forumdisplay.php?fid=3)
+--- Forum: General discussion (https://www.swisslogforwindows.com/forum/forumdisplay.php?fid=4)
+--- Thread: Query Editor add country? (/showthread.php?tid=863)



Query Editor add country? - KE4BCN - 24-02-2021

Using the query editor is it possible to add a column for country? I did not see anything listed. Thank you..


RE: Query Editor add country? - EA3GCV - 24-02-2021

Hello,

Yes you can do it but it's a bit more complicated. You need to add the INF_DXCC table then link the DXCC field from the QSO table with the DXCC field of the INF_DXCC table. Join type must be "Return all records from QSO and only matching recrods from INF_DXCC". Afterwards add the DXCC_NAME field into the query. You will see it clear if you open the "All stations with DXCC Name" query located in the DXCC folder.

Best 73