More > JRiver Media Center 27 for Windows
Issue with FieldQuery() and dates
markf2748:
--- Quote from: zybex on June 12, 2021, 10:51:53 am ---If the numbers are different, then it's a different date. The value represents the number of seconds since 1970. You can convert it to a date here:
https://www.epochconverter.com/
--- End quote ---
The sortable date returned by my Expression Field ConvertDate(GroupSummaryQuery(album, last played, 1)) is in MC's float format, so the Unix format converter does not apply. I've now added another custom field without the ConvertDate() call which shows up in the tag panel as human readable. Very helpful.
--- Quote from: zybex on June 12, 2021, 10:51:53 am ---If you create a View based on GroupSummaryQuery(), you'll notice that it takes a bit to load, then works very fast for about 1 minute. Then it stutters again while it recalculates, then works again for 1 minute. That's the best you can expect for now, using these functions.
--- End quote ---
Yes, I noticed the variable update delays when refreshing. Independent of these, I find it annoying that the built-in LAST PLAYED field only updates at the very end of the playing track (or when stopped after 50% play and then you start another track). Personally, I prefer to have it automatically update after a minute or so of audio play without stopping playback. A custom setting would be nice.
Re the problem "Other note" in my previous post: All is well after fixing a spelling inconsistency in filenames and related fields. The smartlist All Files (empty search) was very helpful in tracking this down :).
markf2748:
Good news update: A new field [Last Played (album)] is promised for MC 28:
https://yabb.jriver.com/interact/index.php/topic,129719.0.html
That should reduce this Last Played synchronization problem to a simple, high speed view sort like any other.
Worst case, you may need a new library field with the expression ConvertDate([Last Played (album)]) to make it sortable :).
--- Quote from: marko on June 12, 2021, 01:26:39 am ---I hope you found the Expression Language pages helpful. A lot of time has been poured into those :)
--- End quote ---
Very helpful indeed, essential to pursuing this topic. Soon there will be a few more pages to update!
markf2748:
--- Quote from: markf2748 on June 14, 2021, 01:12:14 pm ---Good news update: A new field [Last Played (album)] is promised for MC 28:
https://yabb.jriver.com/interact/index.php/topic,129719.0.html
That should reduce this Last Played synchronization problem to a simple, high speed view sort like any other.
--- End quote ---
Works fantastic in the new MC28.0.25! Tested synchronization between a Last Played Audio View and a Last Played Image View.
Simply specify in the view tab menus: Sort By > Custom > Descending (z-a) on "Last Played (album)".
The field also displays in human readable form by default when added to a tag window. :)
Notes:
As usual, a track's last played time does not update until it has completed, or else until it has played at least 50% thru and a new play starts.
The view may also need a Refresh (button or F5) to see very latest state when system is in between its internally scheduled updates (they occur approximately every minute).
Navigation
[0] Message Index
[*] Previous page
Go to full version