Media List Editor Examples
#46
List to show only watched movies with a user rating under 7:

SELECT DISTINCT *
FROM
  movielist
WHERE
  movielist.iLastPlayed IS NOT NULL AND
  movielist.iUserRating < 7
Reply
#47
Hi,

can someone please help with following filter:

All movies with "HDDVD" in filename, Thanks.

Tried some SQL without success Sad
Reply
#48
Found the variabel StrFilename in the help section, but can't figure out the correct sql.....
Reply
#49
(2018-01-11, 21:55)Anderella Wrote: Hi,

can someone please help with following filter:

All movies with "HDDVD" in filename, Thanks.

Tried some SQL without success Sad
SELECT DISTINCT *
FROM
  movielist
WHERE
  movielist.MoviePath LIKE '%hddvd%'
Reply
#50
Thx.
Reply
 
Thread Rating:
  • 1 Vote(s) - 5 Average



Logout Mark Read Team Forum Stats Members Help
Media List Editor Examples51