ArticleID: 10113 Title: How To Create / Edit / Use SmartLists SmartLists are special active lists that query the sql database that iFlix uses to store your flix, lists, and other information. Until we have time to put together a nice GUI for managing your smartlists, here are a few SQL basics that will help you. Fields (Columns) Your flix list consists of fields, which are shown below (note these are the actual field names, which you currently see if you use Get Info on a flick / item). Here are a few important ones: id - this is an integer record id which iflix needs internally name - this is a string (text) field that contains the user-editable column name genre - this is a string (text) field that contains the user-editable column genre artist - this is a string (text) field that contains the user-editable column artist location - this is a string (text) field that contains the user-editable column location notes - this is a string (text) field that contains the user-editable column notes my_rating - this is an integer field that contains the user-editable column My Rating reallocation - this is a string (text) field that contains the Real Location of an item. For [internet] flix, this contains a torrent url, or downloaded torrent file specification. For all other items that have a file or folder associated with them (added via drag and drop), this contains the path to the item. You can not edit this field directly, but you can use the synchronize filename to displayed name command to synchronize online filenames with your displayed names. web_id - this is a string (text) field that contains the optional internet movie database id for a flick / item. size - this is an integer that contains the size, in KB of a flick. You can not edit this field. date_added - this is an integer that contains the date, in milliseconds that either you added a flick, or the date it was posted ([internet] flix only) SQL Examples - My Top Rated - is where the field my_rating is greater than 3. The SQL syntax for this is: my_rating > 3 - My Highest Rated - is where the field my_rating is greater than 4. The SQL syntax for this is: my_rating > 4 - Smallville and hdtv in the name name like %smallville% and name like %hdtv% - Star Trek in the name or genre name like %star trek% or genre like %star trek% - Smallville in the torrent name / filename OR Enterprise AND hdtv ( reallocation like %smallville% ) OR ( reallocation like %enterprise% and reallocation like %hdtv% ) Experiment The easiest way to build complex smartlists is to experiment. Use a text editor to create a file like my_iflix_smartlists.txt. Copy and paste any of the above examples into your text file. Edit your smartlist query in your text editor, then copy/paste it into a test smartlist to see if it works and/or displays what you want. Important It's important that your SQL has proper spacing and matching parentheses: Correct ( reallocation like %smallville% ) OR ( reallocation like %enterprise% and reallocation like %hdtv% ) Incorrect - needs spaces after/before parentheses (reallocation like %smallville% ) OR (reallocation like %enterprise% and reallocation like %hdtv%) Return to the Knowledge Base Index Close this window