INTERACT FORUM

Please login or register.

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

Author Topic: Req: Using dates with smartlists/views  (Read 1337 times)

Marty3d

  • Citizen of the Universe
  • *****
  • Posts: 1363
Req: Using dates with smartlists/views
« on: March 18, 2003, 11:30:30 am »

Hi!

Just wanted to see if anyone else but me found it cool if you actually could use the different dates with View Scheme and smartlists.
Then you could:
1. Have a scheme showing files played each day (almost anyway since the database is limited to setting only the last date instead of each date a file is played)
2. Have a scheme showing days you imported different albums
3. Have smartlists showing 'files played last week' and such

Cool! Is it going to happen? :)

Thanks for your time,
/Martin
Logged


nila

  • Guest
Re: Req: Using dates with smartlists/views
« Reply #1 on: March 19, 2003, 05:24:47 am »

pretty sure you can already do this.

All the ones played in the last day:

lastplayed=<86400

(it's all done in seconds so you have to get your calculator out and hope your good at maths = 1 day = 60 seconds to make one minute * 60 minutes to make one hour * 24 hours to make one day so it's: 60x60x24xHoweverManyDaysYouWant)

Or for files played within the last week it's:
86400 * 7

lastplayed=<604800

etc. etc.

All date functions in MJ still need a lot of work and haven't been worked on much so dont worry too much :)
Logged

Marty3d

  • Citizen of the Universe
  • *****
  • Posts: 1363
Re: Req: Using dates with smartlists/views
« Reply #2 on: March 19, 2003, 07:33:10 am »

Yes I know the date functions are so so...and the seconds thing is a workaround. But if you wanted to view the songs played today, not 24 hours ago? There's a difference :) And it would be alot easier to track down a specific date than counting how many seconds ago that date was (besides, that number would be wrong the second after ;)
Logged


nila

  • Guest
Re: Req: Using dates with smartlists/views
« Reply #3 on: March 19, 2003, 07:54:42 am »

No - That's what I thought at first with it.

But entering the search phraze I said returns any songs that were played within the last 24 hours not that were played at that specific time.

A bit confusing I know but it works - just give it a go and you'll see :)

The date functions are still to come so hopefully they'll be super easy when they do come.
Logged

dragyn

  • Guest
Re: Req: Using dates with smartlists/views
« Reply #4 on: March 19, 2003, 10:41:10 am »

I think lastplayed= is in minutes, not seconds. ? :P
Logged

Marty3d

  • Citizen of the Universe
  • *****
  • Posts: 1363
Re: Req: Using dates with smartlists/views
« Reply #5 on: March 19, 2003, 10:47:16 am »

Quote
But if you wanted to view the songs played today, not 24 hours ago?


Of course I meant I wanted the songs played from 00:00 to Current time, and the "not 24 hours ago" was meant to be "from now and 24 hours back" :)

Anyway, thanks for the info, I'll be waiting for proper date handling though :)

Cheers,
/Martin
Logged


dragyn

  • Guest
Re: Req: Using dates with smartlists/views
« Reply #6 on: March 19, 2003, 11:04:50 am »

Marty,

When a song is being set for "lastplayed", it uses the number of seconds elapsed from 00:00:00 GMT, January 1, 1970.

So I think the guys could implement something for easier searching based off that time, someday.

Time will tell. ;)
Logged

Phydeaux

  • Regular Member
  • World Citizen
  • ***
  • Posts: 243
  • No comment... ;)
Re: Req: Using dates with smartlists/views
« Reply #7 on: March 21, 2003, 11:52:00 pm »

With Digital Photography, I would really like to create a view scheme by Date Created which will allow me to group all photos taken on a particular day. At the moment, adding "Date Created" to a view scheme brings up nothing. When you add grouping intervals, it gets messed up even more...

Ideally, would like to group by day, week, month or year. This would have to be intelligent. Weeks from Sunday / Monday -- as specified by system settings, Months as actual calendar months (Feb = 28 days, Mar = 31 etc.). Leap years also... This wouldn't be a true "Grouping Interval" as it is currently understood in MC.

My 2c worth.

P.
Logged
"Evil will always triumph over Good because Good is dumb." -- Spaceballs
Pages: [1]   Go Up