Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[mattkhan]

I was attempting what I thought was a simple query earlier but couldn't get it work. I just wanted to list all films that were less than 2hrs long, once I found out that less than or equal to was =< not <= then I tried

[Duration]=<2h
[Duration]=<02:00:00
[Duration]=<120m
[Duration]=<0.08d

In the end, the only thing that worked was

[Duration]=<7200

i.e. the unit is implicitly seconds and there seems to be no human friendly formatting of that value as is available to a Date field

Is this correct? Am I missing something really obvious here?

[marko]

I think you are correct. To search on duration, you need to use seconds.

Your search, [Duration]=<7200 will return anything less than two hours. To get "less than or equal to" use [Duration]=<=7200

[mattkhan]

That seems a particularly non programmer unfriendly approach, adding date style interpretation to this would be a sensible enhancement imv

[marko]

agreed.

[Matt]

I think using a d for days, h for hours, w for weeks, y for years, m for minutes and s for seconds should already work.

[marko]

Sorry Matt, but they don't. [duration]=<=2h returns "No search results" [duration]=<=7200 in the same list, returns 487 files.

[Matt]

Sorry Matt, but they don't. [duration]=<=2h returns "No search results" [duration]=<=7200 in the same list, returns 487 files.

Please test again once a new build is out.

We were flipping the less than to a greater than (and back and forth).

Your search "[duration]=<=2h" works perfectly for me with the latest code.

(Actually build 102 is out in beta now... so test away)

[marko]

Confirmed. Working well now, in hours or minutes. Thank you.