Code: Select all
Complete Albums|SQL Filter:Albums.ID IN (SELECT Albums.ID FROM Albums, Songs WHERE Songs.idAlbum = Albums.Id GROUP BY Albums.Id HAVING Count(*)>=5)\<Album Artist|all:no|Unknown:no>\<Album|all:no|Min tracks:5|Unknown:no>
Code: Select all
Complete Albums|SQL Filter:Albums.ID IN (SELECT Albums.ID FROM Albums, Songs WHERE Songs.idAlbum = Albums.Id GROUP BY Albums.Id HAVING Count(*)>=5)\<Album Artist|all:no|Unknown:no>\<Album|all:no|Min tracks:5|Unknown:no>
It happened to me several times that queries that work in access don't work at all from outside, so it seems it can also happen that it's just faster in Access. The problem is that the script generates SQL queries on the fly so it's difficult to optimize them. In any case, it would be good to make this behavior the default, without having to add any SQL filter, and faster as welltss wrote: Any idea why it takes so long to load? The same query in Access is quite fast.
Nice . You can send me a PM.tss wrote:I've enhanced Magic Nodes to have a max tracks qualifier. Want me to email you the file? Or is there a way to send it on this forum?
. What version of MM are you using? Is there anything special about your skin or display? anyone else experiencing this???jmaver wrote:The Ok and Cancel buttons on the edit dialog are halfway over the edit field, so it makes it hard to actually see what is in there.
Code: Select all
Album Artist|shortcut:Ctrl+F8|child of:artist|icon: top level|show tracks: yes\<Album Artist|show tracks:yes>\<Album|Sort by:max(year)|all:no>
Just in case it wasn't clear, I re-installed MediaMonkey to get the error message to go away (no biggie, just clarifying in case someone else runs into the issue)Pablo wrote:Nice... I will add a remainder to delete the previous version in the installation instructions.sadao wrote:Re-install fixed the problem . Playing with it now.
jmaver wrote:Thanks for adding all those features
Well, you're giving me some nice ideas... I wouldn't necessarily fulfill stupid requests .sadao wrote:Thanks for taking the time and trouble to so fulfill my requests
Actually, it's neither of the three. In general, the qualifiers applied at the caption level are different from the ones applied at the field level (between <>). However, show tracks: should be available in both , so I'll add it as a global qualifier in the next release.sadao wrote:Bug or feature (or Sadao is just stupid)?
Ohh, ok. That's strange . The script will definitely not work if you have two versions in the auto folder, but moving one of them out should solve the problem.sadao wrote:Just in case it wasn't clear, I re-installed MediaMonkey to get the error message to go away (no biggie, just clarifying in case someone else runs into the issue)