MyVideo 1.3.0 Feedback (2 Viewers)

Dadeo

Dadeo

Docs Group Manager
  • Premium Supporter
    • November 26, 2006
    5,340
    3,321
    Himalayas, India
    Home Country
    Canada Canada
    So how do you sort by 'Date Added' in Titles view? AFAIK there is no skin property for date added and it is not displayed in skin when you display/sort by date in Videos Titles view and sort is not totally accurate though it is in Recently Added. (see screenshots). Unwatched and other views are the same as Video Titles.

    Obviously date added is stored in DB and used in Recently Added DB View. Wouldn't it be consistent to always use Date Added for Date in any DB view?
     

    Attachments

    • VideoTitlesSortByDate.jpg
      VideoTitlesSortByDate.jpg
      46.6 KB
    • VideosRecentlyAddedSortByDate.jpg
      VideosRecentlyAddedSortByDate.jpg
      59.7 KB
    Last edited:
    D

    Deda

    Lead Dev MP1 Videos
  • Premium Supporter
    • March 18, 2009
    2,423
    2,385
    Zagreb
    Home Country
    Croatia Croatia
    Date added and date watched are from database. And about sort thing..... This is a story to be told how not to do things like it is now in MP.

    Who ever done WindowsPlugins inside MP, did everything to kill any fun for future coding. Many of internal plugins shares code, variables, methods, functions so what happens? Imagine yourself as pizza delivery boy and you need to deliver pizza to point A. You happily ride your bike and put smile on your face how easy task you have. But suddenly while you travel, boooom, you've been pulled by some dark hidden force to point B with demons inside which poo your pizza and kick you to point X,Y,Z where hungry angels are and they took your pizza, but as it is filled with demons poo they poo it too and throw it in you face and teleports you back to demons which kick your ass because you're annoying. Finally, with ruin pizza you arrive to point A and you're wonder what the hell I'm holding in my hands.

    I must admit that I'm in war with Music plugin because it constantly mess up everything in MyVideos even you did not open any MyMusic screen. Just remember the case when you click on MyVids button and suddenly you end in MyMusic view. I killed myself to find out the problem and do a workaround. Now I just found while trying to find a cure for RicohHTPC problem, that changing views cause hidden code crash in music sort (not visible in logs) because sort for all internal plugins lives on the same foundation with same variables. So when you do something in some plugin, that task is processed by all plugins and if we're lucky, good thing happens. Actually, WinPlugins is one deep shit code pile.

    And sort in MYVideos.... Share view and database views are actually one view with the same sort for all, and if you add one rule sort to shares (which is absolutely not applicable to database views [ie. lets add sort by hidden file attribute]) you see it also there database views. To hide that there is almost but impossible and as share view is based on physical files on your HDD/CD/DVD... and database views are based (obviously) on database with movies info they are totally different things, so sort by date works in share perfectly because code for sort by date was done for files but that code can't work on movie information because there is no files. And this is only 1% of problems with views and sort.

    So now, I'm trying to find a Ricoh problem but can't locate demons which ruins everything and I'm actually drowning in poo.
     
    Last edited:
    D

    Deda

    Lead Dev MP1 Videos
  • Premium Supporter
    • March 18, 2009
    2,423
    2,385
    Zagreb
    Home Country
    Croatia Croatia
    Just for fun, enjoy in this, this is what actually define your movie views (the same thing is for music :) but with different alien language)

    [collapse]
    Code: 
    <SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<a1:ArrayList id="ref-1" xmlns:a1="http://schemas.microsoft.com/clr/ns/System.Collections">
