Age In Collection

[jameson_uk]

I would like to see the ability to have a music view based on how long a track has been in your collection. In Meedio I wrote a plugin to allow you to specify which age bands you wanted to see (Less than 7 days, Less than 1 week, Less than 1 month etc)

There was an import routine that ran alongside the process to pull new and changed tracks into the database which updated a column storing this age bracket.

Then exposing this in a view meant I can access albums according to how long I have owned them. I have found this a really useful way of choosing what to listen to and it is not too difficult to do (especially as I see there is already a date added to collection field)

The other option would be to add some generic columns to the database which could be populated via plugins. The only problem then is exposing these via views but adding another tiny table which was structured like
generic_column_name real_name
gen1 age band
gen2 language
gen3 mood

where plugins could select to add in a new value when needed and the view screen would pickup values from this table and translate them into actual column names in the view.

Not sure this makes a huge amount of sense as I am very tired but you get the idea??