Sort by Date Added

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
SandmanCL Offline
Multi-platform XBMC fan
Posts: 572
Joined: Jul 2004
Reputation: 1
Location: San Francisco, CA
Post: #1
Is 'dateadded' a field in the video database as well as audio ? If so, would it be possible to get a 'Date Added' Sort-by option ? That would be very useful, in my opinion.
find quote
jmarshall Offline
Team-XBMC Developer
Posts: 24,523
Joined: Oct 2003
Reputation: 138
Post: #2
Recently Added Media, and/or use a smartplaylist to grab them. Not sure if there's a dateadded or not - check the smartplaylist editor.

Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


[Image: badge.gif]
find quote
SandmanCL Offline
Multi-platform XBMC fan
Posts: 572
Joined: Jul 2004
Reputation: 1
Location: San Francisco, CA
Post: #3
I just exported my video database and there's no dateadded field there, so I guess this isn't possible. The smartlist editor had no such field either. The closest one was 'year'.
find quote
Nuka1195 Offline
Skilled Python Coder
Posts: 3,917
Joined: Dec 2004
Reputation: 17
Post: #4
you could sort by idMovie, the more recent the higher the number

For python coding questions first see http://mirrors.xbmc.org/docs/python-docs/
find quote
jmarshall Offline
Team-XBMC Developer
Posts: 24,523
Joined: Oct 2003
Reputation: 138
Post: #5
Only if a clean hasn't been performed - sqlite can add back in to old slots.

Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


[Image: badge.gif]
find quote
SandmanCL Offline
Multi-platform XBMC fan
Posts: 572
Joined: Jul 2004
Reputation: 1
Location: San Francisco, CA
Post: #6
Cool, I'll look into sorting my idMovie. Assuming it wouldn't be too hard to add that myself as long as I find out which skin xml file to modify. Good thing I didn't do the database clean this morning ! Big Grin
find quote
watzen Offline
Fan
Posts: 459
Joined: Jan 2007
Reputation: 10
Location: Sweden
Post: #7
I'm reviving this old thread in hope to get some more discussion going around this topic.

for what I know the column dateadded is still not added to the database and I created a ticket regarding this about 7 weeks ago: http://trac.xbmc.org/ticket/5542

But perhaps instead of adding the dateadded info, we should add the filecreationdate instead. This would serve the same purpose but would not be wiped if the database was lost.

  • Livingroom - C2D E8400, P5N7A-VM on a Samsung 46" LE46M86 FullHD via HDMI
  • Kitchen - ASRock 330 HT Displayed on a Samsung Lapfit 22" dual touch screen LD220Z
  • Bedroom - LG Laptop on a 32" tv
find quote
xexe Offline
Fan
Posts: 711
Joined: Sep 2008
Reputation: 1
Post: #8
From and end user POV this may help clarify the logic with "recently added tv/movies".

Making some assumptions these views show what is new within the library. However this can be effected by changed in regex matching, adding a new source etc. The macro effect of this is that the views can be flooded with new content for the library which is actually old for the users collection.

For instance one of my show matches yesterday filled my new view with a show that has been in my collection since 2006. At the same time the new shows which are actually new to my collection were swamped out of the view completely completely negating the usefulness of the feature.

So essentially were looking at a mechanism that displays actually new to the users collection rather than new to the XBMC library.


Having problems getting your TV shows recognized?

Try my extra TV show matching REGEX here
find quote
Tylast Offline
Junior Member
Posts: 1
Joined: Sep 2010
Reputation: 0
Post: #9
I too would like this feature. Perhaps I'm just not seeing it in the gui? If it's not there, surely there is a way to add a "date added to DB" field/function & keep it from being modified.
find quote
dazed Offline
Junior Member
Posts: 7
Joined: Oct 2010
Reputation: 0
Post: #10
I suggested something similar in another thread, and I agree, this would not only be a useful function, but frankly a needed one for anyone with an extensive digital media collection, and a incessant file collector like myself... so +1?
Sorry if posting/linking/bumping here is not appropriate, still unfamiliar with the ticket/trac system here, more of an "end user"/hardware type, unlikely to go about editing mySQL DBs to achieve a function... :-)

If I was a noob, I'd be asking for ETAs.
(This post was last modified: 2010-10-16 21:19 by dazed.)
find quote