Filter on Duration Field

37 views

Skip to first unread message

Max Hanson

unread,

Jan 5, 2026, 5:20:12 PM (13 days ago) Jan 5

to mementodatabase

Hi,

I am trying to set up a dashboard widget that views a count of records in a range of durations. For instance, how many records are there in my list where a duration field is between 30 minutes and 1 hour. As soon as I try to apply a greater than, less than or between filter, Memento DB (desktop version) crashes with java errors about casting data types. I also notice that, when using "between" it gives me hours, minutes and seconds fields for the start of the range and one field with no units for the end. It seems like there is an issue with the Duration data type.

If I use SQL Explorer I can run queries that give me the desired result, but I'd like to have it in a dashboard. In SQL, I use millisecond integer numbers in my WHERE statement on the Duration field.

I'm running Memento Desktop version 3.7.1 on Windows 11.

Thanks for any help you can offer!

Er Mo

unread,

Jan 6, 2026, 4:59:16 AM (13 days ago) Jan 6

to mementodatabase

Hallo

Der Feldtyp " Dauer " macht auch bei meiner PC Version Probleme . Für deinen Fall könntest du das Ungehen in den du 2 Filter Kombinierst . Einen als " Registerkarte " und ein als Filter .

Hello,

The "Duration" field type is also causing problems on my PC version. In your case, you could work around this by combining two filters: one as a "tab" and one as a filter.