[Maverickz]

So looking at this page: https://kodi.wiki/view/Opening_Windows_and_Dialogs

There are several built in Sub-Sections with videodb paths. Ex: InProgressTvShows   =  videodb://inprogresstvshows

The inprogresstvshows referenced above, only returns shows that have at least 1 unwatched episode AND at least 1 watched episode, thus leaving out shows that have unwatched episodes but no watched episodes.
Since it references "videodb", I thought maybe it was some sort of stored procedure in the DB or something, but opening it in SQLite Expert, I didn't see any stored procedures or anything.

So where are these custom paths stored/created?
Is it possible to create a new one that returns a COMPLETE list of TV Shows that have any unwatched episodes?

[Maverickz]

More than 4 months later, I am still fighting with this. Anyone have a clue?

[jjd-uk]

The inprogresstvshows referenced above, only returns shows that have at least 1 unwatched episode AND at least 1 watched episode, thus leaving out shows that have unwatched episodes but no watched episodes.

If you haven't watched any episodes then how can it be In Progress, therefore what you need to create a rule for shows not in progress. Get what you want working using a Smartplaylist, see https://kodi.wiki/view/Smart_playlists, then once you have that working you can use the generated xml file to create a custom video node, see https://kodi.wiki/view/Video_nodes, as the syntax is very similar.

[Maverickz]

The inprogresstvshows referenced above, only returns shows that have at least 1 unwatched episode AND at least 1 watched episode, thus leaving out shows that have unwatched episodes but no watched episodes.

If you haven't watched any episodes then how can it be In Progress, therefore what you need to create a rule for shows not in progress. Get what you want working using a Smartplaylist, see https://kodi.wiki/view/Smart_playlists, then once you have that working you can use the generated xml file to create a custom video node, see https://kodi.wiki/view/Video_nodes, as the syntax is very similar.    

The reason I am asking about creating a custom path as mentioned in my first post is because what i want to do is NOT possible using smart playlists. What I am trying to accomplish is on the Estuary Homescreen to remove the "In Progress TV Shows" AND the "Unwatched TV Shows" rows and replace them with a single combined row that includes essentially both lists. I know how to edit the home screen to remove the rows and change the rules that govern what the rows show, but at this point the current rule system will not allow me to accomplish what should be a super simple task. I am not sure what the point was to split the "unwatched" list into two rows to begin with.

The problem with the smart playlist rules is that in order to accomplish this, I would need any ONE of the following options to be possible:

OPTION 1: Nested Rules/RuleSets with videodb path - This would allow the combination of both videodb://inprogresstvshows with the more traditional "unwatched" list.

    <match>one</match>
        <rule field="path" operator="is"><value>videodb://inprogresstvshows</value></rule>
        <ruleset>
           <match>all</match>
                <rule field="numwatched" operator="is">
                         <value>0</value>
                 </rule>
                 <rule field="numepisodes" operator="greaterthan">
                          <value>0</value>
          </ruleset>

OPTION 2:  Compare Field to Field -  Add the ability compare two fields directly in a rule instead of having to compare a field to a predetermined value.

    <rule field="numepisodes" operator="greaterthan">
         <field="numwatched">
    </rule>

OPTION 3: Add a new Field -  Add a field called "numUNwatched" which contains a count of episodes that have NOT been watched. This could be done just reading the episode totalCount and watchedCount fields and subtracting. If that existed then I could simply use:

    <rule field="numUNwatched" operator="greaterthan">
              <value>0</value>

Since NONE of these are currently possible and all of them require code changes to Kodi to become possible, I was hoping there was some way I could add a Custom videodb path in a way that would not require a code change in Kodi. I also tried using the 'Hide Watched' option but that only affects the sub lists (Genres, Title, Year, etc.) and NOT the home screen itself. I hope this makes what I am trying to accomplish more clear.