Music Views - How to work with Operator (2 Viewers)

[joEhSuper]

need log?
here it is

 

[ajs]

MP add '' and this not work ...

select * from tracks where  strAlbum like 'CASE LENGTH(TRIM(strAlbum)) WHEN 0 THEN ''---'' ELSE strAlbum END;' group by strAlbum, strAlbumArtist  order by strAlbum asc, Filter: album

So it does not work that way, the only way is to leave the field blank, but if it does not work, then there are no options. Need change the logic in the MP itself. Or write in the tags album (like single) and filter it here.

 

[joEhSuper]

Thanks @ajs !

 

[ajs]

@joEhSuper Have you tried selecting the <> operator and leaving the restrictions blank? Judging by the source code, it should work. If you can try and give me a log, I'll see what the problem is there.

 

[ajs]

@joEhSuper Nah, there's a plug for that... So it won't work... Sorry

 

[hwahrmann]

Sorry guys, i was a few days away from PC and just noticed this now.
it is years since i looked into that logic.
Theroatically it should work, but i need to check it.

i will not have time before 6.1.2021.
remind me after that, if you haven't heard from me

 

[ajs]

Theroatically it should work, but i need to check it.

Judging by the code no, an empty value is discarded in the analysis, and all SQL expressions are wrapped in single quotes.
Happy New Year

 

[joEhSuper]

i will not have time before 6.1.2021.
remind me after that, if you haven't heard from me

@hwahrmann ... reminder?