Print

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

[stricko]

Me again, and still in theater view...

I'm trying to build a query showing the last 20 videos, in date sequence, most recent first.

I've set up the query, with modify results of Sort by Date imported (Z-a) and Limit (advanced) 20,-1,[album]

My (test) library is in a strange state at the moment, with lots and lots of movies (mainly dvd rips) imported on the same day aboiut two weeks ago, and a trickle of stuff (<20, and on different days) since then. My expected results are the small number of recently imported titles, plus some of the movies imported en mass.

What I'm getting is slightly different. I'm only getting a subset of the most recently added movies, with even the most recent ones missing, and the remaining items made up from the bulk load. I've checked the tags and they look OK.

But if i also apply a rule to limit the query to items with a date imported within the last 10 days (i.e. after the bulk load), then the situation improves. I get all of the recently imported stuff, including the movies missing from the earlier version. but I have less than 20 items......

So I'm mystified as to what is happening. I thought it might be the sequnce in which the rules and modifiys are applied but I can't see the logic. It appears that the rule (i.e. within the last 10 days) is applied first, so when this gives less than 20 results, the query works OK. But without this rule, or with a version of the rule that gives more than 20 results, things get a little strange. It looks like the Limit is applied BEFORE the sort. So however the query is reading results form the library, it's stopping after it has found 20 movies, and then sorting them. I've tried changing the sequence of the modify rules as they appear on the screen, to have the limit after the sort, but the results are the same. And why am I getting some of the recently added stuff, and not just a random selection form the bulk of the movies. The filenames don't give any clues either.      

I'm getting the same issue on two different boxes (both running version 50)

Can anyone give me a clue about what is happening?
  

[gappie]

not sure? but why do you use [album] and not, for instance [name]. could it be that one album has more movies? would using [name] help?

 
gab

[stricko]

I use a new field that I've called Title which gives me a way of handling multi-disk sets (i've got another thread out there about this) but in reality it makes no difference. I first noticed the problem when using the Title field, but to eliminate this from my enquiries, I switched the query to use Name, and it gives the same result. I'm still puzzled.