Music Views - How to work with Operator (1 Viewer)

[ajs]

But sadly it still doesn't work...

Set <> '' run MP goto music and give Mediaportal.log (Debug mode) ...

 

[joEhSuper]

 

[ajs]

Hmmm, this problem: ''''''

SQL: select * from tracks where  strAlbum <> '''''' group by strAlbum, strAlbumArtist  order by strAlbum asc, Filter: album

Maybe need this field leave blank, i.e. do not enter anything there ...

 

[ajs]

Or try this: <>

ifnull(length(strAlbum), 0) = 0

 

[joEhSuper]

Ooooo K?!? Just to be sure...
You want me to write this into the restriction field: ifnull(length(strAlbum), 0) = 0

 

[ajs]

Yes if empty field not work

-- Tapatalk | WBR, ajs

 

[joEhSuper]

I'm really sorry - but it's still the same

 

[joEhSuper]

 

[ajs]

@joEhSuper I think i found solution:
Operator: =
Restriction:

CASE LENGTH(TRIM(strAlbum)) WHEN 0 THEN '---' ELSE strAlbum END;

 

[joEhSuper]

CASE LENGTH(TRIM(strAlbum)) WHEN 0 THEN '---' ELSE strAlbum END;

Now the album list is emty