FreaQ wrote:Is it possible to do something for joining similiar comments?
I would like to have something where the magic nodes joins comments when the first 4 letters or numbers are identical.
I am not sure that I know what you want. If you just want all tracks grouped by first 4 characters of the comment, the mask is simple and really fast:
Code: Select all
Group by first 4 char. of Comment\<Comment|trim:4>
If you don't want to display those tracks which have unique comment, i.e. you want to display only tracks with a comment which is similar in two or more tracks, then a mask is more complex and the query lasts much longer:
Code: Select all
Only tracks with similar Comment|SQL filter:Songs.ID IN (SELECT Memos.IDSong FROM Memos, (SELECT Left(Memos.MemoText, 4) AS Comment FROM Memos WHERE Memos.MemoType = 20001 GROUP BY Left(Memos.MemoText, 4) HAVING Count(*) > 1) As Inline WHERE Left(Memos.MemoText, 4) = Inline.Comment)\<Comment|trim:4>
This mask is similar to Bex's previous one with 3 sub-queries (one is invisible in the mask). Execution time: 737 seconds (4627 tracks of ~15000)
In this case, solution with two sub-queries you shoud better don't try. It worked over one hour when I decided to reset program. This is very strange, obviously different situations needs different approach:
Code: Select all
Only tracks with similar Comment (much slower!)|SQL filter:Left(Memos.MemoText, 4) IN (SELECT DISTINCT Left(Memos.MemoText, 4) FROM Memos, Memos As Inline WHERE Left(Memos.MemoText, 4) = Left(Inline.MemoText, 4) AND Memos.IDMemo <> Inline.IDMemo AND Memos.MemoType = 20001)\<Comment|trim:4>
Note: Those masks only work with MM2, except the first, simplest one which works in MM3 as well.