how do I figure out what query to use?
I want to query the most recent "videos" imported"
is this using the videometadata table?
I got this but what happens when you rename and re-scan?
database query for videos
Moderator: Forum Moderators
Re: database query for videos
What are you using for database access? I'm using DBeaver now, both directly on my MythTV box and also on my Windows laptop via ssh tunnel. Works great for browsing tables.
Most of my queries are to get info on program schedule and recordings, not videos, but maybe this will get you started:
select title,subtitle,inetref,filename,insertdate from videometadata
where date(insertdate) > date_sub(CURDATE(), interval 30 day)
order by insertdate DESC;
Most of my queries are to get info on program schedule and recordings, not videos, but maybe this will get you started:
select title,subtitle,inetref,filename,insertdate from videometadata
where date(insertdate) > date_sub(CURDATE(), interval 30 day)
order by insertdate DESC;