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="huha" data-source="post: 710592" data-attributes="member: 63847"><p><strong>Prerelease of version 1.2.0.6</strong></p><p></p><p>I am doing a prerelease of 1.2.0.6, which includes now SQL queries and will open a new dimension on flexibility usage and processing speed. You can now specify any queries for title, description, genre, ..... whatever is specified in the program database and supported by your EPG. To find that out just do a simple search with partial title and look at the result in the log file or your email as it will list all program attributes which can be used. Please note that channelname or groupname cannot be used as they do not belong to the program structure in mediaportal. But they are implemented in the advanced filter section of the plugin.</p><p></p><p>You have to set "MatchType" to expression and then enter the SQL expression in "SearchFor"</p><p></p><p><span style="color: Red">Please post if you have new cool ideas how to use the expression feature</span></p><p></p><p>Attached a copy from the manual</p><p></p><p>Match Type</p><p>The match type can be „exact“ , „partial“ or “word” if applied to a program title. If „exact“ is</p><p>selected the program name in the EPG data must be exactly the same as the name specified in the</p><p>„Search for“ textbox. In case of partial selection the EPG data must contain the specified phrase.</p><p>Please note that for both options the Search for text is not case sensitive. This option is used only</p><p>for the program title, but never for the program description, which always implies a „partial“</p><p>setting. For “Word in Title”, “Word in text” or “Word in Title/Text” the plugin assumes that a user</p><p>has specified an exact word as a search criteria. This means the title/text must contain exactly this</p><p>word with a space before and after the matched text. Alternatively the matched text can be at the</p><p>beginning or end of the program title or description. If “expression” is chosen for match type the</p><p>user can specify a SQL query in “Search For”. This enables great flexibility as the following</p><p>examples are showing:</p><p><strong>Example1:</strong></p><p>(title like '%James Bond%' ) AND ( (description like '%007%') OR (description like '%geheimagent</p><p>%' ) )</p><p>This will match James Bond in the program title only if at the same time either 007 or geheimagent</p><p>is found in the text description of the program</p><p><strong>Example 2:</strong></p><p>(title like '%Star Wars%' ) AND ( title not like '%clone wars%' )</p><p>This will search for a partial title Star wars only if the title does not contain clone wars</p><p><strong>Example 3:</strong></p><p>(starrating ='***')</p><p>This will search for all programs rated with *** if your EPG data do include Starrating.</p><p>Besides title and description you can also use the following search criteria:</p><p>classification, starttime, endtime, originalairdate, episodename, episodenum, episodenumber,</p><p>episodepart, genre, parentalrating, seriesnum, starrating</p><p>Please note that sql expressions are not case sensitive.</p><p>The following operators are supported from SQL:</p><p>= Equal</p><p><> Not equal</p><p>> Greater than</p><p>< Less than</p><p>>= Greater than or equal</p><p><= Less than or equal</p><p>BETWEEN Between an inclusive range</p><p>LIKE Search for a pattern</p><p>NOT LIKE Search for an excluding pattern</p><p>IN If you know the exact value you want to return for at</p><p>least one of the columns</p><p>The pattern must be enclosed by ' at the begin and at the end of the pattern expression. The following</p><p>wildcard characters are supported in SQL syntax:</p><p>% A substitute for zero or more characters</p><p>_ A substitute for exactly one character</p><p>[charlist] Any single character in charlist</p><p>[^charlist] or [!charlist] Any single character not in charlist</p><p></p><p>Update for SQL experts:</p><p>I have implemented the SQL query in the form:</p><p>select * from Program where expression_from_search_for_string</p><p></p><p>Update:deleted attached file as you can find it now on the first page</p></blockquote><p></p>
[QUOTE="huha, post: 710592, member: 63847"] [b]Prerelease of version 1.2.0.6[/b] I am doing a prerelease of 1.2.0.6, which includes now SQL queries and will open a new dimension on flexibility usage and processing speed. You can now specify any queries for title, description, genre, ..... whatever is specified in the program database and supported by your EPG. To find that out just do a simple search with partial title and look at the result in the log file or your email as it will list all program attributes which can be used. Please note that channelname or groupname cannot be used as they do not belong to the program structure in mediaportal. But they are implemented in the advanced filter section of the plugin. You have to set "MatchType" to expression and then enter the SQL expression in "SearchFor" [COLOR="Red"]Please post if you have new cool ideas how to use the expression feature[/COLOR] Attached a copy from the manual Match Type The match type can be „exact“ , „partial“ or “word” if applied to a program title. If „exact“ is selected the program name in the EPG data must be exactly the same as the name specified in the „Search for“ textbox. In case of partial selection the EPG data must contain the specified phrase. Please note that for both options the Search for text is not case sensitive. This option is used only for the program title, but never for the program description, which always implies a „partial“ setting. For “Word in Title”, “Word in text” or “Word in Title/Text” the plugin assumes that a user has specified an exact word as a search criteria. This means the title/text must contain exactly this word with a space before and after the matched text. Alternatively the matched text can be at the beginning or end of the program title or description. If “expression” is chosen for match type the user can specify a SQL query in “Search For”. This enables great flexibility as the following examples are showing: [B]Example1:[/B] (title like '%James Bond%' ) AND ( (description like '%007%') OR (description like '%geheimagent %' ) ) This will match James Bond in the program title only if at the same time either 007 or geheimagent is found in the text description of the program [B]Example 2:[/B] (title like '%Star Wars%' ) AND ( title not like '%clone wars%' ) This will search for a partial title Star wars only if the title does not contain clone wars [B]Example 3:[/B] (starrating ='***') This will search for all programs rated with *** if your EPG data do include Starrating. Besides title and description you can also use the following search criteria: classification, starttime, endtime, originalairdate, episodename, episodenum, episodenumber, episodepart, genre, parentalrating, seriesnum, starrating Please note that sql expressions are not case sensitive. The following operators are supported from SQL: = Equal <> Not equal > Greater than < Less than >= Greater than or equal <= Less than or equal BETWEEN Between an inclusive range LIKE Search for a pattern NOT LIKE Search for an excluding pattern IN If you know the exact value you want to return for at least one of the columns The pattern must be enclosed by ' at the begin and at the end of the pattern expression. The following wildcard characters are supported in SQL syntax: % A substitute for zero or more characters _ A substitute for exactly one character [charlist] Any single character in charlist [^charlist] or [!charlist] Any single character not in charlist Update for SQL experts: I have implemented the SQL query in the form: select * from Program where expression_from_search_for_string Update:deleted attached file as you can find it now on the first page [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Products
TV-Server
TV Server Plugin: TvWishList
Contact us
RSS
Top
Bottom
