INTERACT FORUM

Please login or register.

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

Author Topic: expressions - anything new planned for v12 ?  (Read 1922 times)

hit_ny

  • Citizen of the Universe
  • *****
  • Posts: 3310
  • nothing more to say...
expressions - anything new planned for v12 ?
« on: November 29, 2006, 06:32:23 am »

Love them or hate them, they get the job done.

..so was wondering what's in store for this version.
Logged

EpF

  • Citizen of the Universe
  • *****
  • Posts: 649
Re: expressions - anything new planned for v12 ?
« Reply #1 on: November 29, 2006, 10:00:12 am »

Love them or hate them, they get the job done.
? Why would you hate them? Love them or ignore them!  ;D

Any added functionality to expressions would be very welcome.

KingSparta

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 20063
Re: expressions - anything new planned for v12 ?
« Reply #2 on: November 29, 2006, 10:22:06 am »

Quote
Why would you hate them?

Because It Maybe Too Complex For A User And They May Just Give Up.

I Have Never Attempted To Create Anything But Minor Ones Compared To Some I Have Seen That Are So Complex You Would Need To Take A 4 Year Collage Course On Building Expressions For Media Center.

An Expression Wizard Would Help
Logged
Retired Military, Airborne, Air Assault, And Flight Wings.
Model Trains, Internet, Ham Radio, Music
https://MyAAGrapevines.com
https://centercitybbs.com
Fayetteville, NC, USA

hit_ny

  • Citizen of the Universe
  • *****
  • Posts: 3310
  • nothing more to say...
Re: expressions - anything new planned for v12 ?
« Reply #3 on: November 29, 2006, 02:22:24 pm »

The hardest part for me was getting the syntax right, but that was sorted here

Since MC gives no indication at all wheter a comma is missing or a bracket is in the wrong place or even a mispelled [Field].

EpF's macro can handle most of these, maybe this will get looked at in the next version but for now new functions would defnitely be welcome.
Logged

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9139
Re: expressions - anything new planned for v12 ?
« Reply #4 on: November 29, 2006, 03:17:32 pm »

expressions open up amazing possibilities. for now, MC is exclusively managing my images, and without the ability to use expressions in thumbnail text, this would probably not be the case.

amongst other things, I would like to see the new expression editor available from every location that accepts expressions.

brainsoup

  • Regular Member
  • World Citizen
  • ***
  • Posts: 151
  • Sexy! No No No...
Re: expressions - anything new planned for v12 ?
« Reply #5 on: November 29, 2006, 04:45:19 pm »

I would really like to see expressions that can perform calculations between two fields (numerical)

e.g. sum(fieldA,fieldB), difference(fieldA,fieldB) etc...

That would make MC expressions very powerful...

I was also thinking along the possibility of summing over another variable

e.g. Total(Number Plays,Artist) would obtain the total number of plays for that artist or Total (Rating, Album) would give the total rating for that album (i.e 45 for 9 tracks at 5), or even Total(1,Name) would sum up the number of tracks with the same name as that track...

You could then use this to produce some pretty nice fields that could be used very well in Smartlists and such...

Just a thought ;)
Logged

hit_ny

  • Citizen of the Universe
  • *****
  • Posts: 3310
  • nothing more to say...
Re: expressions - anything new planned for v12 ?
« Reply #6 on: November 29, 2006, 11:55:40 pm »

Numerical expressions are exactly what i was looking for, amongst others a way to average ratings so i don't have to do this manually. I'm not bothered too much with speed as these can be calculated and cached in another field  for faster display in view schemes.

When thinking about how to do this, how about "group by", since expressions can only carry out operations on one item at at time and are not able to take into account values from other items.

So group by [Field] could give a way to select a [Field] that was common between items and then carry out a calculation.

This would work with associative math, like addition or multiplication where the order that the items are presented in, does not affect the result.

(5+2)+1 = 5+(2+1) or  5 x ( 2 x 3 ) = (5 x 2 ) x 3

It gets trickier with non-asociative math like subtraction & division where the order of items matters.

(5 - 2) - 3 does not equal (5 - 3) - 2

maybe that could be solved using parenthesis, to indicate order of calculation.
Logged

brainsoup

  • Regular Member
  • World Citizen
  • ***
  • Posts: 151
  • Sexy! No No No...
Re: expressions - anything new planned for v12 ?
« Reply #7 on: November 30, 2006, 04:45:12 am »

I think with just the functions provided it would be pretty easy to create an average...

eg average rating for an album

divide(Total(Rating,Album),Total(1,Album))

I agree with using a field to store this data. This is what I initially thought calculated fields were but alas they are not... such a shame as there are so many things that I would like to do with these things and with just five functions (The 4 op's and a Total function) all of them would be possible. Maybe if using this for expressions would be too time consuming then maybe limiting it to calculated fields.

Lets keep our fingers crossed...  ;D
Logged
Pages: [1]   Go Up