Search not working

10 posts / 0 new
Last post
n3gb
Search not working

Just built the latest git loc_master, and found that search doesn't work.

A section of the debug output:
Polling - allowcommand:-1
Polling - allowcommand:-1
Polling - allowcommand:-1
Polling - allowcommand:-1
Polling - allowcommand:-1
SELECT * FROM view_cqrlog_main_by_qsodate WHERE (callsign LIKE '%J35X%') AND (qsodate >= '9999-12-31') AND (qsodate <= '9999-12-31')
SELECT * FROM view_cqrlog_main_by_qsodate WHERE (callsign LIKE '%J35X%') AND (qsodate >= '9999-12-31') AND (qsodate <= '9999-12-31')

SELECT * FROM view_cqrlog_main_by_qsodate WHERE (callsign LIKE '%J35X%') AND (qsodate >= '9999-12-31') AND (qsodate <= '9999-12-31')

Looks like an impossible date to me; searching by date does work.

oh1kh
Search not working

Hi!
I am using (124) here and qso list/file/search works so far.
I wonder the year 9999 in debug. With that year you sure do not find any qsos! Or have you travelled with Marty and Doc in Back to Future trilogy?

Have you set date limits for search?

--
Saku
OH1KH

n3gb
Search needs date

Search works if I set the start date; i.e. 2021-01-01. Haven't tried setting it to 2015-10-21 :-).

oh1kh
Search needs date

Hi!
Please give some more information.
Are we talking about "Search": Qso list/File/Search ?
Or "Filter" : Qso list/Filter/Create ?

With "Search" you can not set dates, but can set "Sort by date".

With "Filter" you can define start and end date. 

You can leave both dates empty: Filter looks whole log,
enter just "From" date: Filter looks qsos from date to today
or enter both dates: Filter looks qsos between dates. 

Putting just "To" date does not work: Filter looks whole log...

I have tested all those and do not see any situation where I would get year 9999 without entering it to date columns. I am currently using Alpha 2.6.0(125)_QT5 2024-03-14

 

 

--
Saku
OH1KH

n3gb
Sorry, I should have said "filter"

Yes, I meant the filter (F12). If I set a start date there I get correct results.

I'm thinking that this may be another problem with newer Lazarus/libraries, or just unique to my system.

OS: openSUSE Tumbleweed
Lazarus: 3.2
glibc: 2.39
mariadb: 11.2.3

oh1kh
Search needs date

OK!
That was what I was thinking about.
Lazarus 3.2 does not work same way as earlier versions.

It can not make running QT5 version, even when new libqt5pas is installed.
GTK2 version seems to run but I have not tested it more.
Now when you said you have laz 3.2 I made test compile and run and for me it seems that filter/date columns seems to be empty when filter window opens. How ever created filter gets same date limits as you had 9999-12-31

If I clear filter (button) or erase both manually the date 1899-12-30 returns always back.
If I set date it stays as set. When dates are in proper range filter seems to work.

Conclusion: Lazarus 3.2 is not backward compatible and should not be used until fixed.
If "they" do not fix it it means Cqrlog must be rewritten and I think nobody does it if there are many issues.

So until now we know at least QT5 and filter date problem.

--
Saku
OH1KH

oh1kh
Search needs date

Yep!
it is said in Laz3.0 releas notes:
TDateEdit/TTimeEdit
The value of NullDate has changed.
Reason:

It was impossible to actually select the date corresponding to NullDate (30 dec 1899 by default) in the control.
Remedy (1): if your code depended on NullDate actually being 0.0, you have to adjust your code.
Remedy (2): if your code used NullDate for a TTimeEdit, change that to the new constant NullTime instead.
Note: NullDate is actually a writeable constant. This was kept for compatibility reasons. It is however a bad idea to change it's value to anything that is an actual date that is within the range of the control.

--
Saku
OH1KH

n3gb
Thanks for the explanation

That explains a lot. It's what I get for running on a bleeding edge distro :-(. I'm not sure I can find an older Lazarus for this system, so I might have to live with the problems. I just updated to the KDE Megarelease 6, and at least now the GTK2 version uses the KDE theme so it looks much more like the rest of my apps.

BTW, Lazarus 3.2 also allows --ws=gtk4, which doesn't work either.

73
n3gb

oh1kh
Search needs date

HI!
I just uploaded a new alpha source, version (125), date 2024-03-20.
It has fix, I hope so, for this problem. Please try it.

And if/when you find other things that are not working when Laz 3.2 complied please report them.

--
Saku
OH1KH

n3gb
Thanks

That did it. I can just enter call signs to filter again.

Now we just wait for them to fix the widget sets other than gtk2.