Page 1 of 1

Query DB for most recent vids added?

PostPosted: Sun Aug 19, 2012 10:55 pm
by mozztoff
Is there a query that i can run from db.view that would basically give me say a list of the top 50 most recent vids I have added? I'm not looking for audio from the list, but rather just a list of any video format that has been added most recently? I appreciate any help

running 4.6 (build 2583) on win 08 r2

Re: Query DB for most recent vids added?

PostPosted: Mon Aug 20, 2012 5:48 am
by hakko
I'd say no, because 4.6 doesn't store file information in the db, it's kept in a (very inefficient) structure in memory that you can't really query. Should be possible in 4.7 though.

Re: Query DB for most recent vids added?

PostPosted: Mon Aug 20, 2012 3:39 pm
by mozztoff
hakko wrote:I'd say no, because 4.6 doesn't store file information in the db, it's kept in a (very inefficient) structure in memory that you can't really query. Should be possible in 4.7 though.


Thanks.. ill look into more in the next release