<_items href="#ref-2"/>
<_size>13</_size>
<_version>2236</_version>
</a1:ArrayList>
<SOAP-ENC:Array id="ref-2" SOAP-ENC:arrayType="xsd:anyType[20]">
<item href="#ref-3"/>
<item href="#ref-4"/>
<item href="#ref-5"/>
<item href="#ref-6"/>
<item href="#ref-7"/>
<item href="#ref-8"/>
<item href="#ref-9"/>
<item href="#ref-10"/>
<item href="#ref-11"/>
<item href="#ref-12"/>
<item href="#ref-13"/>
<item href="#ref-14"/>
<item href="#ref-15"/>
</SOAP-ENC:Array>
<a3:ViewDefinition id="ref-3" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<listFilters href="#ref-17"/>
<name id="ref-18">369</name>
</a3:ViewDefinition>
<a3:ViewDefinition id="ref-4" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<listFilters href="#ref-19"/>
<name id="ref-20">1287</name>
</a3:ViewDefinition>
<a3:ViewDefinition id="ref-5" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<listFilters href="#ref-21"/>
<name id="ref-22">344</name>
</a3:ViewDefinition>
<a3:ViewDefinition id="ref-6" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<listFilters href="#ref-23"/>
<name id="ref-24">1288</name>
</a3:ViewDefinition>
<a3:ViewDefinition id="ref-7" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<listFilters href="#ref-25"/>
<name id="ref-26">1269</name>
</a3:ViewDefinition>
<a3:ViewDefinition id="ref-8" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<listFilters href="#ref-27"/>
<name id="ref-28">1289</name>
</a3:ViewDefinition>
<a3:ViewDefinition id="ref-9" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<listFilters href="#ref-29"/>
<name id="ref-30">135</name>
</a3:ViewDefinition>
<a3:ViewDefinition id="ref-10" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<listFilters href="#ref-31"/>
<name id="ref-32">1265</name>
</a3:ViewDefinition>
<a3:ViewDefinition id="ref-11" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<listFilters href="#ref-33"/>
<name id="ref-34">987</name>
</a3:ViewDefinition>
<a3:ViewDefinition id="ref-12" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<listFilters href="#ref-35"/>
<name id="ref-36">4558</name>
</a3:ViewDefinition>
<a3:ViewDefinition id="ref-13" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<listFilters href="#ref-37"/>
<name id="ref-38">4559</name>
</a3:ViewDefinition>
<a3:ViewDefinition id="ref-14" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<listFilters href="#ref-39"/>
<name id="ref-40">1266</name>
</a3:ViewDefinition>
<a3:ViewDefinition id="ref-15" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<listFilters href="#ref-41"/>
<name id="ref-42">1267</name>
</a3:ViewDefinition>
<a1:ArrayList id="ref-17" xmlns:a1="http://schemas.microsoft.com/clr/ns/System.Collections">
<_items href="#ref-43"/>
<_size>1</_size>
<_version>136</_version>
</a1:ArrayList>
<a1:ArrayList id="ref-19" xmlns:a1="http://schemas.microsoft.com/clr/ns/System.Collections">
<_items href="#ref-44"/>
<_size>2</_size>
<_version>24</_version>
</a1:ArrayList>
<a1:ArrayList id="ref-21" xmlns:a1="http://schemas.microsoft.com/clr/ns/System.Collections">
<_items href="#ref-45"/>
<_size>2</_size>
<_version>36</_version>
</a1:ArrayList>
<a1:ArrayList id="ref-23" xmlns:a1="http://schemas.microsoft.com/clr/ns/System.Collections">
<_items href="#ref-46"/>
<_size>3</_size>
<_version>16</_version>
</a1:ArrayList>
<a1:ArrayList id="ref-25" xmlns:a1="http://schemas.microsoft.com/clr/ns/System.Collections">
<_items href="#ref-47"/>
<_size>2</_size>
<_version>18</_version>
</a1:ArrayList>
<a1:ArrayList id="ref-27" xmlns:a1="http://schemas.microsoft.com/clr/ns/System.Collections">
<_items href="#ref-48"/>
<_size>3</_size>
<_version>12</_version>
</a1:ArrayList>
<a1:ArrayList id="ref-29" xmlns:a1="http://schemas.microsoft.com/clr/ns/System.Collections">
<_items href="#ref-49"/>
<_size>2</_size>
<_version>873</_version>
</a1:ArrayList>
<a1:ArrayList id="ref-31" xmlns:a1="http://schemas.microsoft.com/clr/ns/System.Collections">
<_items href="#ref-50"/>
<_size>2</_size>
<_version>18</_version>
</a1:ArrayList>
<a1:ArrayList id="ref-33" xmlns:a1="http://schemas.microsoft.com/clr/ns/System.Collections">
<_items href="#ref-51"/>
<_size>2</_size>
<_version>42</_version>
</a1:ArrayList>
<a1:ArrayList id="ref-35" xmlns:a1="http://schemas.microsoft.com/clr/ns/System.Collections">
<_items href="#ref-52"/>
<_size>1</_size>
<_version>478</_version>
</a1:ArrayList>
<a1:ArrayList id="ref-37" xmlns:a1="http://schemas.microsoft.com/clr/ns/System.Collections">
<_items href="#ref-53"/>
<_size>1</_size>
<_version>18</_version>
</a1:ArrayList>
<a1:ArrayList id="ref-39" xmlns:a1="http://schemas.microsoft.com/clr/ns/System.Collections">
<_items href="#ref-54"/>
<_size>1</_size>
<_version>56</_version>
</a1:ArrayList>
<a1:ArrayList id="ref-41" xmlns:a1="http://schemas.microsoft.com/clr/ns/System.Collections">
<_items href="#ref-55"/>
<_size>1</_size>
<_version>36</_version>
</a1:ArrayList>
<SOAP-ENC:Array id="ref-43" SOAP-ENC:arrayType="xsd:anyType[4]">
<item href="#ref-56"/>
</SOAP-ENC:Array>
<SOAP-ENC:Array id="ref-44" SOAP-ENC:arrayType="xsd:anyType[4]">
<item href="#ref-57"/>
<item href="#ref-58"/>
</SOAP-ENC:Array>
<SOAP-ENC:Array id="ref-45" SOAP-ENC:arrayType="xsd:anyType[4]">
<item href="#ref-59"/>
<item href="#ref-60"/>
</SOAP-ENC:Array>
<SOAP-ENC:Array id="ref-46" SOAP-ENC:arrayType="xsd:anyType[4]">
<item href="#ref-61"/>
<item href="#ref-62"/>
<item href="#ref-63"/>
</SOAP-ENC:Array>
<SOAP-ENC:Array id="ref-47" SOAP-ENC:arrayType="xsd:anyType[4]">
<item href="#ref-64"/>
<item href="#ref-65"/>
</SOAP-ENC:Array>
<SOAP-ENC:Array id="ref-48" SOAP-ENC:arrayType="xsd:anyType[4]">
<item href="#ref-66"/>
<item href="#ref-67"/>
<item href="#ref-68"/>
</SOAP-ENC:Array>
<SOAP-ENC:Array id="ref-49" SOAP-ENC:arrayType="xsd:anyType[4]">
<item href="#ref-69"/>
<item href="#ref-70"/>
</SOAP-ENC:Array>
<SOAP-ENC:Array id="ref-50" SOAP-ENC:arrayType="xsd:anyType[4]">
<item href="#ref-71"/>
<item href="#ref-72"/>
</SOAP-ENC:Array>
<SOAP-ENC:Array id="ref-51" SOAP-ENC:arrayType="xsd:anyType[4]">
<item href="#ref-73"/>
<item href="#ref-74"/>
</SOAP-ENC:Array>
<SOAP-ENC:Array id="ref-52" SOAP-ENC:arrayType="xsd:anyType[4]">
<item href="#ref-75"/>
</SOAP-ENC:Array>
<SOAP-ENC:Array id="ref-53" SOAP-ENC:arrayType="xsd:anyType[4]">
<item href="#ref-76"/>
</SOAP-ENC:Array>
<SOAP-ENC:Array id="ref-54" SOAP-ENC:arrayType="xsd:anyType[4]">
<item href="#ref-77"/>
</SOAP-ENC:Array>
<SOAP-ENC:Array id="ref-55" SOAP-ENC:arrayType="xsd:anyType[4]">
<item href="#ref-78"/>
</SOAP-ENC:Array>
<a3:FilterDefinition id="ref-56" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction id="ref-79"></restriction>
<whereClause id="ref-80">title</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue id="ref-81">*</whereValue>
<selectedValue href="#ref-79"/>
<defaultView id="ref-82">List</defaultView>
<defaultSort id="ref-83">Name</defaultSort>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-57" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause id="ref-84">titleindex</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue id="ref-85">*</whereValue>
<selectedValue href="#ref-79"/>
<defaultView id="ref-86">List</defaultView>
<defaultSort href="#ref-79"/>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-58" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause id="ref-87">title</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue href="#ref-85"/>
<selectedValue href="#ref-79"/>
<defaultView href="#ref-86"/>
<defaultSort id="ref-88">Name</defaultSort>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-59" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause id="ref-89">actor</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue id="ref-90">*</whereValue>
<selectedValue href="#ref-79"/>
<defaultView href="#ref-82"/>
<defaultSort id="ref-91">Name</defaultSort>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-60" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause href="#ref-80"/>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue href="#ref-90"/>
<selectedValue href="#ref-79"/>
<defaultView href="#ref-82"/>
<defaultSort href="#ref-91"/>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-61" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause id="ref-92">actorindex</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue href="#ref-85"/>
<selectedValue href="#ref-79"/>
<defaultView id="ref-93">List</defaultView>
<defaultSort href="#ref-79"/>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-62" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause id="ref-94">actor</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue href="#ref-85"/>
<selectedValue href="#ref-79"/>
<defaultView href="#ref-93"/>
<defaultSort id="ref-95">Name</defaultSort>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-63" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause id="ref-96">title</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue href="#ref-85"/>
<selectedValue href="#ref-79"/>
<defaultView href="#ref-93"/>
<defaultSort id="ref-97">Name</defaultSort>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-64" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause id="ref-98">director</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue href="#ref-90"/>
<selectedValue href="#ref-79"/>
<defaultView id="ref-99">List</defaultView>
<defaultSort id="ref-100">Name</defaultSort>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-65" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause id="ref-101">title</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue href="#ref-90"/>
<selectedValue href="#ref-79"/>
<defaultView href="#ref-99"/>
<defaultSort id="ref-102">Name</defaultSort>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-66" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause id="ref-103">directorindex</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue href="#ref-85"/>
<selectedValue href="#ref-79"/>
<defaultView href="#ref-93"/>
<defaultSort href="#ref-79"/>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-67" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause id="ref-104">director</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue href="#ref-85"/>
<selectedValue href="#ref-79"/>
<defaultView href="#ref-93"/>
<defaultSort id="ref-105">Name</defaultSort>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-68" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause id="ref-106">title</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue href="#ref-85"/>
<selectedValue href="#ref-79"/>
<defaultView href="#ref-93"/>
<defaultSort id="ref-107">Name</defaultSort>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-69" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause id="ref-108">genre</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue href="#ref-90"/>
<selectedValue href="#ref-79"/>
<defaultView href="#ref-82"/>
<defaultSort href="#ref-91"/>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-70" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause href="#ref-80"/>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue href="#ref-90"/>
<selectedValue href="#ref-79"/>
<defaultView href="#ref-82"/>
<defaultSort href="#ref-91"/>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-71" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause id="ref-109">user groups</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue href="#ref-81"/>
<selectedValue href="#ref-79"/>
<defaultView id="ref-110">List</defaultView>
<defaultSort id="ref-111">Name</defaultSort>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-72" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause id="ref-112">title</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue href="#ref-81"/>
<selectedValue href="#ref-79"/>
<defaultView href="#ref-110"/>
<defaultSort id="ref-113">Year</defaultSort>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-73" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause id="ref-114">year</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue id="ref-115">*</whereValue>
<selectedValue href="#ref-79"/>
<defaultView href="#ref-82"/>
<defaultSort id="ref-116">Year</defaultSort>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-74" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction href="#ref-79"/>
<whereClause href="#ref-80"/>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue href="#ref-115"/>
<selectedValue href="#ref-79"/>
<defaultView href="#ref-82"/>
<defaultSort href="#ref-91"/>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-75" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>false</sortAscending>
<skipLevel>false</skipLevel>
<restriction id="ref-117">7</restriction>
<whereClause id="ref-118">recently added</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue id="ref-119">*</whereValue>
<selectedValue href="#ref-79"/>
<defaultView href="#ref-82"/>
<defaultSort id="ref-120">Date</defaultSort>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-76" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>false</sortAscending>
<skipLevel>false</skipLevel>
<restriction id="ref-121">7</restriction>
<whereClause id="ref-122">recently watched</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator href="#ref-79"/>
<whereValue id="ref-123">*</whereValue>
<selectedValue href="#ref-79"/>
<defaultView href="#ref-82"/>
<defaultSort href="#ref-120"/>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-77" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction id="ref-124">0</restriction>
<whereClause id="ref-125">watched</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator id="ref-126">&#62;</sqloperator>
<whereValue id="ref-127">*</whereValue>
<selectedValue href="#ref-79"/>
<defaultView id="ref-128">List</defaultView>
<defaultSort id="ref-129">Name</defaultSort>
<limit>-1</limit>
</a3:FilterDefinition>
<a3:FilterDefinition id="ref-78" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/MediaPortal.GUI.View/Core%2C%20Version%3D1.2.200.0%2C%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
<distinct>false</distinct>
<sortAscending>true</sortAscending>
<skipLevel>false</skipLevel>
<restriction id="ref-130">0</restriction>
<whereClause id="ref-131">watched</whereClause>
<fromStatement href="#ref-79"/>
<sqloperator id="ref-132">=</sqloperator>
<whereValue id="ref-133">*</whereValue>
<selectedValue href="#ref-79"/>
<defaultView id="ref-134">List</defaultView>
<defaultSort id="ref-135">Name</defaultSort>
<limit>-1</limit>
</a3:FilterDefinition>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
    [collapse]
     
    D

    Deda

    Lead Dev MP1 Videos
  • Premium Supporter
    • March 18, 2009
    2,423
    2,385
    Zagreb
    Home Country
    Croatia Croatia
    RicoHTPC said:
    Isn't working for me either and can someone confirm my bug from the post above?
    Sort by years in user groups leads to getting sorted by viewed...
    Click to expand...

    Found a problem. Will be fixed in next release (1.3.0.RC) -> just lost 5hours to detect that :)
     
    Dadeo

    Dadeo

    Docs Group Manager
  • Premium Supporter
    • November 26, 2006
    5,340
    3,321
    Himalayas, India
    Home Country
    Canada Canada
    @Deda - sorry for the aggro we are causing you :( - I fully understand the issues you are facing, and I don't want you to end up 'drowning in poo'!

    Your post above is better than a comedy show - I laughed so hard - even though I am sorry for you, and I am sure it is very exasperating (I have often felt the same when skinning!). But you express it with so much good natured humour. As I often say, 'you can't make a silk's purse out of a sow's ear'. So thanks for checking. I am sure I won't die if I cannot sort all db views by date (I always find a workaround eventually :)) You don't need to hear my comments about Shares view and Database views sharing the same methods! :censored:
     
    Last edited:
    RicoHTPC

    RicoHTPC

    MP Donator
  • Premium Supporter
    • February 4, 2011
    1,441
    172
    Cuxhaven
    Home Country
    Germany Germany
    I'm feeling quite ab bit guilty now for causing so much trouble and I hardly dare to ask but I was actually trying to find out something
    different as I discovered this sorting by year problem. What I wanted to do was to display the movies by year and in case
    they are all from one year to have them sorted by name. Will this work then too?

    I guess you Deda will be especially happy once mp2 is released where those problems will be much easier to solve as I understand it.
    But be assured that we really appreciate your hard work!
     
    D

    Deda

    Lead Dev MP1 Videos
  • Premium Supporter
    • March 18, 2009
    2,423
    2,385
    Zagreb
    Home Country
    Croatia Croatia
    I'm not angry :) I was just frustrated that I could not find a cure for a problem even I obviously looking at single code line which cause a problem but origin was not on that place but elsewhere and was actually (as always) stupidly simple to fix on the end.

    I will post here fixed dll for 1.3.0B so you can test sorting.
     
    D

    Deda

    Lead Dev MP1 Videos
  • Premium Supporter
    • March 18, 2009
    2,423
    2,385
    Zagreb
    Home Country
    Croatia Croatia
    Ok @RicoHTPC, here's the dll for 1.3.0B. Sort should be ok now (except "by date" in database views for all except [Recently added/Watched], this can't be solved before 1.4.x because I need to do big changes for sorting in code)

    Backup original file before overwrite :)
     

    Attachments

    • WindowPlugins.rar
      395.8 KB
    RicoHTPC

    RicoHTPC

    MP Donator
  • Premium Supporter
    • February 4, 2011
    1,441
    172
    Cuxhaven
    Home Country
    Germany Germany
    Sorting by year works without problems now.
    Sorting with different priorities (first priority: sort by year, second: sort by name) does not work but I guess that's not possible either
    without turning everything upside down...
     
    D

    Deda

    Lead Dev MP1 Videos
  • Premium Supporter
    • March 18, 2009
    2,423
    2,385
    Zagreb
    Home Country
    Croatia Croatia
    Well, your case (changed to),
    1.usergroup by year (titles not added to groups should be sorted by year)
    2.Title by Name

    should work (I just try it on beta release with this fix) but

    1. Actors by year->this fail
    2. Title by year

    not.

    Problem is that in views designer you can choose whatever you want but sort code can't swallow that and also views designer is "stupid" and does not work on database logic (all inside is hardcoded) so you have to guess with try & error how to design your custom view so it should work. That's why I add more views there as defaults but all can be solved with simple SQL builder which can follow database logic (there is some internal work on music views for this but it's hard work on current MP design) and drop this view designer completely or leave it (as light version without actors, rating...) only for share views.
     
    Last edited:
    You must log in or register to reply here.

    Users who are viewing this thread

    Online now: 3 (members: 0, guests: 3)

    About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

    Quick Navigation

    Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!

    Community platform by XenForo® © 2010-2021 XenForo Ltd.
    Top Bottom