Re: Create SQL Filter From Current Button Selections
toggle quoted messageShow quoted text
I see you worked out a query to possibly get what you want. In your previous email you mentioned that these spots were all being submitted via your instance of WSJT-X.
You can look at your SpotCollector fields and look for the Network field to see where the spot is coming from and set your SQL to filter on the network.
Band='6M' AND Mode='MSK144' AND Network='WSJT'
Substitute WSJT with whatever the actual value.
Excellent instructions. While not automatically generated, the examples are great and worked perfectly.
For what I was trying to do: Show me only spots from NA-E/M/S, on MSK144
BAnd='6M' AND Mode='MSK144' AND ((NAE='Y') or (NAM='Y') or (NAW='Y'))
That worked. Now I should look how I could refine it to include Mexico and (if not considered part of NA, Canada) and I could put in a Band filter of 6 meters, because I don't have a setup for 2m MSK144.
Thanks for the pointer.
On Tue, Mar 24, 2020 at 7:53 AM Hasan Schiers N0AN via Groups.Io <email@example.com
Thanks, Scott! That was just what I was looking for.
on how to combine standard filters with custom SQL.
It might be interesting to have a way to automatically generate a compound SQL Filter from Current Filter Settings.
I am currently using Band and Mode and Origin
To show Spots from North America, 6 meters, MSK144 only. (with the Buttons already provided)
It would be nice to combine any currently existing set of button filters into a single SQL expression and save it for use as a Button.
...just an idea, and not very important, but it struck me as useful.
Join DXLab@groups.io to automatically receive all group messages.