Database Query Help

[HB9BRJ]

It looks as if custom search can handle quite complex SQL expressions. Here is an all-band version of my previous 160m solution:

Code: Select all

(Band = '160m' And Country Not In (Select Distinct Country From Log Where (LotwQslRcvd = 'V' Or QslRcvd = 'Y') And Band = '160m')) Or (Band = '80m' And Country Not In (Select Distinct Country From Log Where (LotwQslRcvd = 'V' Or QslRcvd = 'Y') And Band = '80m')) Or (Band = '40m' And Country Not In (Select Distinct Country From Log Where (LotwQslRcvd = 'V' Or QslRcvd = 'Y') And Band = '40m')) Or (Band = '30m' And Country Not In (Select Distinct Country From Log Where (LotwQslRcvd = 'V' Or QslRcvd = 'Y') And Band = '30m')) Or (Band = '20m' And Country Not In (Select Distinct Country From Log Where (LotwQslRcvd = 'V' Or QslRcvd = 'Y') And Band = '20m')) Or (Band = '17m' And Country Not In (Select Distinct Country From Log Where (LotwQslRcvd = 'V' Or QslRcvd = 'Y') And Band = '17m')) Or (Band = '15m' And Country Not In (Select Distinct Country From Log Where (LotwQslRcvd = 'V' Or QslRcvd = 'Y') And Band = '15m')) Or (Band = '12m' And Country Not In (Select Distinct Country From Log Where (LotwQslRcvd = 'V' Or QslRcvd = 'Y') And Band = '12m')) Or (Band = '10m' And Country Not In (Select Distinct Country From Log Where (LotwQslRcvd = 'V' Or QslRcvd = 'Y') And Band = '10m'))

73, Markus HB9BRJ

[G4POP]

One of its biggest strengths Marcus

[w0ls]

Once again...THANKS Markus. I plugged that script into custom search and saved it and of course it works great. Log4OM is certainly flexible and powerful.

73's
Harry
W0LS

[IW3HMH]

Well, this feature was created to provide more "advanced features" to skilled users.
And reporting those informations is something that made me happy. This is, as Terry said, a perfect p2p support.

I love building Log4OM with powerful features, hard to use sometime, but extremely powerful if well used. It's a great satisfaction when someone plays with queries or regular expression engine

In V2 there will be possibility to type a query directly into log4om and show result in the usual Log4OM grid. Hopefully there will be no needs to have a sqlite/mysql software, except in case you need something more than query your database.