Search LOTW sent but not received

[F6FLU]

Hello,
I'm trying to displays the QSOs for which I have sent the LOTW QSL but I have not received LOTW Confirmtion.
I Probably have to make a mistake but I don't see wich one
I have my Log like this :

Log4OM QSOs 2020-11-07 102509.png (71.98 KiB) Viewed 3114 times

And I made these SQL Request :

Log4OM Search LOTW non reçus 2020-11-07 102725.png (13.98 KiB) Viewed 3114 times

and the result is :

Log4OM LOTW recherche résultats 2020-11-07 102827.png (16.37 KiB) Viewed 3114 times

Can you help me ?
Thanks and 73

[G4POP]

Firstly you need to set a date range for the sent confirmations also, probably the same period

Additionally are there any other filters set as that would conflict?

[F6FLU]

Hello many thanks for your help but
If I set the same date it's the same problem
NO I have no another filters

Capture d’écran 2020-11-07 140031.png (11.67 KiB) Viewed 3104 times

Capture d’écran 2020-11-07 140057.png (10.9 KiB) Viewed 3104 times

Capture d’écran 2020-11-07 140203.png (14.21 KiB) Viewed 3104 times

[F6FLU]

Capture d’écran 2020-11-07 135950.png (23.16 KiB) Viewed 3104 times

[F6FLU]

@Terry
If you want, you can connect to my PC with TeamVierwer or AnyDesk ...
73
Dan

[G4POP]

Email me an ADIF file of you log and refer to this thread please

[F6FLU]

Done Terry
I sent my adif
73

[G4POP]

Try using the QSL Manager and use the range dates at the top, I was able to filter for date range fine, see results below 643 QSO's where you sent a confirmation but have not received one apparently? Have you done an LOTW download in the QSL manager yet?

Untitled.jpg (230.18 KiB) Viewed 3086 times

[F6FLU]

Hello Terry
Thanks
No I didn’t use the QSL manager
I only look for the filter system with SQL request
I am just looking for the qso for which I sent the qsl lotw and which I did not receive
Thanks again

[F6EXV]

Hello Daniel
Using the QSL manager as indicated by POP works great.
I have done the same research here, and get the correct result.
73
Paul F6EXV