home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Products
TV-Server
TV Server Plugin: TvWishList
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="foxbenw" data-source="post: 949746" data-attributes="member: 115475"><p>Hi</p><p>I can try to help here too, but Huha will be able to give the definitive answer when he is back.</p><p>According to the pdf manual it is possible to use both 'genre' and 'originalAirDate' in an SQL query. In the plugin you need to select 'match type' as 'expression', then type in the sql you want to run.</p><p>something like this i guess:</p><p>(genre = 'movie') AND (originalAirDate > '31/12/1970')</p><p>... but i do not know if the date format is correct</p><p>It will be considerably easier to do this in the TV Server plugin rather than the MP front end plugin.</p><p> </p><p>The two fields 'genre' and 'originalAirDate' are from the table called programs in the TV Server database.</p><p>It will be important that this works and the data is populated correctly.</p><p> </p><p>Therefore a more important question is - have you tried to import the xmltv data into tv server yet? Even if TVWishList can do it, it will not work if the xmltv tags are not imported correctly into tv server.</p><p>Ben</p></blockquote><p></p>
[QUOTE="foxbenw, post: 949746, member: 115475"] Hi I can try to help here too, but Huha will be able to give the definitive answer when he is back. According to the pdf manual it is possible to use both 'genre' and 'originalAirDate' in an SQL query. In the plugin you need to select 'match type' as 'expression', then type in the sql you want to run. something like this i guess: (genre = 'movie') AND (originalAirDate > '31/12/1970') ... but i do not know if the date format is correct It will be considerably easier to do this in the TV Server plugin rather than the MP front end plugin. The two fields 'genre' and 'originalAirDate' are from the table called programs in the TV Server database. It will be important that this works and the data is populated correctly. Therefore a more important question is - have you tried to import the xmltv data into tv server yet? Even if TVWishList can do it, it will not work if the xmltv tags are not imported correctly into tv server. Ben [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Products
TV-Server
TV Server Plugin: TvWishList
Contact us
RSS
Top
Bottom