Filter by time in collection

First of all: Happy new year to the community!
I installed the 3.8 version on my Windows PC and…wow! darktable is getting better and better. Thank you!

Today I tried to filter the collection by date and time but couldn’t manage to filter a specific time range.
Lets say I want to find all images from August 2021 taken between 6AM and 11AM.
August 2021 is no problem but how can I add the time?
Thanks

Reading the manual may help : darktable 3.8 user manual - collections , section search pattern, and futhermore, there are tooltips.

1 Like

Not sure if reading the docs/tooltips will really help here.

I’ve tried doing something similar multiple times and am not able to do so in a fast and easy way. The thing you run into is that the date-time format lacks a way to set only the time part (for as far as I’ve been able to figure out). The year is mandatory and everything else isn’t.

I do need to be honest here: @Pepe’s problem can be solved by creating 31 or-ed rules in the following form (using date-time taken)

[2021:08:01 06:00;2021:08:01 11:00] or
[2021:08:02 06:00;2021:08:02 11:00] or
.
.
.
[2021:08:30 06:00;2021:08:30 11:00] or
[2021:08:31 06:00;2021:08:31 11:00]

First three would look like this:
collections.range

This can be stored as a preset, which makes creating a new one somewhat easier though.

This works, but I find it rather cumbersome to be honest.

1 Like

Did you try using wildcard character % for day ?

1 Like

Yes.

The date format doesn’t seem to except this.

1 Like

OK, then you are right, of course. I frequently use wildcards, but obviously have never used it for this special use case.

1 Like

:joy: :joy: Thank you. This is a nice but bulky way.

I’ll play with this and see if this is not too distracting in my workflow.

Maybe one of the devs can point towards a more elegant way, if it exists.

1 Like

It looks like this module only allows quite simple filters (mostly string-based). The ability to do more complex queries by writing actual SQL might be useful here (maybe even the ability to view/edit the SQL generated by the module). There’s some work in progress to refactor the collections module here. Might be worth making some suggestions/requests.

2 Likes