Database views - please teach me how (1 Viewer)

[emphatic]

Using <> gives me ALL genres. I'm trying to use "|Barn|" with "like" now. I still want to know what these mean exactly, <, >, <=, etc. It should be in the Wiki!

Emph

 

[Deda]

Those are logic operators related to selected database field. As they are "stupid" you can see them all no matter of what type is db field, so, for example, genre is type "string" but you see all operators <,>,<=.... and you see that many of them can't be logically applied on string but you have them on list

So,
< means "less than" (no usable for string fields)
> means "greater than" (no usable for string fields)
<= means "less than or equal" (no usable for string fields)
= means "equal"
...
LIKE means "search in field result string my string"

 

[emphatic]

With LIKE and |Barn|, I did get some results finally. Anyway, I've made a feature request in the MovPicNFO thread to clean up the genre handling. Hopefully it'll happen.

Emph

 

[Deda]

Just to inform you, recently I've added "|" separator for genres and imdbId tag "<id>" recognition so it should be ok now.


https://github.com/MediaPortal/MediaPortal-1/commit/ef1775583abc9b371605bb9a9ad18ab57b2216fd

 

[emphatic]

That's fantastic, is this a change to the nfo scaper so I can just update the scripts, or is it a change to MediaPortal's core features?

Emph

 

[Deda]

In MP itself, it should be available in next test build from Elliot.

 

[emphatic]

I've imported again now, and it works beautifully! I will have to clear my database though, as it seems that as the older entries in the database are in there as well.

Emph