No negation in filters

3 posts / 0 new
Last post
KE8IZV
No negation in filters

Beating my head on the wall trying to figure out how to filter for a field that does NOT contain whatever. Example: create a filter for all records with Location <> EN73. This can easily be done from the SQL console but as others have mentioned there is no option to export ADIF from the SQL console and I need ADIF
. Nor is there a way (that I can find) to create a filter from an SQL statement. It seems very odd to me that one cannot filter based on a negation?

oh1kh
No negation in filters

Hi!

Good comment.
I will check the code (actually peeked already a little). It should not be too hard to add checkbox "NOT" that reverses the query.
But it needs some testing.

I also think that adding a calendar object to dates could make date entering easier.

--
Saku
OH1KH

oh1kh
No negation in filters

Hi!
I made a quick implementation of negation. It is a simple checkbox NOT that reverses the search sentence.
Filter for 'mode FT8' gives all FT8 qsos, but checking NOT selects all other mode qsos but not FT8. And so on...

It is not very well tested as there are so many different cases with filtering.
At same go I changed date setting to be done with calendar objects.

Test binary (2.3.0-111) is in my web http://www.saunalahti.fi/~sakny/bin/cqrlog2/ (and source in https://github.com/OH1KH/cqrlog-devel).

All test comments are appreciated.

--
Saku
OH1KH