INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Need help with audio smartlist  (Read 2832 times)

Jaqqe

  • Regular Member
  • World Citizen
  • ***
  • Posts: 164
Need help with audio smartlist
« on: August 01, 2013, 09:27:54 am »

Is it possible to create a smartlist that would show me all audio files that have the same ARTIST and NAME but different RATING. The RATING might even be missing from some file(s). It should not however show songs where the RATING is already the same in all.

Examples:

Let's say I have 3 copies of this song. The smartlist should show me ALL Love me tender's by Elvis, since there is difference in the ratings.
ELVIS - Love me tender ****
ELVIS - Love me tender ****
ELVIS - Love me tender *****

However if I have 4 copies of the song with ALL having the same RATING, none of these should be shown in the list.
ELVIS - Love me tender ****
ELVIS - Love me tender ****
ELVIS - Love me tender ****
ELVIS - Love me tender ****

Is this possible?
Logged
Money... no, chocolate makes the world go round. Even here in Finland.

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Need help with audio smartlist
« Reply #1 on: August 01, 2013, 02:37:36 pm »

I don't believe so.

But you can do a similar things with global variables.

Customize or create a new panes view, and add this to the Set rules for file display (using the Import/Export button):

[Media Type]=[Audio] [=1save(-1,v_[name]_[artist])]=1 [=1ifelse(isequal(load(v_[name]_[artist]), -1), save([Rating], v_[name]_[artist]), !isequal([Rating], load(v_[name]_[artist])), save(10,v_[name]_[artist]))]=1

Add an Artist and an Name column.  Also add an expression column, call it Ratings, with the expression value of:

Load(v_[name]_[artist])

Once the view is done, select the 10 item under the Ratings column.  All the tracks now show should be your mixed ratings.
Logged
The opinions I express represent my own folly.

Jaqqe

  • Regular Member
  • World Citizen
  • ***
  • Posts: 164
Re: Need help with audio smartlist
« Reply #2 on: August 01, 2013, 11:26:46 pm »

Thanks MrC, but it doesn't seem to work...

None of the songs should actually be visible after selecting "10" in the ratings: "It hurts me too" because they have the same rating and the others because there is only one copy of the songs in the database.

Logged
Money... no, chocolate makes the world go round. Even here in Finland.

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Need help with audio smartlist
« Reply #3 on: August 02, 2013, 12:51:22 am »

I'm sorry.  I tested using one set of values, but last minute changed them to work for your needs.  But I messed up.

Change all occurrences of albumkey() to [name]_[artist].

I've corrected the code above.
Logged
The opinions I express represent my own folly.

Jaqqe

  • Regular Member
  • World Citizen
  • ***
  • Posts: 164
Re: Need help with audio smartlist
« Reply #4 on: August 02, 2013, 01:21:47 am »

Thank you very much, MrC! Works nicely now.
Logged
Money... no, chocolate makes the world go round. Even here in Finland.

Jaqqe

  • Regular Member
  • World Citizen
  • ***
  • Posts: 164
Re: Need help with audio smartlist
« Reply #5 on: August 02, 2013, 02:32:59 am »

An improvement idea came to mind...  :P

What if I wanted to discard two (or more) genres from the comparison? For example, I would like to disregard all songs with "Jazz" in the genre?
Logged
Money... no, chocolate makes the world go round. Even here in Finland.

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Need help with audio smartlist
« Reply #6 on: August 02, 2013, 02:45:50 am »

Just add to the Set rules for file display, when you Customize the view.  Add a rule that Genre is not Jazz.  Use import/export to move it right after the rule that selects Media Type=Audio.
Logged
The opinions I express represent my own folly.

Jaqqe

  • Regular Member
  • World Citizen
  • ***
  • Posts: 164
Re: Need help with audio smartlist
« Reply #7 on: August 02, 2013, 02:49:57 am »

But of course, thank you again :-)
Logged
Money... no, chocolate makes the world go round. Even here in Finland.

kensn

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1352
Re: Need help with audio smartlist
« Reply #8 on: December 01, 2013, 12:08:11 pm »

Thanks MrC... was working on this, and went searching for help...

Ken
Logged
If(IsEmpty([Coffee Cup]), Coffee, Drink)
Pages: [1]   Go Up