Search by date attributes not working with PPA builds

[ghost]

Hello,

It seems that nixnote2 builds from launchpad PPA have an issue with date attributes search: => No filter effect when clicking on any search date filter.

Date attributes search works well with Appimage, but not at all with nixnote2_202001302002~2.1.5 and nixnote2_202001302002~2.1.6.

Test made in ubuntu focal environment, with latest libs available, and same nixnote.db database.

Test environment:

nixnote2_202001302002~2.1.5~ubuntu20.04.1
nixnote2 202001302002~2.1.6-rc2~ubuntu20.04.1

nixnote2-tidy 1:5.6.0-1~202001281531~ubuntu20.04.1
libpoppler-qt5-1  0.80.0-0ubuntu5
libqt5core5a  5.12.5+dfsg-8build1
libqt5network5  5.12.5+dfsg-8build1
libqt5printsupport5  5.12.5+dfsg-8build1
libqt5qml5  5.12.5-5
libqt5sql5  5.12.5+dfsg-8build1
libqt5sql5-sqlite  5.12.5+dfsg-8build1
libqt5webkit5  5.212.0~alpha3-7
libqt5widgets5  5.12.5+dfsg-8build1
libqt5xml5  5.12.5+dfsg-8build1

---

EDIT: Don't know if it can explain the difference between Appimage and PPA builds, but after extraction of the AppImage, these are some extra libs found in /usr/lib/ of AppImage which are not installed as dependencies of PPA packages:

libboost_filesystem.so.1.58.0 libboost_system.so.1.58.0 libicudata.so.55 libicui18n.so.55 libicuuc.so.55 libmirclient.so.9 libmircommon.so.7 libmircore.so.1 libcapnp-0.5.3.so libcrypto.so.1.0.0 libdouble-conversion.so.1 libhunspell-1.3.so.0 libkj-0.5.3.so libmirprotobuf.so.3 libpcre16.so.3 libpng12.so.0 libpoppler.so.58 libprotobuf-lite.so.9 libssl.so.1.0.0

[robert7]

Can you post some more info? I never used date search... so I'm not sure, what you mean :) (I found out now, that there is something like, but tried with AppImage and it also doesn't work) Which version works? Can you post some screenshoot? I will try to look at it

[ghost]

Search by date attribute is this:

Works fine with github.com/robert7/nixnote2/releases/download/continuous/NixNote2-x86_64.AppImage. Does not work at all with following PPA builds:

nixnote2_202001302002~2.1.5~ubuntu20.04.1_amd64.deb
nixnote2_202001302002~2.1.6~ubuntu20.04.1_amd64.deb
nixnote2_202003110017~2.1.5~ubuntu20.04.1_amd64.deb

[robert7]

I will try to look at it later. Thanks for info so far

[boo-yee]

It is because the sqlite datetime function was not executed correctly. It seems that different versions of sqlite have different treatments on it.