Hi
I created a filter to use "Recent QSO´s" F7 to see the contacts made in the present day.
For ease, I used a "Custom Query" with the following expression:
qsodate> current_date
It works perfectly.
Following the same idea, but now to show the contacts made in the present month, I used the expression:
MONTH (qsodate) = MONTH (current_date)
Unfortunately it doesn't work.
Can you help me?
Filter - Recent QSO F7
Filter - Recent QSO F7
73 Manuel Fernando CT1BXX
- G4POP
- Log4OM Alpha Team
- Posts: 10803
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: Filter - Recent QSO F7
No it should be two filters, start date and end date, if in the recent QSO window or use the date range facility in the QSO manager
Normal filtering would have to be QSO date greater than or equal to (start date) and less than or equal to (end date)
Or in QSO manager
Normal filtering would have to be QSO date greater than or equal to (start date) and less than or equal to (end date)
Or in QSO manager
73 Terry G4POP
Re: Filter - Recent QSO F7
Hi Terry,
Thank you very much for the suggestion.
I know I could filter that way, but that forces me to choose dates monthly.
Using an SQL expression, a "costum query", we get the same result without the need to enter dates, so that we don't have to include dates whenever I want to have this listing.
A SQL expression, is more "universal", during the times... so better to use for monthly listing, or year.
It is true that I could create and save 12 filters for a year, but with the change of year there would return to the same situation, the need to change the year, so an SQL expression solves the situation forever, on the other hand, as the program offers us the possibility of using "Use custom query" is a tool that knowing some sql expressions, we can create listings according to the particular needs of each user.
That´s the reason why I rather prefer using the tool "custom query".
Thank you very much for the suggestion.
I know I could filter that way, but that forces me to choose dates monthly.
Using an SQL expression, a "costum query", we get the same result without the need to enter dates, so that we don't have to include dates whenever I want to have this listing.
A SQL expression, is more "universal", during the times... so better to use for monthly listing, or year.
It is true that I could create and save 12 filters for a year, but with the change of year there would return to the same situation, the need to change the year, so an SQL expression solves the situation forever, on the other hand, as the program offers us the possibility of using "Use custom query" is a tool that knowing some sql expressions, we can create listings according to the particular needs of each user.
That´s the reason why I rather prefer using the tool "custom query".
73 Manuel Fernando CT1BXX
[Resolved] Filter - Recent QSO F7
Hi
If any of you are interested, I come to share with the solution to create a monthly listing on "Recent QSO or QSO Manager"
My mistake was to use a query for SQL, when it should be for SQLite, since my database is SQLite.
So following the same idea, I just adapted the code for SQLite and bingo!
it works perfectly.
I think that this tool if explored, can be very versatile, in addition to being able to create standard query without having to always fill it in with values that can be assumed to be standardized, which is the case of date ranges.
If you find an error or have a better code, it would be useful if you shared.
Here is the query code, if they use SQLIte.
strftime('%Y', qsodate) = strftime('%Y', current_date) AND strftime('%m', qsodate) = strftime('%m', current_date)
If any of you are interested, I come to share with the solution to create a monthly listing on "Recent QSO or QSO Manager"
My mistake was to use a query for SQL, when it should be for SQLite, since my database is SQLite.
So following the same idea, I just adapted the code for SQLite and bingo!
it works perfectly.
I think that this tool if explored, can be very versatile, in addition to being able to create standard query without having to always fill it in with values that can be assumed to be standardized, which is the case of date ranges.
If you find an error or have a better code, it would be useful if you shared.
Here is the query code, if they use SQLIte.
strftime('%Y', qsodate) = strftime('%Y', current_date) AND strftime('%m', qsodate) = strftime('%m', current_date)
73 Manuel Fernando CT1BXX