Custom query problem

[F6FLU]

Hello
I can no longer use filters with personal queries

For example, if I want to select the records whose
QSO date is >= 02/22/205
AND
<= 02/23/2025
AND
whose SRx field is = 10
or
Srx = 19

this does not work

QdoDate >= "22/02/2025"
AND
QsoDate <= "23/02/2025"
AND
( SRx = "10" OR SRx = "19" )

If I select the condition in the field provided in the drop-down menu and I build my query, I cannot add it using the + button at the top right

even if I do a simple query like
QsoDate >= "22/02/2025" AND QsosDate <= "23/02/2025" it doesn't work

I must probably make mistakes in these queries

Before we could create our query in the "use Params" tab and if we then went to "Use custom query" we saw the query created in "use Params" transformed and it was proposed to us in the "Use custom query" tab, we only had to put the parentheses in the right place to make a complete query

If you had any advice ...
Thanks

2025-03-01 10_08_17.jpg (29.43 KiB) Viewed 4063 times

[G4POP]

incomplete without time because the adif format includes date and time in a single field

This works fine

Untitled.png (18.29 KiB) Viewed 4049 times

[F6FLU]

YES but that doesn't works with "use custom query"

this Pb is only with "Custom Query"
if I use "Params" that works fine

2025-03-01 11_22_40.jpg (34.53 KiB) Viewed 4045 times

[G4POP]

well it works for me I just filtered 277 QSO's by date range using same parameters as your image from the 67,050 QSO's in my log

Are you sure that you had QSO's for those specific 2 days?

BTW you dont need the EXTRA 'and' because it defaults to 'And' without that

And you dont need to have the first line either it will sort all unless you add a filter for mode or band etc

Untitled.png (18.72 KiB) Viewed 3997 times

[F6FLU]

well it works for me I just filtered 277 QSO's by date range using same parameters as your image from the 67,050 QSO's in my log

Are you sure that you had QSO's for those specific 2 days?

BTW you dont need the EXTRA 'and' because it defaults to 'And' without that

And you dont need to have the first line either it will sort all unless you add a filter for mode or band etc


Untitled.png

YES.
Because you use the param option and not the custom query…

[G4POP]

But why use a custom query when its not required? the default parameters will do most things

Custom queries use SQL strings not the syntax your using

e.g DXCC=291 and callsign like'%1%'

This returns all US stations worked with a '1' in the call sign

Your mixing parameter strings with SQL Queries

[F6FLU]

Because I want to search that :

For example, if I want to select the records whose
QSO date is >= 22/02/2025 00:01:00
AND
<= 23/02/2025 23:59:59
AND
whose SRx field is = 10
OR
Srx = 19
OR SRX = xx etc ..
==================================
QdoDate >= "22/02/2025"
AND
QsoDate <= "23/02/2025"
AND
( SRx = "10" OR SRx = "19" )
==================================

[CT1BXX]

Because I want to search that :

For example, if I want to select the records whose
QSO date is >= 22/02/2025 00:01:00
AND
<= 23/02/2025 23:59:59
AND
whose SRx field is = 10
OR
Srx = 19
OR SRX = xx etc ..
==================================
QdoDate >= "22/02/2025"
AND
QsoDate <= "23/02/2025"
AND
( SRx = "10" OR SRx = "19" )
==================================

Hi Dan,
Please try this query

query.jpg (50.57 KiB) Viewed 3606 times

[F6FLU]

Hello Manuel
NO that doesn't works ...

[CT1BXX]

Hello Manuel
NO that doesn't works ...

Hello Dan.
I am sorry that do not work.

Here I have tested and worked for me, however I want to tell you I'm not an exepert I'm just a curious person who likes to test, and in this process I've created the queries that I personally use.

Today I have family at home for lunch, but when I finish I will return to the subject and try to analyze within my small experience, however I will leave here the line of the query and suggest that you do "Copy/Paste" and try one more time.

Here is the complete text I am using: do not forget ; at end
Have a nice sunday and again sorry I have tried my best.

qsodate >= '2025-02-22' AND qsodate <= '2025-02-23' and SRx like '10';