Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next
How To Include Child Values in Sorting?
Author Message
DVD Profiler Desktop and Mobile Registrantmucde
Registered: July 7, 2007
Germany Posts: 12
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I am running 3.6.1 (build 1392).  I now have a number of box sets added as a parent profile, with individual film child profiles.  This is a neat feature.

I often will chose a film to watch based on running time (e.g. something I want to watch on TV in 2 and a half hours, what films can I watch to maximise that time).  If I sort by running time in the collection list window (clicking on column header), the films in the boxsets are sorted by the total time for the complete boxset rather than the individual film. 

I haven't found any way to switch this so that it will by default allow me to search by individual items rather than parents.  The closest I have got is by also applying a running time filter, however that doesn't 100% fix it. 

As an example I have the two Che films on Blu-Ray.  If I add the filter runtime less than 6 hours, the two films appear as a parent child collection, only sortable by total run time.  If I change the runtime to less than four hours, the two films appear in the collection list as individual entries and the parent disappears.

The parent has an entry of 269 minutes as total running time for the two films.  As this is between 4 and six hours, I can understand there being a change.  If I remove the time for the parent, i.e. set it to zero, it always appears as a collection.  If I set it to a large number like 1000 minutes it always appears as only the two child items with a runtime filter, but I'd rather not do this as somethimes its nice to watch all films in a series.

Is there an easy way to do this?

Thanks,
Jon.
DVD Profiler Unlimited RegistrantMuckl
That's my common name.
Registered: April 9, 2009
Reputation: Great Rating
Germany Posts: 858
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
You could add a tag to all boxset profiles and filter all profiles without said tag, then sort your collection by running time and finally save the filter set. The sort order will be restored as well when you open the filter set.

Or you could use Mark's Database Query plugin:
- Install the plugin, start it from the "Extras" menu (keep "Load cast/crew data ..." selected the first time you run the plugin)
- Run any query, e.g. "Other" --> Field: "Watched" --> Query: "Unwatched Movies"
- Right click on the list, choose "View Columns", check "Running Time" and click the "Running Time" column title to sort
- Finally change the filter (little filter icon in menu) by unchecking "Box set profiles".
 
1.0.1, iPhone 3GS, iOS 4.1.0

Trivia v0.3.1
My HSDB v5 additions, HTML windows and other stuff
 Last edited: by Muckl
DVD Profiler Desktop and Mobile Registrantmucde
Registered: July 7, 2007
Germany Posts: 12
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Thanks Muckl,

I hadn't used the tags feature before.  That works perfectly!!

I'll check out Mark's Database Query plugin too, sounds like there could be some useful stuff in there too.

Thanks again.
DVD Profiler Unlimited RegistrantMuckl
That's my common name.
Registered: April 9, 2009
Reputation: Great Rating
Germany Posts: 858
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting mucde:
Quote:
I'll check out Mark's Database Query plugin too, sounds like there could be some useful stuff in there too.

You definitely should, it's become indispensable to me! 
 
1.0.1, iPhone 3GS, iOS 4.1.0

Trivia v0.3.1
My HSDB v5 additions, HTML windows and other stuff
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next