FEATURE REQUEST: [MTM] Report/Query to find Movies/Shows by Library Collection

[babsonnexus]

https://community.getchannels.com/t/filter-movies-by-not-in-collection/43151

"eldienne, post:1, topic:43151, full:true"
I am unsure if this is possible or not - any way to filter movies using the DVR/Manage/Movies section to show only movies which are not in a collection?

Sometimes when movies are added to the library they do not show up in recently added section and can get lost easily with large libraries. I put all of mine into collections by genre but often find ones O have missed that are not in a collection and subsequently do not show in my movies library (unless I go to 'all movies'.

I can write a report/query for Media Tools Manager (a Streaming Library Manager for Channels extension) that can do this. I already did something similar for Channel Collections:

https://community.getchannels.com/t/release-media-tools-manager-streaming-library-manager-extension/42368/8

---

In order to accomplish this, I need two data sets.

(1) At /dvr/collections/content I can get a list of Library Collections and the items assigned to them are the ID's of the Movies and Shows.

(2) Using the standard Channels DVR API, I can get the list of Movies and Shows with all their pertinent details.

Cross referencing these data sets will give me the info needed. Anything without a collection will get a value of No Library Collection and can be filtered on that way to get the results. There is no reason why I cannot do both Movies and TV Shows together, so will also needed to add a column for "type".

[babsonnexus]

As part of this, I'll also be redesigning 'Reports & Queries' to use a dropdown a la 'Files' instead of a bunch of buttons.