Query DB for most recent vids added?

Posted:
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?

Posted:
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?

Posted:
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